Question 1

________ 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 2

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

Accepted Answer

The answer of The ________ function returns the forecasted values...

Question 3

The Greek letter mu is the symbol for standard deviation.

Accepted Answer

A) True 
 B)False

Question 4

The ________ function returns the length of the repetitive pattern Excel detects for the time series.

Accepted Answer

FORECAST.E

Question 5

In SUMIFS, AVERAGEIFS and COUNTIFS functions, you must have a(n)________ argument for each criteria_range argument.

Accepted Answer

The answer of In SUMIFS, AVERAGEIFS and COUNTIFS functions, you...

Question 6

The CORREL function would be useful to determine the strength of a relationship between two variables.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Excel 2016 has NO new functions in the Analysis ToolPak.

Accepted Answer

A) True 
 B)False

Question 9

The RANK.EQ function returns ________.

Accepted Answer

A) the rank of a value within a dataset, giving an average ranking to tied values 
B) the rank of a value within a dataset, giving the highest ranking possible to ties 
C) the rank of a value within a dataset, throwing out ties 
D) the rank of a value within a dataset, giving the same ranking to tied values 
A) the rank of a value within a dataset, giving an average ranking to tied values 
B) the rank of a value within a dataset, giving the highest ranking possible to ties 
C) the rank of a value within a dataset, throwing out ties 
D) the rank of a value within a dataset, giving the same ranking to tied values

Question 10

Relative Standing measures ________.

Accepted Answer

A) the median of a dataset 
B) the rank value of the quartiles of a dataset 
C) the standard deviation of a dataset 
D) the rank of one value with regard to other values in a dataset 
A) the median of a dataset 
B) the rank value of the quartiles of a dataset 
C) the standard deviation of a dataset 
D) the rank of one value with regard to other values in a dataset

Question 11

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 12

This formula will successfully count all green items in the range C2:C256.
=COUNTIF(C2:C256,green)

Accepted Answer

A) True 
 B)False

Question 13

The ________ is an add-in program that provides statistical analysis tools.

Accepted Answer

Analysis ToolPak, Analysis Too

Question 14

Which function would you use to test for a relationship between students' attendance and their test scores?

Accepted Answer

A) CORREL 
B) RELATE.S 
C) RELATE.P 
D) VARPA 
A) CORREL 
B) RELATE.S 
C) RELATE.P 
D) VARPA

Question 15

STDEV.S calculates the standard deviation of a sample.

Accepted Answer

A) True 
 B)False

Question 16

This is the first 4 lines of an excel list of 3082 records. Which formula counts the number of Gold Level Members in the entire list?

Accepted Answer

A) =COUNTIF(A2:A3083,"Gold") 
B) =COUNTIFS(A2:A3083,"Gold") 
C) =COUNTIF(E2:E3083,"Gold") 
D) =COUNTIFS(A2:E3083,"Gold") 
A) =COUNTIF(A2:A3083,"Gold") 
B) =COUNTIFS(A2:A3083,"Gold") 
C) =COUNTIF(E2:E3083,"Gold") 
D) =COUNTIFS(A2:E3083,"Gold")

Question 17

To determine how often a value occurs in a dataset, use the SUMIFS function.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is the Criteria2 argument of: =COUNTIFS(A2:A64,"Blue",B2:B64,"Black")?

Accepted Answer

A) "Blue" 
B) B2:B64 
C) "Black" 
D) A2:A64 
A) "Blue" 
B) B2:B64 
C) "Black" 
D) A2:A64

Question 20

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...

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

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

The Greek letter mu is the symbol for standard deviation.

The ________ function returns the length of the repetitive pattern Excel detects for the time series.

In SUMIFS, AVERAGEIFS and COUNTIFS functions, you must have a(n)________ argument for each criteria_range argument.

The CORREL function would be useful to determine the strength of a relationship between two variables.

Excel 2016 has NO new functions in the Analysis ToolPak.

The RANK.EQ function returns ________.

Relative Standing measures ________.

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?

This formula will successfully count all green items in the range C2:C256. =COUNTIF(C2:C256,green)

The ________ is an add-in program that provides statistical analysis tools.

Which function would you use to test for a relationship between students' attendance and their test scores?

STDEV.S calculates the standard deviation of a sample.

This is the first 4 lines of an excel list of 3082 records. Which formula counts the number of Gold Level Members in the entire list?

To determine how often a value occurs in a dataset, use the SUMIFS function.

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

What is the Criteria2 argument of: =COUNTIFS(A2:A64,"Blue",B2:B64,"Black")?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 8: Statistical Functions

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

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

The Greek letter mu is the symbol for standard deviation.

The ________ function returns the length of the repetitive pattern Excel detects for the time series.

In SUMIFS, AVERAGEIFS and COUNTIFS functions, you must have a(n)________ argument for each criteria_range argument.

The CORREL function would be useful to determine the strength of a relationship between two variables.

Excel 2016 has NO new functions in the Analysis ToolPak.

The RANK.EQ function returns ________.

Relative Standing measures ________.

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?

This formula will successfully count all green items in the range C2:C256. =COUNTIF(C2:C256,green)

The ________ is an add-in program that provides statistical analysis tools.

Which function would you use to test for a relationship between students' attendance and their test scores?

STDEV.S calculates the standard deviation of a sample.

This is the first 4 lines of an excel list of 3082 records. Which formula counts the number of Gold Level Members in the entire list?

To determine how often a value occurs in a dataset, use the SUMIFS function.

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

What is the Criteria2 argument of: =COUNTIFS(A2:A64,"Blue",B2:B64,"Black")?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters