Exam 8: Statistical Functions

The VARPA function calculates the variance of a population for numerical values.

A(n)________ is a visual display of tabulated frequencies.

If you autofill the formula =RANK.AVG(A1,$A$1:$A$5,0)from B1 to B5, what would the value be in B5?

The ________ function counts the number of cells in a range that meet multiple criteria.

Which function would you use to determine the number of occurrences of a particular value in a dataset?

Which of the following represents the number of data points in a sample minus one?

A histogram requires ________ to tabulate data and return a frequency distribution table.

What is the common name for the square root of the variance?

What function returns the variance of a population?

Which of the following values would demonstrate the strongest positive relationship while using the CORREL function?

The ________ function returns a value's rank as a percent between 0% and 100%.

Sum_range is the argument in the ________ function that is added together if a single condition is met.

The ________ function is best suited to calculate quartiles including quartiles 0 and 4.

What are the two arguments for the FREQUENCY function?

The ________ is the square root of the variance.

A(n)________ is a business intelligence tool which extrapolates future values based on current trends.

Two or more conditions can be used with SUMIFS function.

To count the number of Finance majors in a list of students and their college majors, use the ________ function.