Question 1

The ________ function measures the dispersion of the sample data around the mean.&#10;A)CORREL&#10;B)FREQUENCY&#10;C)STDEV.S&#10;D)VAR.S

Accepted Answer

D

Question 2

When manually typing criteria such as a date in a function,you must enclose the criteria with ________.&#10;A)number signs (#)&#10;B)quotation marks (&#34;)&#10;C)ampersands (@)&#10;D)asterisks (*)

Accepted Answer

When manually typing criteria such as a date in a function, you must enclose the criteria with quotation marks ("). This is because dates are considered text strings in many spreadsheet functions.

Question 3

Which of the following is NOT a math and statistical function?&#10;A)COUNTIF&#10;B)AVERAGEIF&#10;C)SUMIF&#10;D)MEDIANIF

Accepted Answer

MEDIANIF is not a valid Excel function. There is no such function as MEDIANIF in Excel. The correct function is MEDIAN. The other three functions, COUNTIF, AVERAGEIF, and SUMIF are valid Excel functions used to count, average, and sum data based on certain criteria.

Question 4

The SUMIF function is used when finding a total having more than one criterion.

Accepted Answer

The SUMIF function is used for finding a total based on a single criterion; for multiple criteria, the SUMIFS function is used.

Question 5

When identical values exist,the RANK.AVG function displays the average rank.

Accepted Answer

The RANK.AVG function is designed to handle ties (when identical values exist), and it assigns each tied value the average of their ranks.

Question 6

To analyze the trend between SAT scores and attendance,you would calculate the ________.&#10;A)median&#10;B)standard deviation&#10;C)covariance&#10;D)variance

Accepted Answer

To analyze the trend between SAT scores and attendance, we need to calculate covariance. Covariance measures the relationship between two variables, in this case, SAT scores and attendance. It helps us determine whether the two variables move in the same direction (positive covariance) or in opposite directions (negative covariance). The median, standard deviation, and variance are measures of central tendency, variability, and dispersion, respectively, and do not focus on the relationship between two variables.

Question 7

To perform an analysis of variance,you use the ________ tool.&#10;A)ANOVA&#10;B)VAR&#10;C)CORREL&#10;D)COVARIANCE

Accepted Answer

ANOVA (Analysis of Variance) is the correct tool to use for analyzing the differences between two or more groups or treatments. It examines the variation within and between groups to determine whether the differences are statistically significant. VAR (Variance) is a measure of the spread of a data set and is not appropriate for performing an ANOVA. CORREL (Correlation) and COVARIANCE (Covariance) are measures of the relationship between two variables and are not appropriate for performing an ANOVA.

Question 8

To calculate the number of high school teachers that were hired before 1/1/2005,you would use the COUNT function.

Accepted Answer

The COUNT function counts the number of cells in a range that contain numerical values. It cannot be used to determine when a teacher was hired.

Question 9

Which of the following functions assigns the same rank for duplicate values?&#10;A)RANK&#10;B)RANK.AVG&#10;C)RANK.EQ&#10;D)RANK.DUP

Accepted Answer

RANK.EQ assigns the same rank to duplicate values, unlike RANK.AVG which assigns the average rank to duplicates.

Question 10

To test to see if there is a relationship between test scores and attendance,you would use the ________ function.&#10;A)STDEV.S&#10;B)CORREL&#10;C)STDEV.P&#10;D)FREQUENCY

Accepted Answer

The CORREL function is used to calculate the correlation coefficient, which indicates the strength and direction of a linear relationship between two variables, in this case, test scores and attendance.

Question 11

The Analysis Toolpak is a plug-in that has to be added to Excel.

Accepted Answer

The answer of The Analysis Toolpak is a plug-in that...

Question 12

A PivotChart is a visual display of tabulated frequencies.

Accepted Answer

The answer of A PivotChart is a visual display of...

Question 13

Which of the following is NOT an Analysis Toolpak tool?&#10;A)Analysis of variance&#10;B)Covariance&#10;C)Histogram&#10;D)Standard deviation

Accepted Answer

The answer of Which of the following is NOT an...

Question 14

To determine percentage of absences in the ranges 0,1 to 5,and more than 6,you would use the FREQUENCY function.

Accepted Answer

The answer of To determine percentage of absences in the...

Question 15

Which of the following is NOT a descriptive statistical function?&#10;A)DAVERAGE&#10;B)STDEV.P&#10;C)VAR.S&#10;D)FREQUENCY

Accepted Answer

The answer of Which of the following is NOT a...

Question 16

A sample dataset is a smaller portion of the population dataset.

Accepted Answer

The answer of A sample dataset is a smaller portion...

Question 17

The QUARTILE.EXC functions returns values in the range:&#10;________.&#10;A)0 to 4&#10;B)1 to 4&#10;C)0 to 3&#10;D)1 to 3

Accepted Answer

The answer of The QUARTILE.EXC functions returns values in the...

Deck 25: Statistical Functions: Hands On Exercise Videos