Question 1

This is the top three lines in a list of 8200 records.You want an average of the number of speeding tickets for Red Toyota Priuses.Which is the correct formula?

Accepted Answer

A) =AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
B) =AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
C) =AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
D) =AVERAGEIF(E2:E8201,"Red","Toyota","Prius") 
A) =AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
B) =AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
C) =AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
D) =AVERAGEIF(E2:E8201,"Red","Toyota","Prius")

Question 2

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

Accepted Answer

A) RANK.EQ 
B) RANK.AVG 
C) RANK.TIE 
D) AVERAGERANK 
A) RANK.EQ 
B) RANK.AVG 
C) RANK.TIE 
D) AVERAGERANK

Question 3

A(n)________ is a visual display of tabulated frequencies.

Accepted Answer

The answer of A(n)________ is a visual display of tabulated...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) histogram 
B) ANOVA 
C) correlation coefficient 
D) mu 
A) histogram 
B) ANOVA 
C) correlation coefficient 
D) mu

Question 6

The ________ function returns a value's rank as a percent between 0% and 100%.

Accepted Answer

The answer of The ________ function returns a value's rank...

Question 7

Sort data in ________ order before beginning a forecast analysis.

Accepted Answer

chronologi

Question 8

Match between columns
                        Premises: VARPA
CORREL
FREQUENCY
BINS
STDEVPA

Accepted Answer

The Answer of Variance of a population including logical values is...

Question 9

Match between columns
                        Premises: COUNTIF
SUMIFS
AVERAGEIF
COUNTIFS
SUMIF

Accepted Answer

The Answer of Calculates the number of cells in a is...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Which of the following represents the number of data points in a sample minus one?

Accepted Answer

A) F ratio 
B) Probability 
C) Degrees of Freedom 
D) Critical value 
A) F ratio 
B) Probability 
C) Degrees of Freedom 
D) Critical value

Question 12

The ________ function is best suited to calculate quartiles including quartiles 0 and 4.

Accepted Answer

The answer of The ________ function is best suited to...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of ________ is the measure of how far...

Question 15

________ is a measure of a dataset's dispersion or the difference between the highest and lowest values.

Accepted Answer

The answer of ________ is a measure of a dataset's...

Question 16

Which of the following functions determines the standard deviation of a sample?

Accepted Answer

A) STDEVA 
B) VARA 
C) STDEV.P 
D) STDEV.S 
A) STDEVA 
B) VARA 
C) STDEV.P 
D) STDEV.S

Question 17

What would be the result of this formula:
=AVERAGEIF(A2:
A64,"Green",C2:
C64)?

Accepted Answer

A) An average of the values in the C and A columns when the values in the B column are Green 
B) There isn't enough information here to tell. 
C) An average of the values in the A column when the values in the C column are Green 
D) An average of the values in the C column when the values in the A column are Green 
A) An average of the values in the C and A columns when the values in the B column are Green 
B) There isn't enough information here to tell. 
C) An average of the values in the A column when the values in the C column are Green 
D) An average of the values in the C column when the values in the A column are Green

Question 18

What is the common name for the square root of the variance?

Accepted Answer

A) Correlation coefficient 
B) P-value 
C) Standard deviation 
D) T-test 
A) Correlation coefficient 
B) P-value 
C) Standard deviation 
D) T-test

Question 19

Which of the following values would demonstrate the strongest positive relationship while using the CORREL function?

Accepted Answer

A) 0 
B) 0)5 
C) -1 
D) 1 
A) 0 
B) 0)5 
C) -1 
D) 1

Question 20

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

Accepted Answer

The answer of ________ is a statistical hypothesis test that...

This is the top three lines in a list of 8200 records.You want an average of the number of speeding tickets for Red Toyota Priuses.Which is the correct formula?

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

A(n)________ is a visual display of tabulated frequencies.

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

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

The ________ function returns a value's rank as a percent between 0% and 100%.

Sort data in ________ order before beginning a forecast analysis.

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

Which of the following represents the number of data points in a sample minus one?

The ________ function is best suited to calculate quartiles including quartiles 0 and 4.

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

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

________ is a measure of a dataset's dispersion or the difference between the highest and lowest values.

Which of the following functions determines the standard deviation of a sample?

What would be the result of this formula: =AVERAGEIF(A2: A64,"Green",C2: C64)?

What is the common name for the square root of the variance?

Which of the following values would demonstrate the strongest positive relationship while using the CORREL function?

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 8: Statistical Functions

This is the top three lines in a list of 8200 records.You want an average of the number of speeding tickets for Red Toyota Priuses.Which is the correct formula?

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

A(n)________ is a visual display of tabulated frequencies.

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

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

The ________ function returns a value's rank as a percent between 0% and 100%.

Sort data in ________ order before beginning a forecast analysis.

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

Which of the following represents the number of data points in a sample minus one?

The ________ function is best suited to calculate quartiles including quartiles 0 and 4.

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

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

________ is a measure of a dataset's dispersion or the difference between the highest and lowest values.

Which of the following functions determines the standard deviation of a sample?

What would be the result of this formula: =AVERAGEIF(A2: A64,"Green",C2: C64)?

What is the common name for the square root of the variance?

Which of the following values would demonstrate the strongest positive relationship while using the CORREL function?

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters