Exam 8: Statistical Functions

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

The CORREL function would be useful to determine the strength of a relationship between two variables.

The ________ function identifies a value's rank within a list of values,omitting the next rank in the case of tied values.

What is MS in an ANOVA summary report?

________ returns the forecasted values for a specific future target date using exponential smoothing.

When using the Function Arguments Box,Excel will ________.

What are the two arguments for the FREQUENCY function?

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

The simplest method of creating a ________ is with the Analysis Toolpak

This is the first 4 lines of an excel list of 3082 records. Which formula counts the number of Gold Level Members in the entire list?

Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.

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

In SUMIFS,AVERAGEIFS and COUNTIFS functions,you must have a(n)________ argument for each criteria_range argument.

What is F in an ANOVA summary report?

The ________ is the square root of the variance.

The ________ is an add-in program that provides statistical analysis tools.

The ________ function will use average values to determine the rank of a number within a list if tied values are present.

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

________ is a measure of how two sets of data vary simultaneously.