Question 1

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

Accepted Answer

Inferential

Question 2

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.

Accepted Answer

Forecast

Question 3

What function returns the variance of a population?

Accepted Answer

A) VARA 
B) VAR.P 
C) VAR.S 
D) VARPA 
A) VARA 
B) VAR.P 
C) VAR.S 
D) VARPA B

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

The ________ function calculates the average,or arithmetic mean,of all cells in a range that meet a specific condition.

Accepted Answer

The answer of The ________ function calculates the average,or arithmetic...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) 4 
B) 0 
C) 2 
D) 5 
A) 4 
B) 0 
C) 2 
D) 5

Question 9

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?

Accepted Answer

A) PERCENTILE.INC 
B) PERCENTILE.EXC 
C) PERCENTRANK.INC 
D) PERCENTRANK.EXC 
A) PERCENTILE.INC 
B) PERCENTILE.EXC 
C) PERCENTRANK.INC 
D) PERCENTRANK.EXC

Question 10

The VARPA function calculates the variance of a population for numerical values.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The Answer of The number of data points in the is...

Question 12

The Greek letter mu is the symbol for standard deviation.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is an Excel Add-in?

Accepted Answer

A) Analysis ToolPak 
B) Frequency 
C) Standard deviation 
D) ANOVA 
A) Analysis ToolPak 
B) Frequency 
C) Standard deviation 
D) ANOVA

Question 14

Match between columns
                        Premises: Criteria2
Sum_range
Criteria
Criteria_range1
AVERAGEIFS

Accepted Answer

The Answer of The function which returns the average of is...

Question 15

The ________ is the probability of a population being similarity to a sample.

Accepted Answer

The answer of The ________ is the probability of a...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

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

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.

What function returns the variance of a population?

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

The RANK.EQ function returns ________.

The ________ function calculates the average,or arithmetic mean,of all cells in a range that meet a specific condition.

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

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

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 VARPA function calculates the variance of a population for numerical values.

The Greek letter mu is the symbol for standard deviation.

Which of the following is an Excel Add-in?

The ________ is the probability of a population being similarity to a sample.

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

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

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

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

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

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

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

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.

What function returns the variance of a population?

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

The RANK.EQ function returns ________.

The ________ function calculates the average,or arithmetic mean,of all cells in a range that meet a specific condition.

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

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

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 VARPA function calculates the variance of a population for numerical values.

The Greek letter mu is the symbol for standard deviation.

Which of the following is an Excel Add-in?

The ________ is the probability of a population being similarity to a sample.

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

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

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

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

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

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