Essentials of Modern Business Statistics with Microsoft Excel 8th Edition Solutions Manual 2026 | David R. Anderson Step-by-Step Guide

Essentials of Modern Business Statistics with
Microsoft Excel 8th Edition Solutions Manual 2026 –
David R. Anderson Complete Step-by-Step Guide

All chapters covered

,Chapter 1 i




Data and Statistics
i i




Learning Objectives
i




1. Obtain an appreciation for the breadth of statistical applications in business and economics.
i i i i i i i i i i i i




2. Understand the meaning of the terms elements, variables, and observations as they are used in
i i i i i i i i i i i i i i


statistics.
i




3. Obtain an understanding of the difference between categorical, quantitative, cross-sectional, and
i i i i i i i i i i


time series data.
i i i




4. Learn about the sources of data for statistical analysis both internal and external to the firm.
i i i i i i i i i i i i i i i




5. Be aware of how errors can arise in data.
i i i i i i i i




6. Know the meaning of descriptive statistics and statistical inference.
i i i i i i i i




7. Be able to distinguish between a population and a sample.
i i i i i i i i i




8. Understand the role a sample plays in making statistical inferences about the population.
i i i i i i i i i i i i




9. Know the meaning of the terms analytics, big data and data mining.
i i i i i i i i i i i




10. Be aware of ethical guidelines for statistical practice.
i i i i i i i

,
, Solutions:

1. Statistics can be referred to as numerical facts. In a broader sense, statistics is the field of study
i i i i i i i i i i i i i i i i i


dealing with the collection, analysis, presentation, and interpretation of data.
i i i i i i i i i i




2. a. The ten elements are the ten tablet computers.
i i i i i i i




b. Five variables: Cost ($), Operating System, Display Size (inches), Battery Life (hours), CPU
i i i i i i i i i i i i


Manufacturer
i




c. Categorical variables: Operating System and CPU Manufacturer i i i i i i




Quantitative variables: Cost ($), Display Size (inches), and Battery Life (hours) i i i i i i i i i i




d. i


Variable Measurement Scale i


Cost ($) i Ratio
Operating System i Nominal
Display Size (inches) i i Ratio
Battery Life (hours) i i Ratio
i i CPU Manufacturer i Nominal

3. a. Average cost = 5829/10 = $582.90 i i i i i




b. Average cost with a Windows operating system = 3616/5 = $723.20
i i i i i i i i i i




Average cost with an Android operating system = 1714/4 = $428.5
i i i i i i i i i i i




i The average cost with a Windows operating system is much higher.
i i i i i i i i i i




c. 2 of 10 or 20% use a CPU manufactured by TI OMAP.
i i i i i i i i i i i




d. 4 of 10 or 40% use an Android operating system.
i i i i i i i i i




4. a. There are eight elements in this data set; each element corresponds to one of the eight models of
i i i i i i i i i i i i i i i i i


cordless telephones.
i i




b. Categorical variables: Voice Quality and Handset on Base i i i i i i i




i Quantitative variables: Price, Overall Score, and Talk Time i i i i i i i




c. Price – ratio measurement
i i i


Overall Score – interval measurement i i i i


Voice Quality – ordinal measurement
i i i i i


Handset on Base – nominal measurement
i i i i i i


Talk Time – ratio measurement
i i i i i




5. a. Average Price = 545/8 = $68.13 i i i i i




b. Average Talk Time = 71/8 = 8.875 hours i i i i i i i




c. Percentage rated Excellent: 2 of 8 i i i i i 2/8 = .25, or 25% i i i i




4-2 i i