Deck 29: Statistical Functions

Question 1

Which of the following functions will determine the standard deviation of a sample?

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

Answer 1

B

Question 2

Which function is best suited to calculate quartiles including quartiles 0 and 4?

A)QUARTILE.EXC
B)QUARTILE.INC
C)QUART
D)RANK.AVG

Answer 2

B

Question 3

Which of the following functions will rank two values evenly if there is a duplicate value present?

A)RANK.EQ
B)RANK.AVG
C)RANK
D)PERCENTILE

Answer 3

A

Question 4

Which of the following functions is best suited to count numbers based on multiple conditions?

A)SUMIF
B)COUNTIF
C)COUNTIFS
D)SUMIFS

Question 5

Which of the following functions will exclude quartiles 0 and 4 in its calculations?

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

Question 6

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset?

A)0
B)1
C)2
D)3

Question 7

Which of the following percentiles is excluded when using the PERCENTILE.EXC function?

A)0
B)25th
C)50th
D)75th

Question 8

Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present?

A)RANK.EQ
B)RANK.AVG
C)RANK
D)PERCENTILE

Question 9

How many condition arguments can be defined with the SUMIF function?

A)1
B)2
C)3
D)unlimited

Question 10

Identify the statistical function used if the rank value returned for duplicate values was 8.5?

A)RANK.AVG
B)RANK.EQ
C)RANK.SP
D)RANK

Question 11

Which function is best suited to determine how the data set is spread around the mean?

A)COVARIANCE
B)CORREL
C)STDEV.P
D)VARA

Question 12

Which of the following will determine the variance of a population?

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

Question 13

The second quartile of both QUARTILE.EXC and QUARTILE.INC defines what percentile?

A)25th
B)50th
C)75th
D)0

Question 14

Which of the following is not a statistical function?

A)AVERAGEIF
B)MAX
C)COUNTIFS
D)DSUM

Question 15

Which of the following functions will help determine the strength of a relationship between two variables?

A)VARPA
B)STDEV.P
C)CORREL
D)VAR.P

Question 16

Which function is best suited to determine a student's test score percentile based on all class scores?

A)RANK.AVG
B)PERCENTRANK.EXC
C)AVERAGE
D)AVERAGEIFS

Question 17

What does the order argument of the RANK.EQ function define?

A)The lowest ranked value
B)The ranking stop value
C)The order in which numbers are ranked
D)The ranking order scale

Question 18

When using the QUARTILE.INC function which quartile would include the highest value in the dataset?

A)1
B)2
C)3
D)4

Question 19

Which of the following functions is best suited to add numbers based on one condition?

A)SUMIFS
B)SUMIF
C)COUNTIF
D)COUNTIFS

Question 20

Which of the following is not a function for measuring central tendency?

A)CORREL
B)STDEV.P
C)VAR.P
D)SUMIFS

Question 21

Which of the following is not included in an ANOVA summary report?

A)SS
B)df
C)MS
D)TF

Question 22

When using the QUARTILE.INC function a quartile of 3 represents which percentile?

A)25th
B)50th
C)75th
D)100th

Question 23

When active,where does the Analysis ToolPak appear?

A)Data tab
B)Formulas tab
C)View tab
D)Insert tab

Question 24

Which of the following functions is best suited to calculate the variance of a population including logical values and text?

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

Question 25

Which of the following functions is best suited to calculate the covariance of a population?

A)VARPA
B)COVAR
C)COVARIANCE.S
D)COVARIANCE.P

Question 26

Which function would be best used to determine the rank of each student in a graduating high school class?

A)RANK.EQ
B)RANK.AVG
C)QUARTILE.EXC
D)QUARTILE.INC

Question 27

Which of the following is included in an ANOVA summary report?

A)F crit
B)STDEV
C)Correlation
D)Covariance

Question 28

When using an array of data with the FREQUENCY function,the following keystroke is required.

A)Ctrl+Alt+Delete
B)Ctrl+Shift+Delete
C)Ctrl+Shift+Enter
D)Ctrl+Enter

Question 29

Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?

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

Question 30

Which of the following is not an ANOVA calculation that can be performed?

A)Single-factor
B)Two-factor with replication
C)Two-factor without replication
D)Two-tail

Question 31

Which of the following is a new statistical function in Excel 2013?

A)Skew.P
B)STDEV.P
C)VARPA
D)CORREL

