STATISTICS FOR MANAGERS USING
MICROSOFT EXCEL EXAM 2026 COMPLETE
QUESTION SET AND CORRECT ANSWERS
GRADED A PLUS
◉ If a student were to count the number and type of cars passing
through an intersection in a two hour period, she would be
collecting which type of random variable?
Answer: discrete
◉ What is a mathematical operator used to perform a mathematical
task called?
Answer: formula
◉ When surveying patient satisfaction and you are using the choices
"poor" to "excellent" you are using a
Answer: qualitative variable
◉ Which of the following is an example of an Excel formula for
taking the number 6 to the power of 2?
Answer: =6^2
,◉ The ____________ branch of statistics consists of methods that
enable the administrator to develop generalizations, estimations, or
predictions concerning the phenomenon of managerial interest.
Answer: inferential
◉ Which of the following is a discrete quantitative variable?
Answer: the number of employees of an insurance company
◉ Which of the following does NOT describe statistics?
Answer: A factor that exhibits variability, volatility or assumes
different values
◉ The political affiliation (republican, democrat, independent) of an
individual is an example of which type of variable?
Answer: categorical
◉ The universe or "totality of items or things" under consideration
is called a
Answer: population
◉ In the formula for computing the mean, what does the letter "X"
represent?
Answer: individual scores
, ◉ Which measure of central tendency is most appropriate for
samples where you DO NOT have extreme values and your data is
NOT categorical?
Answer: mean
◉ Which of the following is most sensitive to extreme values?
Answer: mean
◉ What is the mode of the following set of scores? 10, 15, 12, 18, 19,
16, 12
Answer: 12
◉ What is the mean of the following set of scores (round up)? 10, 15,
12, 18, 19, 16, 12
Answer: 15
◉ Which of the following is another way of representing the 75th
percentile?
Answer: Q3
◉ Which of the following is the correct function for calculating the
midpoint of a set of scores?
MICROSOFT EXCEL EXAM 2026 COMPLETE
QUESTION SET AND CORRECT ANSWERS
GRADED A PLUS
◉ If a student were to count the number and type of cars passing
through an intersection in a two hour period, she would be
collecting which type of random variable?
Answer: discrete
◉ What is a mathematical operator used to perform a mathematical
task called?
Answer: formula
◉ When surveying patient satisfaction and you are using the choices
"poor" to "excellent" you are using a
Answer: qualitative variable
◉ Which of the following is an example of an Excel formula for
taking the number 6 to the power of 2?
Answer: =6^2
,◉ The ____________ branch of statistics consists of methods that
enable the administrator to develop generalizations, estimations, or
predictions concerning the phenomenon of managerial interest.
Answer: inferential
◉ Which of the following is a discrete quantitative variable?
Answer: the number of employees of an insurance company
◉ Which of the following does NOT describe statistics?
Answer: A factor that exhibits variability, volatility or assumes
different values
◉ The political affiliation (republican, democrat, independent) of an
individual is an example of which type of variable?
Answer: categorical
◉ The universe or "totality of items or things" under consideration
is called a
Answer: population
◉ In the formula for computing the mean, what does the letter "X"
represent?
Answer: individual scores
, ◉ Which measure of central tendency is most appropriate for
samples where you DO NOT have extreme values and your data is
NOT categorical?
Answer: mean
◉ Which of the following is most sensitive to extreme values?
Answer: mean
◉ What is the mode of the following set of scores? 10, 15, 12, 18, 19,
16, 12
Answer: 12
◉ What is the mean of the following set of scores (round up)? 10, 15,
12, 18, 19, 16, 12
Answer: 15
◉ Which of the following is another way of representing the 75th
percentile?
Answer: Q3
◉ Which of the following is the correct function for calculating the
midpoint of a set of scores?
