CGS 2518 EXAM #1 CHAPTER #8
QUESTIONS AND ANSWERS
You hypothesize that there is a relationship between lack of regular exercise and
illness. To research this theory, you have compiled a sample set of data that contains
numbers of days in which an hour or more of exercise is completed as well as numbers
of days sick within a calendar year. What tools in Excel could you use to investigate the
relationships between the data?
a. CORREL
b. PERLENTRANK.INC
c. VAR.S
d. SUMIFS - Answer-a. CORREL
Which of the following functions has the ability to calculate the μ (MU) of a dataset
based on a user defined set of criteria?
a. AVERAGE
b. SUMIFS
c. COUNTIFS
d. AVERAGEIFS - Answer-d. AVERAGEIFS
What is the difference between STDEV.S and STDEV.P?
a. STDEV.S calculates standard deviation of a sample; STDEV.P calculates the
standard deviation of a population.
b. STDEV.P calculates the standard deviation of a population; STDEV.S calculates
average variation
c. STDEV.P calculates the standard deviation of a population; STDEV.S calculates
variance
d. There is no difference - Answer-a. STDEV.S calculates standard deviation of a
sample; STDEV.P calculates the standard deviation of a population.
What is the difference between a sample and a population?
a. A sample contains all data you want to evaluate, while a population contains a portion
of data available
b. A population contains all data you want to evaluate, while a sample contains a portion
of the data.
c. A sample contains all data from the population except statistical data
d. There is no difference - Answer-b. A population contains all data you want to
evaluate, while a sample contains a portion of the data.
What keystroke combination is required to calculate a Frequency data array?
QUESTIONS AND ANSWERS
You hypothesize that there is a relationship between lack of regular exercise and
illness. To research this theory, you have compiled a sample set of data that contains
numbers of days in which an hour or more of exercise is completed as well as numbers
of days sick within a calendar year. What tools in Excel could you use to investigate the
relationships between the data?
a. CORREL
b. PERLENTRANK.INC
c. VAR.S
d. SUMIFS - Answer-a. CORREL
Which of the following functions has the ability to calculate the μ (MU) of a dataset
based on a user defined set of criteria?
a. AVERAGE
b. SUMIFS
c. COUNTIFS
d. AVERAGEIFS - Answer-d. AVERAGEIFS
What is the difference between STDEV.S and STDEV.P?
a. STDEV.S calculates standard deviation of a sample; STDEV.P calculates the
standard deviation of a population.
b. STDEV.P calculates the standard deviation of a population; STDEV.S calculates
average variation
c. STDEV.P calculates the standard deviation of a population; STDEV.S calculates
variance
d. There is no difference - Answer-a. STDEV.S calculates standard deviation of a
sample; STDEV.P calculates the standard deviation of a population.
What is the difference between a sample and a population?
a. A sample contains all data you want to evaluate, while a population contains a portion
of data available
b. A population contains all data you want to evaluate, while a sample contains a portion
of the data.
c. A sample contains all data from the population except statistical data
d. There is no difference - Answer-b. A population contains all data you want to
evaluate, while a sample contains a portion of the data.
What keystroke combination is required to calculate a Frequency data array?
