Podcast
Questions and Answers
Which function calculates the average of the absolute deviations of data points from their mean?
Which function calculates the average of the absolute deviations of data points from their mean?
- AVERAGEIF
- AVERAGEA
- AVEDEV (correct)
- AVERAGE
What does the COUNTIFS function do?
What does the COUNTIFS function do?
- Counts the number of cells within a range that meet multiple criteria (correct)
- Counts the number of blank cells within a range
- Counts how many values are in the list of arguments, including numbers and text
- Counts how many numbers are in the list of arguments
Which function returns the correlation coefficient between two data sets?
Which function returns the correlation coefficient between two data sets?
- CORREL (correct)
- COUNT
- COUNTA
- COVARIANCE.P
What does the GROWTH function do?
What does the GROWTH function do?
Which function returns the intercept of the linear regression line?
Which function returns the intercept of the linear regression line?