Question 1

STDEV.S calculates the standard deviation of a sample.

Accepted Answer

STDEV.S calculates the standard deviation of a sample, while STDEV.P calculates the standard deviation of an entire population.

Question 2

A Forecast worksheet is a business intelligence tool that projects trends based on historical data.

Accepted Answer

A Forecast worksheet is indeed a business intelligence tool that projects trends based on historical data.

Question 3

ANOVA stands for analysis of variability.

Accepted Answer

ANOVA stands for analysis of variance, not analysis of variability.

Question 4

Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.

Accepted Answer

This is true. COVARIANCE.P calculates the population covariance while COVARIANCE.S calculates the sample covariance.

Question 5

Correlation is a tool included on the Analysis ToolPak.

Accepted Answer

Correlation is indeed a tool included on the Analysis ToolPak, which is an add-in for Microsoft Excel.

Question 6

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

Accepted Answer

The FORECAST.ETS function in Excel predicts a future value using Exponential Triple Smoothing, but it does not return a confidence interval for the forecast. Confidence intervals must be calculated separately.

Question 7

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

Accepted Answer

FORECAST.ETS.SEASONALITY returns the length of the seasonal pattern detected in the data, not the specific quarter a forecasted value will occur.

Question 8

Excel 2016 has NO new functions in the Analysis ToolPak.

Accepted Answer

Excel 2016 introduced four new functions in the Analysis ToolPak: Forecast, Forecast.ETS, Forecast.ETS.Confint, and Forecast.ETS.Seasonality.

Question 9

The Analysis ToolPak is available on the Insert Tab.

Accepted Answer

The Analysis ToolPak is an Excel add-in and is found under the "Data" tab, not the "Insert" tab.

Question 10

A histogram is a pie chart created by the Analysis ToolPak.

Accepted Answer

A histogram is not a pie chart. The Analysis ToolPak is used to create statistical analyses in Microsoft Excel, but it does not specifically create histograms (though it can aid in their creation).

Question 11

Match between columns
                        Premises: FORECAST.ETS.CONFINT
FORECAST.ETS
FORECAST.ETS.SEASONALITY
FORECAST.ETS.STAT
FORECAST.LINEAR

Accepted Answer

The Answer of Returns the forecasted values for a specific is...

Question 12

Match between columns
                        Premises: COVARIANCE.P
COVARIANCE.S
Random variation
Histogram
Critical value of F

Accepted Answer

The Answer of Measures how 2 sets of an entire is...

Question 13

Match between columns
                        Premises: Degrees of freedom
P-value
Sum of Squares
ANOVA
F ratio

Accepted Answer

The Answer of The mean square between/mean square within and is...

Question 14

Match between columns
                        Premises: Inferential Statistics
Population
Descriptive Statistics
Sample
Analysis ToolPak

Accepted Answer

The Answer of Defines characteristics of a population and Add-in is...

Question 15

Match between columns
                        Premises: FREQUENCY
VARPA
CORREL
BINS
STDEVPA

Accepted Answer

The Answer of Helps determine the strength of a relationship is...

Question 16

Match between columns
                        Premises: PERCENTRANK.INC
PERCENTRANK.EXC
RANK.AVG
RANK.EQ
QUARTILE.EXC

Accepted Answer

The Answer of A value's rank as a percent of is...

Question 17

Match between columns
                        Premises: Quartile 3
Quartile 2
Quartile 1
Quartile 4
Quartile 0

Accepted Answer

The Answer of The value at the 50th percentile and is...

Question 18

Match between columns
                        Premises: AVERAGEIFS
Criteria2
Criteria
Criteria_range1
Sum_range

Accepted Answer

The Answer of The range of values to be added is...

Question 19

Match between columns
                        Premises: COUNTIFS
AVERAGEIF
SUMIF
SUMIFS
COUNTIF

Accepted Answer

The Answer of Calculates the total of a range of is...

Question 20

Match between columns
                        Premises: Central tendency
Relative standing
Correlation
Multiple criteria
Conditional math

Accepted Answer

The Answer of Mathematical functions performed only on values which is...

Quiz 8: Statistical Functions

STDEV.S calculates the standard deviation of a sample.

A Forecast worksheet is a business intelligence tool that projects trends based on historical data.

ANOVA stands for analysis of variability.

Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.

Correlation is a tool included on the Analysis ToolPak.

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

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

Excel 2016 has NO new functions in the Analysis ToolPak.

The Analysis ToolPak is available on the Insert Tab.

A histogram is a pie chart created by the Analysis ToolPak.

Match each of the following concepts to its best description of its purpose:

Match each of the following concepts to its best description:

Match each of the following concepts to its best description:

Match each of the following terms to its description:

Match each of the following concepts to its best description:

Match each of the following concepts to its most likely application:

Match each of the following concepts to its most likely application:

Match each of the following concepts to its best description:

Match each of the following functions to its best description of its purpose:

Match each of the following concepts to its best description: