SOLUTION MANUAL FOR ESSENTIALS OF
MODERN BUSINESS STATISTICS WITH
MICROSOFT EXCEL 15TH EDITION DAVID R.
ANDERSON ISBN-10; 0357715853 /ISBN-13;
978-0357715857
This is a comprehensive compilation of the questions, multiple-choice options (where applicable), and
correct answers with detailed rationales from the provided solution manual for "Essentials of Modern
Business Statistics with Microsoft Excel, 15th Edition" by David R. Anderson.
The content covers the following chapters:
- **Chapter 1:** Data and Statistics
- **Chapter 2:** Descriptive Statistics: Tabular and Graphical Presentations
- **Chapter 3:** Descriptive Statistics: Numerical Measures
- **Chapter 4:** Introduction to Probability
- **Chapter 5:** Discrete Probability Distributions
- **Chapter 6:** Continuous Probability Distributions
- **Chapter 7:** Sampling and Sampling Distributions
- **Chapter 8:** Interval Estimation
- **Chapter 9:** Hypothesis Tests
- **Chapter 10:** Inference About Means and Proportions with Two Populations
- **Chapter 11:** Inferences About Population Variances
- **Chapter 12:** Tests of Goodness of Fit, Independence, and Multiple Proportions
- **Chapter 13:** Experimental Design and Analysis of Variance
,- **Chapter 14:** Simple Linear Regression
- **Chapter 15:** Multiple Regression
---
### Chapter 1: Data and Statistics
**Question 1**
Statistics can be referred to as numerical facts. In a broader sense, statistics is the field of study dealing
with the collection, analysis, presentation, and interpretation of data.
**Correct Answer / Rationale:**
This is a definitional statement provided in the text, establishing the scope of statistics as a field of
study.
---
**Question 2**
A data set contains information on 10 tablet computers. The variables are: Cost ($), Operating System,
Display Size (inches), Battery Life (hours), and CPU Manufacturer.
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 are quantitative?
d. What is the measurement scale for each variable?
**Correct Answer / Rationale:**
a. The ten elements are the ten 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. Measurement Scales: Cost ($) - Ratio, Operating System - Nominal, Display Size (inches) - Ratio,
Battery Life (hours) - Ratio, CPU Manufacturer - Nominal.
*Rationale:* Elements are the entities on which data are collected. Variables are the characteristics of
interest. Categorical variables use labels or names, while quantitative variables use numerical values.
The measurement scale is nominal for categorical labels, ordinal for ranked data, interval for numerical
data with no true zero, and ratio for numerical data with a true zero.
---
**Question 3**
Refer to the tablet computer data set.
a. What is the average cost?
b. What is the average cost for tablets with a Windows operating system and for those with an Android
operating system? Compare.
c. What percentage of the tablets use a CPU manufactured by TI OMAP?
d. What percentage of the tablets use an Android operating system?
**Correct Answer / Rationale:**
a. Average cost = = 582.90
b. Average cost with a Windows OS = = 723.20. Average cost with an Android OS = =
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.
*Rationale:* These calculations demonstrate basic descriptive statistics, such as mean and percentage,
to summarize the data.
---
**Question 4**
, A data set contains information on eight cordless telephones. The variables are: Voice Quality, Handset
on Base, Price, Overall Score, and Talk Time.
a. How many elements are in this data set?
b. Which variables are categorical and which are quantitative?
c. What is the measurement scale for each variable?
**Correct Answer / Rationale:**
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.
*Rationale:* This reinforces the distinction between categorical and quantitative data and the different
measurement scales (nominal, ordinal, interval, ratio).
---
**Question 5**
Refer to the cordless telephone data set.
a. What is the average price?
b. What is the average talk time?
c. What percentage of the telephones are rated Excellent?
**Correct Answer / Rationale:**
a. Average Price = = 68.13
b. Average Talk Time = = 8.875 hours
c. Percentage rated Excellent: 2 of 8 = 25%.
*Rationale:* Calculating the mean and percentages are fundamental descriptive statistics.
MODERN BUSINESS STATISTICS WITH
MICROSOFT EXCEL 15TH EDITION DAVID R.
ANDERSON ISBN-10; 0357715853 /ISBN-13;
978-0357715857
This is a comprehensive compilation of the questions, multiple-choice options (where applicable), and
correct answers with detailed rationales from the provided solution manual for "Essentials of Modern
Business Statistics with Microsoft Excel, 15th Edition" by David R. Anderson.
The content covers the following chapters:
- **Chapter 1:** Data and Statistics
- **Chapter 2:** Descriptive Statistics: Tabular and Graphical Presentations
- **Chapter 3:** Descriptive Statistics: Numerical Measures
- **Chapter 4:** Introduction to Probability
- **Chapter 5:** Discrete Probability Distributions
- **Chapter 6:** Continuous Probability Distributions
- **Chapter 7:** Sampling and Sampling Distributions
- **Chapter 8:** Interval Estimation
- **Chapter 9:** Hypothesis Tests
- **Chapter 10:** Inference About Means and Proportions with Two Populations
- **Chapter 11:** Inferences About Population Variances
- **Chapter 12:** Tests of Goodness of Fit, Independence, and Multiple Proportions
- **Chapter 13:** Experimental Design and Analysis of Variance
,- **Chapter 14:** Simple Linear Regression
- **Chapter 15:** Multiple Regression
---
### Chapter 1: Data and Statistics
**Question 1**
Statistics can be referred to as numerical facts. In a broader sense, statistics is the field of study dealing
with the collection, analysis, presentation, and interpretation of data.
**Correct Answer / Rationale:**
This is a definitional statement provided in the text, establishing the scope of statistics as a field of
study.
---
**Question 2**
A data set contains information on 10 tablet computers. The variables are: Cost ($), Operating System,
Display Size (inches), Battery Life (hours), and CPU Manufacturer.
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 are quantitative?
d. What is the measurement scale for each variable?
**Correct Answer / Rationale:**
a. The ten elements are the ten 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. Measurement Scales: Cost ($) - Ratio, Operating System - Nominal, Display Size (inches) - Ratio,
Battery Life (hours) - Ratio, CPU Manufacturer - Nominal.
*Rationale:* Elements are the entities on which data are collected. Variables are the characteristics of
interest. Categorical variables use labels or names, while quantitative variables use numerical values.
The measurement scale is nominal for categorical labels, ordinal for ranked data, interval for numerical
data with no true zero, and ratio for numerical data with a true zero.
---
**Question 3**
Refer to the tablet computer data set.
a. What is the average cost?
b. What is the average cost for tablets with a Windows operating system and for those with an Android
operating system? Compare.
c. What percentage of the tablets use a CPU manufactured by TI OMAP?
d. What percentage of the tablets use an Android operating system?
**Correct Answer / Rationale:**
a. Average cost = = 582.90
b. Average cost with a Windows OS = = 723.20. Average cost with an Android OS = =
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.
*Rationale:* These calculations demonstrate basic descriptive statistics, such as mean and percentage,
to summarize the data.
---
**Question 4**
, A data set contains information on eight cordless telephones. The variables are: Voice Quality, Handset
on Base, Price, Overall Score, and Talk Time.
a. How many elements are in this data set?
b. Which variables are categorical and which are quantitative?
c. What is the measurement scale for each variable?
**Correct Answer / Rationale:**
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.
*Rationale:* This reinforces the distinction between categorical and quantitative data and the different
measurement scales (nominal, ordinal, interval, ratio).
---
**Question 5**
Refer to the cordless telephone data set.
a. What is the average price?
b. What is the average talk time?
c. What percentage of the telephones are rated Excellent?
**Correct Answer / Rationale:**
a. Average Price = = 68.13
b. Average Talk Time = = 8.875 hours
c. Percentage rated Excellent: 2 of 8 = 25%.
*Rationale:* Calculating the mean and percentages are fundamental descriptive statistics.
