Exam 25: Statistical Functions: Hands On Exercise Videos

The Analysis Toolpak is a plug-in that has to be added to Excel.

To perform an analysis of variance,you use the ________ tool.

To analyze the trend between SAT scores and attendance,you would calculate the ________.

Which of the following is NOT an Analysis Toolpak tool?

The ________ function measures the dispersion of the sample data around the mean.

The SUMIF function is used when finding a total having more than one criterion.

A sample dataset is a smaller portion of the population dataset.

Which of the following functions assigns the same rank for duplicate values?

Which of the following is NOT a math and statistical function?

To calculate the number of high school teachers that were hired before 1/1/2005,you would use the COUNT function.

A PivotChart is a visual display of tabulated frequencies.

To determine percentage of absences in the ranges 0,1 to 5,and more than 6,you would use the FREQUENCY function.

When identical values exist,the RANK.AVG function displays the average rank.

When manually typing criteria such as a date in a function,you must enclose the criteria with ________.

The QUARTILE.EXC functions returns values in the range: ________.

Which of the following is NOT a descriptive statistical function?

To test to see if there is a relationship between test scores and attendance,you would use the ________ function.