MODERN BUSINESS STATISTICS WITH
MICROSOFT EXCEL ACTUAL TEST
QUESTIONS AND SOLUTIONS
COMPREHENSIVE REVIEW PACKAGE
●● In a questionnaire, respondents are asked to record their age in years.
Age is an example of a _____.
Answer: quantitative variable
●● Statistical inference _____.
Answer: is the process of drawing inferences about the population based
on the information taken from the sample
●● The most common type of observational study is a(n) _____.
Answer: survey
●● The term data warehousing is used to refer to the process of doing all
of the following, except _____ the data.
Answer: mining
●● The collection of all elements of interest in a study is _____.
Answer: the population
, ●● _____ analytics encompasses the set of analytical techniques that
describe what has happened in the past.
Answer: Descriptive
●● _____ analytics is the set of analytical techniques that yield a course
of action.
Answer: Prescriptive
●● Which of the following is an example of categorical data?
Answer: social security number
●● A characteristic of interest for the elements is called a(n) _____.
Answer: variable
●● A frequency distribution is a _____.
Answer: tabular summary of a set of data showing the number of items
in each of several nonoverlapping classes
●● tabular summary of a set of data showing the number of items in
each of several nonoverlapping classes
Answer: bar graph
MICROSOFT EXCEL ACTUAL TEST
QUESTIONS AND SOLUTIONS
COMPREHENSIVE REVIEW PACKAGE
●● In a questionnaire, respondents are asked to record their age in years.
Age is an example of a _____.
Answer: quantitative variable
●● Statistical inference _____.
Answer: is the process of drawing inferences about the population based
on the information taken from the sample
●● The most common type of observational study is a(n) _____.
Answer: survey
●● The term data warehousing is used to refer to the process of doing all
of the following, except _____ the data.
Answer: mining
●● The collection of all elements of interest in a study is _____.
Answer: the population
, ●● _____ analytics encompasses the set of analytical techniques that
describe what has happened in the past.
Answer: Descriptive
●● _____ analytics is the set of analytical techniques that yield a course
of action.
Answer: Prescriptive
●● Which of the following is an example of categorical data?
Answer: social security number
●● A characteristic of interest for the elements is called a(n) _____.
Answer: variable
●● A frequency distribution is a _____.
Answer: tabular summary of a set of data showing the number of items
in each of several nonoverlapping classes
●● tabular summary of a set of data showing the number of items in
each of several nonoverlapping classes
Answer: bar graph