Essentials of Modern Business Statistics with Microsoft Excel, by
v v v v v v v v
Anderson
v
8th Edition
v
TESTBANK v
,Chapter 1 v
Data and Statistics
v v
Learning Objectives
v
1. Obtain an appreciation for the breadth of statistical applications in business and economics.
v v v v v v v v v v v v
2. Understand the meaning of the terms elements, variables, and observations as they are used in
v v v v v v v v v v v v v v
statistics.
v
3. Obtain an understanding of the difference between categorical, quantitative, cross-sectional, and
v v v v v v v v v v
time series data.
v v v
4. Learn about the sources ofdata for statistical analysis both internal and external to the firm.
v v v v v v v v v v v v v v v
5. Be aware of how errors can arise in data.
v v v v v v v v
6. Know the meaning of descriptive statistics and statistical inference.
v v v v v v v v
7. Be able to distinguish between a population and a sample.
v v v v v v v v v
8. Understand the role a sample plays in making statistical inferences about the population.
v v v v v v v v v v v v
9. Know the meaning of the terms analytics, big data and data mining.
v v v v v v v v v v v
10. Be aware of ethical guidelines for statistical practice.
v v v v v v v
,
, Solutions:
1. Statistics can be referred to as numerical facts. In a broader sense, statistics is the field of study
v v v v v v v v v v v v v v v v v
dealing with the collection, analysis, presentation, and interpretation of data.
v v v v v v v v v v
2. a. The ten elements are the ten tablet computers.
v v v v v v v
b. Five variables: Cost ($), Operating System, Display Size (inches), Battery Life (hours), CPU
v v v v v v v v v v v v
Manufacturer
v
c. Categorical variables: Operating System and CPU Manufacturer v v v v v v
Quantitative variables: Cost ($), Display Size (inches), and Battery Life (hours) v v v v v v v v v v
d. v
Variable Measurement Scale v
Cost ($) v Ratio
Operating System v Nominal
Display Size (inches) v v Ratio
Battery Life (hours) v v Ratio
v CPU Manufacturer v Nominal
3. a. Average cost = 5829/10 = $582.90 v v v v v
b. Average cost with a Windows operating system = 3616/5 = $723.20
v v v v v v v v v v
v Average cost with an Android operating system = 1714/4 = $428.5
v v v v v v v v v v
v The average cost with a Windows operating system is much higher.
v v v v v v v v v v
c. 2 of 10 or 20% use a CPU manufactured by TI OMAP.
v v v v v v v v v v v
d. 4 of 10 or 40% use an Android operating system.
v v v v v v v v v
4. a. There are eight elements in this data set; each element corresponds to one of the eight models of
v v v v v v v v v v v v v v v v v
cordless telephones.
v v
b. Categorical variables: Voice Quality and Handset on Base v v v v v v v
v Quantitative variables: Price, Overall Score, and Talk Time v v v v v v v
c. Price – ratio measurement v v v
Overall Score – interval measurement Voice v v v v v
Quality – ordinal measurement Handset on
v v v v v v
Base – nominal measurement Talk Time –
v v v v v v v
ratio measurement
v v
5. a. Average Price = 545/8 = $68.13 v v v v v
b. Average Talk Time = 71/8 = 8.875 hours v v v v v v v
c. Percentage rated Excellent: 2 of 8 v v v v v 2/8 = .25, or 25% v v v v
4 -2 v v