, SOLUTION MANUAL 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:
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Solution and Answer Guide
CAMM/COCHRAN/FRY/OHLMANN/ANDERSON/SWEENEY/WILLIAMS, MODERN BUSINESS STATISTICS
W/MS EXCEL 8TH EDITION, 9780357929964; CHAPTER 1: DATA AND STATISTICS
TABLE OF CONTENTS
Supplementary Exercises...........................................................................................................1
SUPPLEMENTARY EXERCISES
1. Wall Street Journal Subscriber Characteristics. A Wall Street Journal subscriber survey asked 46
questions about subscriber characteristics and interests. State whether each of the following
questions provides categorical or quantitative data. LO 2
a. What is your age?
b. Are you married?
c. When did you first start reading the WSJ? High school, college, early career, midcareer, late
career, or retirement?
d. How long have you been in your present job or position?
e. What type of vehicle are you considering for your next purchase? Nine response categories
include sedan, sports car, SUV, minivan, and so on.
Solutions:
a. Quantitative
b. Categorical
c. Categorical
d. Quantitative
e. Categorical
2. Comparing Tablet Computers. Tablet PC Comparison provides a wide variety of information about
tablet computers. Their website enables consumers to easily compare different tablets using factors
such as cost, type of operating system, display size, battery life, and CPU manufacturer. A sample of
10 tablet computers is shown in Table 1.6 (Tablet PC Comparison website). LO 1, 2
Table 1.6 Product Information for 10 Tablet Computers
Operating Display Size Battery Life CPU
Tablet Cost ($) System (inches) (hours) Manufacturer
Acer Iconia W510 599 Windows 10.1 8.5 Intel
Amazon Kindle Fire HD 299 Android 8.9 9.0 TI OMAP
Apple iPad 4 499 iOS 9.7 11.0 Apple
HP Envy X2 860 Windows 11.6 8.0 Intel
Lenovo ThinkPad Tablet 668 Windows 10.1 10.5 Intel
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 1
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Microsoft Surface Pro 899 Windows 10.6 4.0 Intel
Motorola Droid XYboard 530 Android 10.1 9.0 TI OMAP
Samsung Ativ Smart PC 590 Windows 11.6 7.0 Intel
Samsung Galaxy Tab 525 Android 10.1 10.0 Nvidia
Sony Tablet S 360 Android 9.4 8.0 Nvidia
a. How many elements are in this data set?
b. How many variables are in this data set?
c. Which variables are categorical and which variables are quantitative?
d. What type of measurement scale is used for each of the variables?
Solutions:
a. The 10 elements are the 10 tablet computers.
b. Five variables: Cost ($), Operating System, Display Size (inches), Battery Life (hours), CPU
Manufacturer
c. Categorical variables: Operating System and CPU Manufacturer
Quantitative variables: Cost ($), Display Size (inches), and Battery Life (hours)
d.
Variable Measurement Scale
Cost ($) Ratio
Operating System Nominal
Display Size (inches) Ratio
Battery Life (hours) Ratio
CPU Manufacturer Nominal
3. Tablet PCs: Cost, CPU, and Operating System. Refer to Table 1.6. LO 3
a. What is the average cost for the tablets?
b. Compare the average cost of tablets with a Windows operating system to the average cost of
tablets with an Android operating system.
c. What percentage of tablets use a CPU manufactured by TI OMAP?
d. What percentage of tablets use an Android operating system?
Solutions:
a. Average cost = 5,829/10 = $582.90
b. Average cost with a Windows operating system = 3,616/5 = $723.20
Average cost with an Android operating system = 1,714/4 = $428.5
The average cost with a Windows operating system is much higher.
c. 2 of 10 or 20% use a CPU manufactured by TI OMAP.
d. 4 of 10 or 40% use an Android operating system.
4. Comparing Phones. Table 1.7 shows data for eight phones (Consumer Reports). The Overall Score,
a measure of the overall quality for the phone, ranges from 0 to 100. Voice Quality has possible
ratings of poor, fair, good, very good, and excellent. Talk Time is the manufacturer’s claim of how
long the phone can be used when it is fully charged. LO 1, 2
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 2
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Table 1.7 Data for Eight Phones
Brand Model Price ($) Overall Score Voice Quality Talk Time (hours)
AT&T CL84100 60 73 Excellent 7
AT&T TL92271 80 70 Very Good 7
Panasonic 4773B 100 78 Very Good 13
Panasonic 6592T 70 72 Very Good 13
Uniden D2997 45 70 Very Good 10
Uniden D1788 80 73 Very Good 7
Vtech DS6521 60 72 Excellent 7
Vtech CS6649 50 72 Very Good 7
a. How many elements are in this data set?
b. For the variables Price, Overall Score, Voice Quality, and Talk Time, which variables are
categorical and which variables are quantitative?
c. What scale of measurement is used for each variable?
Solutions:
a. There are eight elements in this data set; each element corresponds to one of the eight models of
cordless telephones.
b. Categorical variables: Voice Quality and Handset on Base
Quantitative variables: Price, Overall Score, and Talk Time
c. Price – ratio measurement
Overall Score – interval measurement
Voice Quality – ordinal measurement
Handset on Base – nominal measurement
Talk Time – ratio measurement
5. Summarizing Phone Data. Refer to the data set in Table 1.7. LO 3
a. What is the average price for the phones?
b. What is the average talk time for the phones?
c. What percentage of the phones have a voice quality of excellent?
Solutions:
a. Average Price = 545/8 = $68.13
b. Average Talk Time = 71/8 = 8.875 hours
c. Percentage rated Excellent: 2 of 8 2/8 = 0.25, or 25%
6. New Automobile Owners Survey. J.D. Power and Associates surveys new automobile owners to
learn about the quality of recently purchased vehicles. The following questions were asked in the J.D.
Power Initial Quality Survey. Comment on whether each of the following questions provides
categorical or quantitative data. LO 2
a. Did you purchase or lease the vehicle?
b. What price did you pay?
c. What is the overall attractiveness of your vehicle’s exterior? (Unacceptable, Average,
Outstanding, or Truly Exceptional)
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 3
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
d. What is your average number of miles per gallon?
e. What is your overall rating of your new vehicle? (l- to 10-point scale with
1 Unacceptable and 10 Truly Exceptional)
Solutions:
a. Categorical
b. Quantitative
c. Categorical
d. Quantitative
e. Quantitative
7. Airline Customer Satisfaction. Many service companies collect data via a follow-up survey of their
customers. For example, to ascertain customer sentiment, Delta Air Lines sends an e-mail to
customers immediately following a flight. Among other questions, Delta asks:
How likely are you to recommend Delta Air Lines to others?
The possible responses are:
Definitely Probably May or May Probably Will Definitely Will
Will Will Not Not Not
❍ ❍ ❍ ❍ ❍
Use this information to answer the following questions. LO 2, 4
a. Are the data collected by Delta in this example quantitative or categorical?
b. What measurement scale is used?
Solutions:
a. Since there are five choices, the response is a categorical response.
b. The five responses are the labels for the customer responses. A nominal scale is being used.
8. Readership Poll. The Tennessean, an online newspaper located in Nashville, Tennessee, conducts
a daily poll to obtain reader opinions on a variety of current issues. In a recent poll, 762 readers
responded to the following question: “If a constitutional amendment to ban a state income tax is
placed on the ballot in Tennessee, would you want it to pass?” Possible responses were Yes, No, or
Not Sure (The Tennessean website). LO 1, 2, 3
a. What was the sample size for this poll?
b. Are the data categorical or quantitative?
c. Would it make more sense to use averages or percentages as a summary of the data for this
question?
d. Of the respondents, 67% said Yes, they would want it to pass. How many individuals provided
this response?
Solutions:
a. 762
b. Categorical
c. Percentages
d. 0.67(762) = 510.54
510 or 511 respondents said they want the amendment to pass.
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 4
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
9. College-Educated Workers. Based on data from the U.S. Census Bureau, a Pew Research study showed
that the percentage of employed individuals ages 25–29 who are college educated is at an all-time high. The
study showed that the percentage of employed individuals aged 25–29 with at least a bachelor’s degree in
2016 was 40%. In the year 2000, this percentage was 32%, in 1985 it was 25%, and in 1964 it was only 16%
(Pew Research website). LO 4
a. What is the population being studied in each of the four years in which Pew has data?
b. What question was posed to each respondent?
c. Do responses to the question provide categorical or quantitative data?
Solutions:
a. The population is employed individuals in the United States aged 25–29.
b. Have you earned a bachelor’s degree (or higher)?
c. Since the response is yes or no, the response is categorical.
10. Driving with Cell Phones. The Bureau of Transportation Statistics Omnibus Household Survey is
conducted annually and serves as an information source for the U.S. Department of Transportation.
In one part of the survey the person being interviewed was asked to respond to the following
statement: “Drivers of motor vehicles should be allowed to talk on a handheld cell phone while
driving.” Possible responses were strongly agree, somewhat agree, somewhat disagree, and strongly
disagree. Forty-four respondents said that they strongly agree with this statement, 130 said that they
somewhat agree, 165 said they somewhat disagree, and 741 said they strongly disagree with this
statement (Bureau of Transportation website). LO 2, 3
a. Do the responses for this statement provide categorical or quantitative data?
b. Would it make more sense to use averages or percentages as a summary of the responses for
this statement?
c. What percentage of respondents strongly agree with allowing drivers of motor vehicles to talk on
a handheld cell phone while driving?
d. Do the results indicate general support for or against allowing drivers of motor vehicles to talk on
a handheld cell phone while driving?
Solutions:
a. Categorical
b. Percentages
c. 44 of 1,080 respondents or approximately 4% strongly agree with allowing drivers of motor
vehicles to talk on a handheld cell phone while driving.
d. 165 of the 1,080 respondents or 15% of said they somewhat disagree and 741 or 69% said they
strongly disagree. Thus, there does not appear to be general support for allowing drivers of motor
vehicles to talk on a handheld cell phone while driving.
11. Driverless Cars Expected Soon. A Gallup Poll utilizing a random sample of 1,503 adults ages 18 or
older was conducted in April 2018. The survey indicated a majority of Americans (53%) say driverless cars
will be common in the next 10 years (Gallup, The question asked was:
Thinking about fully automated, “driverless cars,” cars that use technology to drive and do not need a
human driver, based on what you have heard or read, how soon do you think driverless cars will be
commonly used in the [United States]?
Figure 1.10 shows a summary of results of the survey in a histogram indicating the percentage of the
total responses in different time intervals. LO 2, 3
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 5
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
FIGURE 1.10 Histogram of Survey Results on Driverless Cars
a. Are the responses to the survey question quantitative or categorical?
b. How many of the respondents said that they expect driverless cars to be common in the next 10
years?
c. How many respondents answered in the range 16–20 years?
Solutions:
a. Since the respondents answer with some time interval, the response is categorical.
b. 0.53(1,503) = 796.59 or approximately 797
c. 0.10(1,503) = 150.3 or approximately 150
12. Hawaii Visitors Poll. The Hawaii Visitors Bureau collects data on visitors to Hawaii. The following
questions were among 16 asked in a questionnaire handed out to passengers during incoming airline
flights.
This trip to Hawaii is my: 1st, 2nd, 3rd, 4th, etc.
The primary reason for this trip is: (10 categories, including vacation, convention, honeymoon)
Where I plan to stay: (11 categories, including hotel, apartment, relatives, camping)
Total days in Hawaii
Use this information to answer the following questions. LO 2, 4
a. What is the population being studied?
b. Is the use of a questionnaire a good way to reach the population of passengers on incoming
airline flights?
c. Comment on each of the four questions in terms of whether it will provide categorical or
quantitative data.
Solutions:
a. The population is all visitors coming to the state of Hawaii.
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 6
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
b. Since airline flights carry the vast majority of visitors to the state, the use of questionnaires for
passengers during incoming flights is a good way to reach this population. The questionnaire
actually appears on the back of a mandatory plants and animals declaration form that passengers
must complete during the incoming flight. A large percentage of passengers complete the visitor
information questionnaire.
c. Questions one and four provide quantitative data indicating the number of visits and the number
of days in Hawaii. Questions two and three provide categorical data indicating the categories of
reason for the trip and where the visitor plans to stay.
13. Netflix Subscribers. Figure 1.11 provides a bar chart showing the number of Netflix subscribers from
2011 to 2020 (nscreenmedia.com). LO 1, 2
a. What is the variable of interest?
b. Are the data categorical or quantitative?
c. Are the data time series or cross-sectional?
d. Comment on the trend in Facebook’s annual advertising revenue over time.
FIGURE 1.11 Netflix Subscribers (millions)
Solutions:
a. Number of Netflix subscribers
b. Quantitative
c. Time series
d. The number of Netflix subscribers is increasing at an increasing rate over time.
14. Rental Car Fleet Size. The following data show the number of rental cars in service for three rental
car companies: Hertz, Avis, and Dollar, over a four-year period. LO 2
Cars in Service (1,000s)
Company Year 1 Year 2 Year 3 Year 4
Hertz 327 311 286 290
Dollar 167 140 106 108
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 7
accessible website, in whole or in part.
, Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Avis 204 220 300 270
a. Construct a time series graph for the years 1 to 4 showing the number of rental cars in service for
each company. Show the time series for all three companies on the same graph.
b. Comment on who appears to be the market share leader and how the market shares are
changing over time.
c. Construct a bar chart showing rental cars in service for year 4. Is this chart based on cross-
sectional or time series data?
Solutions:
a. The graph of the time series follows:
Hertz Dollar Avis
350
300
250
Cars in Service (1,000s)
200
150
100
50
0
Year 1 Year 2 Year 3 Year 4
b. In year 1 and year 2 Hertz was the clear market share leader. In year 3 and year 4 Hertz and Avis
have approximately the same market share. The market share for Dollar appears to be declining.
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 8
accessible website, in whole or in part.
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:
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Solution and Answer Guide
CAMM/COCHRAN/FRY/OHLMANN/ANDERSON/SWEENEY/WILLIAMS, MODERN BUSINESS STATISTICS
W/MS EXCEL 8TH EDITION, 9780357929964; CHAPTER 1: DATA AND STATISTICS
TABLE OF CONTENTS
Supplementary Exercises...........................................................................................................1
SUPPLEMENTARY EXERCISES
1. Wall Street Journal Subscriber Characteristics. A Wall Street Journal subscriber survey asked 46
questions about subscriber characteristics and interests. State whether each of the following
questions provides categorical or quantitative data. LO 2
a. What is your age?
b. Are you married?
c. When did you first start reading the WSJ? High school, college, early career, midcareer, late
career, or retirement?
d. How long have you been in your present job or position?
e. What type of vehicle are you considering for your next purchase? Nine response categories
include sedan, sports car, SUV, minivan, and so on.
Solutions:
a. Quantitative
b. Categorical
c. Categorical
d. Quantitative
e. Categorical
2. Comparing Tablet Computers. Tablet PC Comparison provides a wide variety of information about
tablet computers. Their website enables consumers to easily compare different tablets using factors
such as cost, type of operating system, display size, battery life, and CPU manufacturer. A sample of
10 tablet computers is shown in Table 1.6 (Tablet PC Comparison website). LO 1, 2
Table 1.6 Product Information for 10 Tablet Computers
Operating Display Size Battery Life CPU
Tablet Cost ($) System (inches) (hours) Manufacturer
Acer Iconia W510 599 Windows 10.1 8.5 Intel
Amazon Kindle Fire HD 299 Android 8.9 9.0 TI OMAP
Apple iPad 4 499 iOS 9.7 11.0 Apple
HP Envy X2 860 Windows 11.6 8.0 Intel
Lenovo ThinkPad Tablet 668 Windows 10.1 10.5 Intel
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 1
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Microsoft Surface Pro 899 Windows 10.6 4.0 Intel
Motorola Droid XYboard 530 Android 10.1 9.0 TI OMAP
Samsung Ativ Smart PC 590 Windows 11.6 7.0 Intel
Samsung Galaxy Tab 525 Android 10.1 10.0 Nvidia
Sony Tablet S 360 Android 9.4 8.0 Nvidia
a. How many elements are in this data set?
b. How many variables are in this data set?
c. Which variables are categorical and which variables are quantitative?
d. What type of measurement scale is used for each of the variables?
Solutions:
a. The 10 elements are the 10 tablet computers.
b. Five variables: Cost ($), Operating System, Display Size (inches), Battery Life (hours), CPU
Manufacturer
c. Categorical variables: Operating System and CPU Manufacturer
Quantitative variables: Cost ($), Display Size (inches), and Battery Life (hours)
d.
Variable Measurement Scale
Cost ($) Ratio
Operating System Nominal
Display Size (inches) Ratio
Battery Life (hours) Ratio
CPU Manufacturer Nominal
3. Tablet PCs: Cost, CPU, and Operating System. Refer to Table 1.6. LO 3
a. What is the average cost for the tablets?
b. Compare the average cost of tablets with a Windows operating system to the average cost of
tablets with an Android operating system.
c. What percentage of tablets use a CPU manufactured by TI OMAP?
d. What percentage of tablets use an Android operating system?
Solutions:
a. Average cost = 5,829/10 = $582.90
b. Average cost with a Windows operating system = 3,616/5 = $723.20
Average cost with an Android operating system = 1,714/4 = $428.5
The average cost with a Windows operating system is much higher.
c. 2 of 10 or 20% use a CPU manufactured by TI OMAP.
d. 4 of 10 or 40% use an Android operating system.
4. Comparing Phones. Table 1.7 shows data for eight phones (Consumer Reports). The Overall Score,
a measure of the overall quality for the phone, ranges from 0 to 100. Voice Quality has possible
ratings of poor, fair, good, very good, and excellent. Talk Time is the manufacturer’s claim of how
long the phone can be used when it is fully charged. LO 1, 2
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 2
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Table 1.7 Data for Eight Phones
Brand Model Price ($) Overall Score Voice Quality Talk Time (hours)
AT&T CL84100 60 73 Excellent 7
AT&T TL92271 80 70 Very Good 7
Panasonic 4773B 100 78 Very Good 13
Panasonic 6592T 70 72 Very Good 13
Uniden D2997 45 70 Very Good 10
Uniden D1788 80 73 Very Good 7
Vtech DS6521 60 72 Excellent 7
Vtech CS6649 50 72 Very Good 7
a. How many elements are in this data set?
b. For the variables Price, Overall Score, Voice Quality, and Talk Time, which variables are
categorical and which variables are quantitative?
c. What scale of measurement is used for each variable?
Solutions:
a. There are eight elements in this data set; each element corresponds to one of the eight models of
cordless telephones.
b. Categorical variables: Voice Quality and Handset on Base
Quantitative variables: Price, Overall Score, and Talk Time
c. Price – ratio measurement
Overall Score – interval measurement
Voice Quality – ordinal measurement
Handset on Base – nominal measurement
Talk Time – ratio measurement
5. Summarizing Phone Data. Refer to the data set in Table 1.7. LO 3
a. What is the average price for the phones?
b. What is the average talk time for the phones?
c. What percentage of the phones have a voice quality of excellent?
Solutions:
a. Average Price = 545/8 = $68.13
b. Average Talk Time = 71/8 = 8.875 hours
c. Percentage rated Excellent: 2 of 8 2/8 = 0.25, or 25%
6. New Automobile Owners Survey. J.D. Power and Associates surveys new automobile owners to
learn about the quality of recently purchased vehicles. The following questions were asked in the J.D.
Power Initial Quality Survey. Comment on whether each of the following questions provides
categorical or quantitative data. LO 2
a. Did you purchase or lease the vehicle?
b. What price did you pay?
c. What is the overall attractiveness of your vehicle’s exterior? (Unacceptable, Average,
Outstanding, or Truly Exceptional)
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 3
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
d. What is your average number of miles per gallon?
e. What is your overall rating of your new vehicle? (l- to 10-point scale with
1 Unacceptable and 10 Truly Exceptional)
Solutions:
a. Categorical
b. Quantitative
c. Categorical
d. Quantitative
e. Quantitative
7. Airline Customer Satisfaction. Many service companies collect data via a follow-up survey of their
customers. For example, to ascertain customer sentiment, Delta Air Lines sends an e-mail to
customers immediately following a flight. Among other questions, Delta asks:
How likely are you to recommend Delta Air Lines to others?
The possible responses are:
Definitely Probably May or May Probably Will Definitely Will
Will Will Not Not Not
❍ ❍ ❍ ❍ ❍
Use this information to answer the following questions. LO 2, 4
a. Are the data collected by Delta in this example quantitative or categorical?
b. What measurement scale is used?
Solutions:
a. Since there are five choices, the response is a categorical response.
b. The five responses are the labels for the customer responses. A nominal scale is being used.
8. Readership Poll. The Tennessean, an online newspaper located in Nashville, Tennessee, conducts
a daily poll to obtain reader opinions on a variety of current issues. In a recent poll, 762 readers
responded to the following question: “If a constitutional amendment to ban a state income tax is
placed on the ballot in Tennessee, would you want it to pass?” Possible responses were Yes, No, or
Not Sure (The Tennessean website). LO 1, 2, 3
a. What was the sample size for this poll?
b. Are the data categorical or quantitative?
c. Would it make more sense to use averages or percentages as a summary of the data for this
question?
d. Of the respondents, 67% said Yes, they would want it to pass. How many individuals provided
this response?
Solutions:
a. 762
b. Categorical
c. Percentages
d. 0.67(762) = 510.54
510 or 511 respondents said they want the amendment to pass.
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 4
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
9. College-Educated Workers. Based on data from the U.S. Census Bureau, a Pew Research study showed
that the percentage of employed individuals ages 25–29 who are college educated is at an all-time high. The
study showed that the percentage of employed individuals aged 25–29 with at least a bachelor’s degree in
2016 was 40%. In the year 2000, this percentage was 32%, in 1985 it was 25%, and in 1964 it was only 16%
(Pew Research website). LO 4
a. What is the population being studied in each of the four years in which Pew has data?
b. What question was posed to each respondent?
c. Do responses to the question provide categorical or quantitative data?
Solutions:
a. The population is employed individuals in the United States aged 25–29.
b. Have you earned a bachelor’s degree (or higher)?
c. Since the response is yes or no, the response is categorical.
10. Driving with Cell Phones. The Bureau of Transportation Statistics Omnibus Household Survey is
conducted annually and serves as an information source for the U.S. Department of Transportation.
In one part of the survey the person being interviewed was asked to respond to the following
statement: “Drivers of motor vehicles should be allowed to talk on a handheld cell phone while
driving.” Possible responses were strongly agree, somewhat agree, somewhat disagree, and strongly
disagree. Forty-four respondents said that they strongly agree with this statement, 130 said that they
somewhat agree, 165 said they somewhat disagree, and 741 said they strongly disagree with this
statement (Bureau of Transportation website). LO 2, 3
a. Do the responses for this statement provide categorical or quantitative data?
b. Would it make more sense to use averages or percentages as a summary of the responses for
this statement?
c. What percentage of respondents strongly agree with allowing drivers of motor vehicles to talk on
a handheld cell phone while driving?
d. Do the results indicate general support for or against allowing drivers of motor vehicles to talk on
a handheld cell phone while driving?
Solutions:
a. Categorical
b. Percentages
c. 44 of 1,080 respondents or approximately 4% strongly agree with allowing drivers of motor
vehicles to talk on a handheld cell phone while driving.
d. 165 of the 1,080 respondents or 15% of said they somewhat disagree and 741 or 69% said they
strongly disagree. Thus, there does not appear to be general support for allowing drivers of motor
vehicles to talk on a handheld cell phone while driving.
11. Driverless Cars Expected Soon. A Gallup Poll utilizing a random sample of 1,503 adults ages 18 or
older was conducted in April 2018. The survey indicated a majority of Americans (53%) say driverless cars
will be common in the next 10 years (Gallup, The question asked was:
Thinking about fully automated, “driverless cars,” cars that use technology to drive and do not need a
human driver, based on what you have heard or read, how soon do you think driverless cars will be
commonly used in the [United States]?
Figure 1.10 shows a summary of results of the survey in a histogram indicating the percentage of the
total responses in different time intervals. LO 2, 3
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 5
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
FIGURE 1.10 Histogram of Survey Results on Driverless Cars
a. Are the responses to the survey question quantitative or categorical?
b. How many of the respondents said that they expect driverless cars to be common in the next 10
years?
c. How many respondents answered in the range 16–20 years?
Solutions:
a. Since the respondents answer with some time interval, the response is categorical.
b. 0.53(1,503) = 796.59 or approximately 797
c. 0.10(1,503) = 150.3 or approximately 150
12. Hawaii Visitors Poll. The Hawaii Visitors Bureau collects data on visitors to Hawaii. The following
questions were among 16 asked in a questionnaire handed out to passengers during incoming airline
flights.
This trip to Hawaii is my: 1st, 2nd, 3rd, 4th, etc.
The primary reason for this trip is: (10 categories, including vacation, convention, honeymoon)
Where I plan to stay: (11 categories, including hotel, apartment, relatives, camping)
Total days in Hawaii
Use this information to answer the following questions. LO 2, 4
a. What is the population being studied?
b. Is the use of a questionnaire a good way to reach the population of passengers on incoming
airline flights?
c. Comment on each of the four questions in terms of whether it will provide categorical or
quantitative data.
Solutions:
a. The population is all visitors coming to the state of Hawaii.
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 6
accessible website, in whole or in part.
,Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
b. Since airline flights carry the vast majority of visitors to the state, the use of questionnaires for
passengers during incoming flights is a good way to reach this population. The questionnaire
actually appears on the back of a mandatory plants and animals declaration form that passengers
must complete during the incoming flight. A large percentage of passengers complete the visitor
information questionnaire.
c. Questions one and four provide quantitative data indicating the number of visits and the number
of days in Hawaii. Questions two and three provide categorical data indicating the categories of
reason for the trip and where the visitor plans to stay.
13. Netflix Subscribers. Figure 1.11 provides a bar chart showing the number of Netflix subscribers from
2011 to 2020 (nscreenmedia.com). LO 1, 2
a. What is the variable of interest?
b. Are the data categorical or quantitative?
c. Are the data time series or cross-sectional?
d. Comment on the trend in Facebook’s annual advertising revenue over time.
FIGURE 1.11 Netflix Subscribers (millions)
Solutions:
a. Number of Netflix subscribers
b. Quantitative
c. Time series
d. The number of Netflix subscribers is increasing at an increasing rate over time.
14. Rental Car Fleet Size. The following data show the number of rental cars in service for three rental
car companies: Hertz, Avis, and Dollar, over a four-year period. LO 2
Cars in Service (1,000s)
Company Year 1 Year 2 Year 3 Year 4
Hertz 327 311 286 290
Dollar 167 140 106 108
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 7
accessible website, in whole or in part.
, Solution and Answer Guide: Camm/Cochran/Fry/Ohlmann/Anderson/Sweeney/Williams, Modern Business Statistics w/MS Excel 8th
Edition, 9780357929964; Chapter 1: Data and Statistics
Avis 204 220 300 270
a. Construct a time series graph for the years 1 to 4 showing the number of rental cars in service for
each company. Show the time series for all three companies on the same graph.
b. Comment on who appears to be the market share leader and how the market shares are
changing over time.
c. Construct a bar chart showing rental cars in service for year 4. Is this chart based on cross-
sectional or time series data?
Solutions:
a. The graph of the time series follows:
Hertz Dollar Avis
350
300
250
Cars in Service (1,000s)
200
150
100
50
0
Year 1 Year 2 Year 3 Year 4
b. In year 1 and year 2 Hertz was the clear market share leader. In year 3 and year 4 Hertz and Avis
have approximately the same market share. The market share for Dollar appears to be declining.
© 2025 Cengage Learning, Inc. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly 8
accessible website, in whole or in part.
