FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Statistical Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

Both RANK.EQ and RANK.AVG functions have the same arguments.

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

________ is the measure of how far the data sample spreads from the mean.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

A(n) ________ is a visual depiction of a population distribution created by the Analysis ToolPak.

FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a forecasted value will happen.

Sort data in ________ order before beginning a forecast analysis.

Which of the following is an allowable quart argument in a QUARTILE.EXC function?

The k argument in a PERCENTILE function is a value from 0 to 1.

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

What is the sum_range argument of: =SUMIF(A2:A64,"Green",C2:C64) ?

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

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

Which function returns the rank of a value within a dataset, assigning an average rank for tied values?

________ returns the forecasted values for a specific future target date using exponential smoothing.

What is the first argument of an SUMIFS function?

Match each of the following concepts to its best description:

What is MS in an ANOVA summary report?

The Significance argument in a PERCENTRANK function is the input for confidence intervals.

What is SS in an ANOVA summary report?

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

The simplest method of creating a ________ is with the Analysis Toolpak