Exam 25: Excel: Statistical Functions

The PERCENTILE.INC function includes the 0 and 100th percentile.

Which of the following is a new statistical function in Excel 2013?

The ________ is best suited to measure the strength of the relationship between credit score and salary.

Which of the following is not included in an ANOVA summary report?

Which of the following functions is best suited to calculate the covariance of a population?

What function is best suited to determine how often a set of numbers appears within a dataset?

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

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

The second quartile of both QUARTILE.EXC and QUARTILE.INC defines what percentile?

VAR.P is included in the Analysis ToolPak.

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

A ________ is a visual display of tabulated frequencies.

When active,where does the Analysis ToolPak appear?

Which function would be best used to determine the rank of each student in a graduating high school class?

Identify the statistical function used if the rank value returned for duplicate values was 8.5?

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

A smaller more manageable portion of the population is called a ________.

What does the order argument of the RANK.EQ function define?

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