STATISTICS FOR MANAGERS USING
MICROSOFT EXCEL FINAL PAPER 2026
SOLVED QUESTIONS WITH FULL SOLUTION
ALREADY PASSED
◉ What is the standard deviation of the following set of scores? 10,
15, 12, 18, 19, 16, 12
Answer: 3.36
◉ When calculating the standard deviation, what must be done in
order to obtain an unbiased estimate of the population?
Answer: subtract 1 from n
◉ In the formula for computing the variance, what does the letter
"n" represent?
Answer: sample size
◉ What is the range of the following set of scores? 10, 15, 12, 18, 19,
16, 12
Answer: 9
◉ What is obtained by squaring the standard deviation?
,Answer: variance
◉ Which of the following Excel functions will allow you to examine
the symmetry of a set of scores?
Answer: SKEW(A1:A20)
◉ Excel uses "bins" to create a frequency distribution. The bin value
is
Answer: the maximum value (upper limit) for a given category
◉ What type of graph displays class intervals along an x-axis?
Answer: Histogram
◉ When observations can only be included in one category (and not
more than one), we refer to the categories as
Answer: mutually exclusive
◉ The point halfway between the boundaries of each class interval
in a
grouped frequency distribution is called the __________.
Answer: class mark
, ◉ What do you call a continuous line that represents the frequency
of scores within a class interval?
Answer: Polygon
◉ What is the specific term associated with how flat a distribution
appears?
Answer: platykurtic
◉ According to the PowerPoint slides, you should group your data
into no fewer than __ groups and no more than __ groups.
Answer: 3, 10
◉ The width of each bar in a histogram corresponds to the
Answer: differences between the boundaries of the class.
◉ If the correlation between variables is .70, what percent of the
variance is shared variance?
Answer: 49%
◉ What test would you want to use to test a nondirectional research
hypothesis?
Answer: Two-tailed test
MICROSOFT EXCEL FINAL PAPER 2026
SOLVED QUESTIONS WITH FULL SOLUTION
ALREADY PASSED
◉ What is the standard deviation of the following set of scores? 10,
15, 12, 18, 19, 16, 12
Answer: 3.36
◉ When calculating the standard deviation, what must be done in
order to obtain an unbiased estimate of the population?
Answer: subtract 1 from n
◉ In the formula for computing the variance, what does the letter
"n" represent?
Answer: sample size
◉ What is the range of the following set of scores? 10, 15, 12, 18, 19,
16, 12
Answer: 9
◉ What is obtained by squaring the standard deviation?
,Answer: variance
◉ Which of the following Excel functions will allow you to examine
the symmetry of a set of scores?
Answer: SKEW(A1:A20)
◉ Excel uses "bins" to create a frequency distribution. The bin value
is
Answer: the maximum value (upper limit) for a given category
◉ What type of graph displays class intervals along an x-axis?
Answer: Histogram
◉ When observations can only be included in one category (and not
more than one), we refer to the categories as
Answer: mutually exclusive
◉ The point halfway between the boundaries of each class interval
in a
grouped frequency distribution is called the __________.
Answer: class mark
, ◉ What do you call a continuous line that represents the frequency
of scores within a class interval?
Answer: Polygon
◉ What is the specific term associated with how flat a distribution
appears?
Answer: platykurtic
◉ According to the PowerPoint slides, you should group your data
into no fewer than __ groups and no more than __ groups.
Answer: 3, 10
◉ The width of each bar in a histogram corresponds to the
Answer: differences between the boundaries of the class.
◉ If the correlation between variables is .70, what percent of the
variance is shared variance?
Answer: 49%
◉ What test would you want to use to test a nondirectional research
hypothesis?
Answer: Two-tailed test
