Exam 8: Statistical Functions

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

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

________ is the measure of how far the data sample spreads from the mean.

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

Sort data in ________ order before beginning a forecast analysis.

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

Which of the following is an allowable quart argument in a QUARTILE.EXC function?

What is MS in an ANOVA summary report?

FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a forecasted value will happen.

The Significance argument in a PERCENTRANK function is the input for confidence intervals.

A(n)________ is a visual depiction of a population distribution created by the Analysis ToolPak.

________ is a statistical hypothesis test that helps determine if samples of data were taken from the same population.

What is the first argument of an SUMIFS function?

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

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

Which function returns the rank of a value within a dataset, assigning an average rank for tied values?

The k argument in a PERCENTILE function is a value from 0 to 1.

What is SS in an ANOVA summary report?

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