Question 32

The Analysis ToolPak can be activated in:

A)Formula tab.
B)Excel Options.
C)Review tab.
D)Developer tab.

Question 33

What function is best suited to determine how often a set of numbers appears within a dataset?

A)SUMIF
B)FREQUENCY
C)SUMIFS
D)AVERAGEIF

Question 34

When using the CORREL function,a value of .00007 would indicate:

A)a weak relationship.
B)a strong relationship.
C)an inverse relationship.
D)no relationship.

Question 35

When using the CORREL function a value of 1 would indicate:

A)a weak relationship.
B)a mild relationship.
C)a strong relationship.
D)no relationship.

Question 36

This function is best suited to determine ranks within a data set based on percentile.

A)RANK.EQ
B)PERCENTRANK.INC
C)RANK.AVG
D)PERCENTILE

Question 37

Which of the following functions does not base its calculations on data samples?

A)STDEV.S
B)VARPA
C)VAR.S
D)STDEVA

Question 38

Which data analysis tool is best suited to measure how two sets of data vary simultaneously?

A)Histogram
B)Correlation
C)Covariance
D)Variance

Question 39

Which of the following tools is not included in the Analysis ToolPak?

A)Anova: Single Factor
B)Correlation
C)Rank Average
D)Covariance

Question 40

Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?

A)Correlation
B)Histogram
C)Descriptive Statistics
D)ANOVA

Question 41

Histograms can be created on a separate worksheet when using the Analysis ToolPak.

Question 42

The QUARTILE.EXC function excludes quartiles 0 and 4.

Question 43

If the number 0 is entered in the order argument of the RANK.AVG function the numbers will appear in ascending order.

Question 44

VAR.P is included in the Analysis ToolPak.

Question 45

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

Question 46

The PERCENTRANK.INC function excludes 0 and 1.

Question 47

STDEV.S calculates the standard deviation of a sample.

Question 48

The FREQUENCY function can count words.

Question 49

VARPA calculates the variance of a population including logical values and text.

Question 50

By default the Analysis ToolPak is active.

Question 51

The Analysis ToolPak appears in the Data tab.

Question 52

A CORREL value of .9 has a strong positive relationship.

Question 53

When using text for criteria in conditional logic functions,the text must be surrounded by double quotation marks.

Question 54

The SUMIF function could be used to add the total salaries of employees over the age of 25 in a dataset.

Question 55

When using the QUARTILE.INC function the 4th quartile would include the highest number value.

Question 56

When created using the Analysis ToolPak,histograms cannot be deleted.

Question 57

The PERCENTILE.EXC function is the best function to calculate the 25th percentile within a range of values.

Question 58

To complete a FREQUENCY function using an array the keystroke Ctrl+Enter must be used.

Question 59

Two or more conditions can be used with the SUMIFS function.

Question 60

Histogram is a tool of the Analysis ToolPak.

Question 61

The ________ is an Excel add-in that offers powerful tools for statistical analysis.

Question 62

The ________ function determines how often a set of numbers appears within a dataset.

Question 63

The ________ function is best suited to determine the number of high school students under the age of 16.

Question 64

A smaller more manageable portion of the population is called a ________.

Question 65

The ________ function calculates the variance of a population.

Question 66

A ________ is a visual display of tabulated frequencies.

Question 67

ANOVA stands for ________.

Question 68

The FREQUENCY function will count numbers that are outside the predetermined bins.

Question 69

The ________ function determines the strength of a relationship between two datasets.

Question 70

When using the RANK.AVG function the order argument determines the ________.

Question 71

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

Question 72

The PERCENTILE.INC function includes the 0 and 100th percentile.

Question 73

The ________ tool within the Analysis ToolPak can place its output on a blank worksheet.

Question 74

The ________ function returns the gamma value of a data set.

Question 75

By default,the FREQUENCY function includes numerical outliers.

Question 76

STDEV.P should be used to calculate standard deviation when all data for a population is present.

Question 77

________ is a tool included in the Analysis ToolPak.

Question 78

The ________ is the square root of the variance.

Question 79

The .EXC descriptor in PERCENTRANK.EXC stands for:

A)inclusive.
B)increment.
C)expert.
D)exclusive.

Question 80

In an ANOVA summary report,the degrees of freedom are equal to the number of data points in the sample - 1 (N - 1).