Deck 25: Excel: Statistical Functions

Question 1

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

Answer 1

C

Question 2

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

Answer 2

B

Question 3

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

Answer 3

C

Question 4

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

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

Question 5

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

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

Question 6

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 7

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

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

Question 8

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 9

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

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

Question 10

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 11

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

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

Question 12

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

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

Question 13

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

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

Question 14

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 15

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

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

Question 16

Which of the following is not a statistical function?

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

Question 17

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

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

Question 18

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 19

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 20

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

Question 21

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

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

Question 22

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 23

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

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

Question 24

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 25

When active,where does the Analysis ToolPak appear?

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

Question 26

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

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

Question 27

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 28

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 29

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 30

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 31

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 32

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 33

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 34

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 35

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 36

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 37

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

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

Question 38

The Analysis ToolPak can be activated in:

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

Question 39

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

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

Question 40

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

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

Question 41

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

Question 42

The QUARTILE.EXC function excludes quartiles 0 and 4.

Question 43

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

Question 44

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

Question 45

The PERCENTRANK.INC function excludes 0 and 1.

Question 46

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

Question 47

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

Question 48

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

Question 49

By default the Analysis ToolPak is active.

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

STDEV.S calculates the standard deviation of a sample.

Question 56

The FREQUENCY function can count words.

Question 57

The Analysis ToolPak appears in the Data tab.

Question 58

VAR.P is included in the Analysis ToolPak.

Question 59

Histogram is a tool of the Analysis ToolPak.

Question 60

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

Question 61

The .EXC descriptor in PERCENTRANK.EXC stands for:

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

________ is a tool included in the Analysis ToolPak.

Question 68

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

Question 69

The ________ function calculates the variance of a population.

Question 70

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

Question 71

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

Question 72

A ________ is a visual display of tabulated frequencies.

Question 73

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

Question 74

The ________ is the square root of the variance.

Question 75

By default,the FREQUENCY function includes numerical outliers.

Question 76

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

Question 77

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

Question 78

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

Question 79

ANOVA stands for ________.

Question 80

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