Exam 8: Statistical Functions

ANOVA stands for analysis of variability.

In SUMIF,AVERAGEIF,and COUNTIF functions using text criteria,enclose the criteria in:

Which function returns the standard deviation of a population including logical values and text?

Both RANK.EQ and RANK.AVG functions have the same arguments.

Which of the following outputs from an ANOVA summary report is used to determine the significance of the F-Test?

________ determines how two sets of data from a sample vary simultaneously.

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

Why is it important to analyze the relationships between a sample and full population?

STDEV.S calculates the standard deviation of a sample.

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

Inferential statistics and Descriptive statistics are the same thing.

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

The ________ function returns the variance of a sample of numerical data

________ is a measure of how two set of data vary simultaneously and is calculated by taking the average of each product of the deviation of a data point.

Which of the following is not an ANOVA calculation type?

What is the sum_range argument of: =SUMIF(A2: A64,"Green",C2: C64)?

Correlation is a tool included on the Analysis ToolPak.

________ returns the forecasted values of a target date using exponential smoothing.