Exam 29: Statistical Functions

Which function is best suited to calculate quartiles including quartiles 0 and 4?

The SUMIF function could be used to add the total salaries of employees over the age of 25 in a dataset.

Which of the following functions is best suited to add numbers based on one condition?

The ________ function is best suited to return the rank as a percentage of students within a high school.

The FREQUENCY function will count numbers that are outside the predetermined bins.

By default,the FREQUENCY function includes numerical outliers.

The ________ of a sample is the summation of the squared deviations divided by the amount of the sample (n - 1).

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

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

In an ANOVA summary report,the degrees of freedom are equal to the number of data points in the sample - 1 (N - 1).

By default the Analysis ToolPak is active.

To complete a FREQUENCY function using an array the keystroke Ctrl+Enter must be used.

This function is best suited to determine ranks within a data set based on percentile.

The ________ is the square root of the variance.

Which data analysis tool is best suited to measure how two sets of data vary simultaneously?

The Analysis ToolPak can be activated in:

Which of the following functions is best suited to count numbers based on multiple conditions?