Exam 8: Statistical Functions

Inferential statistics and Descriptive statistics are the same thing.

A quartile is a value used to divide a range into five equal groups.

Which of the following outputs from an ANOVA summary report is used to determine the significance of the F-Test?

The ________ function returns the variance of a sample of numerical data

What is F in an ANOVA summary report?

The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.

The Analysis ToolPak is available on the Insert Tab.

Which of the following is an Excel Add-in?

A college admissions office might use which of the following functions to offer scholarships to incoming student who are in the top 10% of their high school classes?

The FREQUENCY function determines the strength of the relationship between two data sets.

________ statistics help analyze differences between groups and relationships within groups of data.

When using the Function Arguments Box, Excel will ________.

A(n)________ is a dataset that contains a manageable subset of a population.

=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black") Returns an average of Column C of the items which are either Blue or Black.

The ________ function identifies a value's rank within a list of values, omitting the next rank in the case of tied values.

The arguments for COUNTIFS, SUMIFS, AVERAGEIFS are Range and Criteria.

If you have 10 years of SAT data and 10 years of Teacher pay data and you'd like to see a trend that might predict their behavior in the future, you would create a ________ Sheet.

The PERCENTRANK.INC function displays a value's rank as a percentile of a range, including 0% and 100%.

________ is a measure of how two set of data vary simultaneously and is calculated by taking the average of each product of the deviation of a data point.