Exam 25: Excel: Statistical Functions

VARPA calculates the variance of a population including logical values and text.

The ________ is the range of cells that contain the values that are being evaluated for frequency of occurrence when using the FREQUENCY function.

The ________ function returns the gamma value of a data set.

Which of the following functions does not base its calculations on data samples?

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

The ________ function determines the strength of a relationship between two datasets.

The ________ function can be used to perform a single condition summary.

The ________ function determines how often a set of numbers appears within a dataset.

The ________ is a predefined set of numerical values that are used to organize and count data using the FREQUENCY function.

What is the difference between COVARIANCE and ANOVA?

Two or more conditions can be used with the SUMIFS function.

Which of the following is not an ANOVA calculation that can be performed?

When using the QUARTILE.INC function which quartile would include the highest value in the dataset?

The ________ function calculates the variance of a population.

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

Which function is best suited to determine a student's test score percentile based on all class scores?

ANOVA stands for ________.

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