,TESTBANK FOR Modern Business Statistics with
Microsoft® Excel® 8th Edition by Jeffrey D. Camm
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,Name: Class: Date:
Chapter_01_Data_and_Statistics
Multiple Choice
1. Which of the following is an example of quantitative data?
a. The player’s number on a baseball uniform
b. The serial number on a one-dollar bill
c. The part number of an inventory item
d. The number of people in a waiting line
ANSWER: d
2. Which of the following is NOT an example of descriptive statistics?
a. A histogram depicting the age distribution for 30 randomly selected students
b. An estimate of the number of Alaska residents who have visited Canada
c. A table summarizing the data collected in a sample of new-car buyers
d. The proportion of mailed-out questionnaires that were returned
ANSWER: b
3. Which of the following is an example of categorical data?
a. Social security number
b. Score on a multiple-choice exam
c. Height, in meters, of a diving board
d. Number of square feet of carpet
ANSWER: a
4. The number of observations in a complete data set having 10 elements and 5 variables is _____.
a. 5
b. 10
c. 25
d. 50
ANSWER: b
5. Facts and figures collected, analyzed, and summarized for presentation and interpretation are called
_____.
a. data
b. variables
c. elements
d. variables and elements
ANSWER: a
6. The entities on which data are collected are _____.
a. elements
b. populations
c. sets
d. samples
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name: Class: Date:
Chapter_01_Data_and_Statistics
ANSWER: a
7. The set of measurements collected for an element is called a(n) _____.
a. census
b. variable
c. observation
d. sample
ANSWER: c
8. A characteristic of interest for the elements is called a(n) _____.
a. sample
b. data set
c. variable
d. observation
ANSWER: c
9. All data collected in a study are referred to as the _____.
a. census
b. inference
c. variable
d. data set
ANSWER: d
10. In a data set, the number of observations will always be the same as the number of _____.
a. variables
b. elements
c. data sets
d. data
ANSWER: b
11. Which of the following is NOT a scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Categorical
ANSWER: d
12. When the data are labels or names used to identify an attribute of the elements, the variable has which
scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
Copyright Cengage Learning. Powered by Cognero. Page 2
,Name: Class: Date:
Chapter_01_Data_and_Statistics
ANSWER: a
13. When the data are labels or names used to identify an attribute of the elements and the rank of the data
is meaningful, the variable has which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: b
14. When the data have the properties of ordinal data and the interval between observations is expressed
in terms of a fixed unit of measure, the variable has which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: c
15. When the data have the properties of interval data and the multiplication or division of two values is
meaningful, the variable has which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: d
16. Which two scales of measurement can be either numeric or nonnumeric?
a. Nominal and ratio
b. Ordinal and interval
c. Interval and ordinal
d. Nominal and ordinal
ANSWER: d
17. Which of the following variables uses the interval scale of measurement?
a. Name of stock exchange
b. Time
c. SAT scores
d. Social security number
ANSWER: c
18. Which of the following variables uses the ratio scale of measurement?
a. Name of stock exchange
b. Time
c. SAT scores
Copyright Cengage Learning. Powered by Cognero. Page 3
,Name: Class: Date:
Chapter_01_Data_and_Statistics
d. Social security number
ANSWER: b
19. Quantitative data _____.
a. are always nonnumeric
b. may be either numeric or nonnumeric
c. are always numeric
d. are always labels
ANSWER: c
20. Categorical data _____.
a. are always nonnumeric
b. may be either numeric or nonnumeric
c. are always numeric
d. indicate either how much or how many
ANSWER: b
21. Which type of analytics is the set of analytical techniques that yield a course of action?
a. Descriptive
b. Predictive
c. Prescriptive
d. Data
ANSWER: c
22. What organization developed the report, “Ethical Guidelines for Statistical Practice”?
a. Ethics Committee for Statistical Practices
b. American Statistical Association
c. International Statistical Organization
d. Federal Bureau for Ethical Practices in Statistics
ANSWER: b
23. Arithmetic operations are inappropriate for _____.
a. categorical data
b. quantitative data
c. both categorical and quantitative data
d. large data sets
ANSWER: a
24. In a questionnaire, respondents are asked to mark their gender as Male, Female, Transgender MtoF,
Transgender FtoM, Non-binary, or Intersex. Gender is an example of which type of variable?
a. Categorical
b. Quantitative
c. Interval
Copyright Cengage Learning. Powered by Cognero. Page 4
,Name: Class: Date:
Chapter_01_Data_and_Statistics
d. Ratio
ANSWER: a
25. In a questionnaire, respondents are asked to record their age in years. Age is an example of a _____.
a. categorical variable
b. quantitative variable
c. categorical or quantitative variable, depending on how the respondents answered the question
d. ordinal variable
ANSWER: b
26. In an application for a credit card, potential customers are asked for their social security numbers. A
social security number is an example of a _____.
a. categorical variable
b. quantitative variable
c. categorical or quantitative variable, depending on how the respondents answered the question
d. ratio variable
ANSWER: a
27. Temperature is an example of which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: c
28. For ease of data entry into a university database, 1 denotes the student is enrolled in an undergraduate
degree program, 2 indicates the student is enrolled in a master’s degree program, and 3 indicates the
student is enrolled in a doctoral degree program. In this case, the data are which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: b
29. Income is an example of _____.
a. categorical data
b. either categorical or quantitative data
c. currency data
d. quantitative data
ANSWER: d
30. The birth weight of newborns, measured in grams, is an example of _____.
a. categorical data
b. either categorical or quantitative data
Copyright Cengage Learning. Powered by Cognero. Page 5
,Name: Class: Date:
Chapter_01_Data_and_Statistics
c. neither categorical nor quantitative data
d. quantitative data
ANSWER: d
31. The graph below best exemplifies a _____.
(Graph courtesy of Robert Allison.)
a. bar graph
b. time series graph
c. cross-sectional graph
d. line graph
ANSWER: b
32. The graph below best exemplifies a _____.
a. bar graph
b. time series graph
c. cross-sectional graph
d. line graph
ANSWER: b
33. Data collected at the same, or approximately the same, point in time are considered which one of the
following types of data?
a. Time series
b. Static
Copyright Cengage Learning. Powered by Cognero. Page 6
,Name: Class: Date:
Chapter_01_Data_and_Statistics
c. Cross-sectional
d. One-dimensional
ANSWER: c
34. Data collected over several time periods are considered which one of the following types of data?
a. Time series
b. Time-controlled
c. Cross-sectional
d. Time dependent
ANSWER: a
35. Statistical studies in which researchers do not control variables of interest are _____.
a. experimental studies
b. uncontrolled experimental studies
c. not of any value
d. observational studies
ANSWER: d
36. Statistical studies in which researchers control variables of interest are referred to as which type of
study?
a. Experimental
b. Control observational
c. Non-experimental
d. Observational
ANSWER: a
37. Which type of analytics encompasses the set of analytical techniques that describe what has happened
in the past?
a. Descriptive
b. Predictive
c. Prescriptive
d. Data
ANSWER: a
38. Which of the following is NOT an example of an existing source of data?
a. The Internet
b. Internal company records
c. U.S. Census Bureau
d. Data from an experiment
ANSWER: d
39. Which of the following is NOT an example of a firm that sells or leases business database services to
clients?
a. Dun & Bradstreet
Copyright Cengage Learning. Powered by Cognero. Page 7
, Name: Class: Date:
Chapter_01_Data_and_Statistics
b. Bloomberg
c. U.S. Census Bureau
d. Dow Jones and Company
ANSWER: c
40. The most common type of observational study is a(n) _____.
a. experiment
b. survey
c. debate
d. statistical inference
ANSWER: b
41. The summaries of data, which may be tabular, graphical, or numerical, are referred to as _____.
a. inferential statistics
b. descriptive statistics
c. statistical inference
d. report generation
ANSWER: b
42. A Scanner Data User Survey of 50 companies found that the average amount spent on scanner data
per category of consumer goods was $387,325 (Mercer Management Consulting, Inc., April 24, 1997).
The $387,325 is an example of _____.
a. categorical data
b. a categorical variable
c. a descriptive statistic
d. time series data
ANSWER: c
43. Statistical inference _____.
a. refers to the process of drawing inferences about the sample based on the characteristics of the
population
b. is the same as descriptive statistics
c. is the process of drawing inferences about the population based on the information taken from
the sample
d. is the same as a census
ANSWER: c
44. The collection of all elements of interest in a study is _____.
a. the population
b. the sampling
c. statistical inference
d. descriptive statistics
ANSWER: a
Copyright Cengage Learning. Powered by Cognero. Page 8
Microsoft® Excel® 8th Edition by Jeffrey D. Camm
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,Name: Class: Date:
Chapter_01_Data_and_Statistics
Multiple Choice
1. Which of the following is an example of quantitative data?
a. The player’s number on a baseball uniform
b. The serial number on a one-dollar bill
c. The part number of an inventory item
d. The number of people in a waiting line
ANSWER: d
2. Which of the following is NOT an example of descriptive statistics?
a. A histogram depicting the age distribution for 30 randomly selected students
b. An estimate of the number of Alaska residents who have visited Canada
c. A table summarizing the data collected in a sample of new-car buyers
d. The proportion of mailed-out questionnaires that were returned
ANSWER: b
3. Which of the following is an example of categorical data?
a. Social security number
b. Score on a multiple-choice exam
c. Height, in meters, of a diving board
d. Number of square feet of carpet
ANSWER: a
4. The number of observations in a complete data set having 10 elements and 5 variables is _____.
a. 5
b. 10
c. 25
d. 50
ANSWER: b
5. Facts and figures collected, analyzed, and summarized for presentation and interpretation are called
_____.
a. data
b. variables
c. elements
d. variables and elements
ANSWER: a
6. The entities on which data are collected are _____.
a. elements
b. populations
c. sets
d. samples
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name: Class: Date:
Chapter_01_Data_and_Statistics
ANSWER: a
7. The set of measurements collected for an element is called a(n) _____.
a. census
b. variable
c. observation
d. sample
ANSWER: c
8. A characteristic of interest for the elements is called a(n) _____.
a. sample
b. data set
c. variable
d. observation
ANSWER: c
9. All data collected in a study are referred to as the _____.
a. census
b. inference
c. variable
d. data set
ANSWER: d
10. In a data set, the number of observations will always be the same as the number of _____.
a. variables
b. elements
c. data sets
d. data
ANSWER: b
11. Which of the following is NOT a scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Categorical
ANSWER: d
12. When the data are labels or names used to identify an attribute of the elements, the variable has which
scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
Copyright Cengage Learning. Powered by Cognero. Page 2
,Name: Class: Date:
Chapter_01_Data_and_Statistics
ANSWER: a
13. When the data are labels or names used to identify an attribute of the elements and the rank of the data
is meaningful, the variable has which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: b
14. When the data have the properties of ordinal data and the interval between observations is expressed
in terms of a fixed unit of measure, the variable has which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: c
15. When the data have the properties of interval data and the multiplication or division of two values is
meaningful, the variable has which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: d
16. Which two scales of measurement can be either numeric or nonnumeric?
a. Nominal and ratio
b. Ordinal and interval
c. Interval and ordinal
d. Nominal and ordinal
ANSWER: d
17. Which of the following variables uses the interval scale of measurement?
a. Name of stock exchange
b. Time
c. SAT scores
d. Social security number
ANSWER: c
18. Which of the following variables uses the ratio scale of measurement?
a. Name of stock exchange
b. Time
c. SAT scores
Copyright Cengage Learning. Powered by Cognero. Page 3
,Name: Class: Date:
Chapter_01_Data_and_Statistics
d. Social security number
ANSWER: b
19. Quantitative data _____.
a. are always nonnumeric
b. may be either numeric or nonnumeric
c. are always numeric
d. are always labels
ANSWER: c
20. Categorical data _____.
a. are always nonnumeric
b. may be either numeric or nonnumeric
c. are always numeric
d. indicate either how much or how many
ANSWER: b
21. Which type of analytics is the set of analytical techniques that yield a course of action?
a. Descriptive
b. Predictive
c. Prescriptive
d. Data
ANSWER: c
22. What organization developed the report, “Ethical Guidelines for Statistical Practice”?
a. Ethics Committee for Statistical Practices
b. American Statistical Association
c. International Statistical Organization
d. Federal Bureau for Ethical Practices in Statistics
ANSWER: b
23. Arithmetic operations are inappropriate for _____.
a. categorical data
b. quantitative data
c. both categorical and quantitative data
d. large data sets
ANSWER: a
24. In a questionnaire, respondents are asked to mark their gender as Male, Female, Transgender MtoF,
Transgender FtoM, Non-binary, or Intersex. Gender is an example of which type of variable?
a. Categorical
b. Quantitative
c. Interval
Copyright Cengage Learning. Powered by Cognero. Page 4
,Name: Class: Date:
Chapter_01_Data_and_Statistics
d. Ratio
ANSWER: a
25. In a questionnaire, respondents are asked to record their age in years. Age is an example of a _____.
a. categorical variable
b. quantitative variable
c. categorical or quantitative variable, depending on how the respondents answered the question
d. ordinal variable
ANSWER: b
26. In an application for a credit card, potential customers are asked for their social security numbers. A
social security number is an example of a _____.
a. categorical variable
b. quantitative variable
c. categorical or quantitative variable, depending on how the respondents answered the question
d. ratio variable
ANSWER: a
27. Temperature is an example of which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: c
28. For ease of data entry into a university database, 1 denotes the student is enrolled in an undergraduate
degree program, 2 indicates the student is enrolled in a master’s degree program, and 3 indicates the
student is enrolled in a doctoral degree program. In this case, the data are which scale of measurement?
a. Nominal
b. Ordinal
c. Interval
d. Ratio
ANSWER: b
29. Income is an example of _____.
a. categorical data
b. either categorical or quantitative data
c. currency data
d. quantitative data
ANSWER: d
30. The birth weight of newborns, measured in grams, is an example of _____.
a. categorical data
b. either categorical or quantitative data
Copyright Cengage Learning. Powered by Cognero. Page 5
,Name: Class: Date:
Chapter_01_Data_and_Statistics
c. neither categorical nor quantitative data
d. quantitative data
ANSWER: d
31. The graph below best exemplifies a _____.
(Graph courtesy of Robert Allison.)
a. bar graph
b. time series graph
c. cross-sectional graph
d. line graph
ANSWER: b
32. The graph below best exemplifies a _____.
a. bar graph
b. time series graph
c. cross-sectional graph
d. line graph
ANSWER: b
33. Data collected at the same, or approximately the same, point in time are considered which one of the
following types of data?
a. Time series
b. Static
Copyright Cengage Learning. Powered by Cognero. Page 6
,Name: Class: Date:
Chapter_01_Data_and_Statistics
c. Cross-sectional
d. One-dimensional
ANSWER: c
34. Data collected over several time periods are considered which one of the following types of data?
a. Time series
b. Time-controlled
c. Cross-sectional
d. Time dependent
ANSWER: a
35. Statistical studies in which researchers do not control variables of interest are _____.
a. experimental studies
b. uncontrolled experimental studies
c. not of any value
d. observational studies
ANSWER: d
36. Statistical studies in which researchers control variables of interest are referred to as which type of
study?
a. Experimental
b. Control observational
c. Non-experimental
d. Observational
ANSWER: a
37. Which type of analytics encompasses the set of analytical techniques that describe what has happened
in the past?
a. Descriptive
b. Predictive
c. Prescriptive
d. Data
ANSWER: a
38. Which of the following is NOT an example of an existing source of data?
a. The Internet
b. Internal company records
c. U.S. Census Bureau
d. Data from an experiment
ANSWER: d
39. Which of the following is NOT an example of a firm that sells or leases business database services to
clients?
a. Dun & Bradstreet
Copyright Cengage Learning. Powered by Cognero. Page 7
, Name: Class: Date:
Chapter_01_Data_and_Statistics
b. Bloomberg
c. U.S. Census Bureau
d. Dow Jones and Company
ANSWER: c
40. The most common type of observational study is a(n) _____.
a. experiment
b. survey
c. debate
d. statistical inference
ANSWER: b
41. The summaries of data, which may be tabular, graphical, or numerical, are referred to as _____.
a. inferential statistics
b. descriptive statistics
c. statistical inference
d. report generation
ANSWER: b
42. A Scanner Data User Survey of 50 companies found that the average amount spent on scanner data
per category of consumer goods was $387,325 (Mercer Management Consulting, Inc., April 24, 1997).
The $387,325 is an example of _____.
a. categorical data
b. a categorical variable
c. a descriptive statistic
d. time series data
ANSWER: c
43. Statistical inference _____.
a. refers to the process of drawing inferences about the sample based on the characteristics of the
population
b. is the same as descriptive statistics
c. is the process of drawing inferences about the population based on the information taken from
the sample
d. is the same as a census
ANSWER: c
44. The collection of all elements of interest in a study is _____.
a. the population
b. the sampling
c. statistical inference
d. descriptive statistics
ANSWER: a
Copyright Cengage Learning. Powered by Cognero. Page 8
