| Preface |
|
xvii | |
| About the Authors |
|
xxiii | |
|
|
|
1 | (29) |
|
Statistics in Practice: Business Week |
|
|
2 | (1) |
|
Applications in Business and Economics |
|
|
3 | (2) |
|
|
|
3 | (1) |
|
|
|
4 | (1) |
|
|
|
4 | (1) |
|
|
|
4 | (1) |
|
|
|
4 | (1) |
|
|
|
5 | (3) |
|
Elements, Variables, and Observations |
|
|
6 | (1) |
|
|
|
6 | (1) |
|
Qualitative and Quantitative Data |
|
|
7 | (1) |
|
Cross-Sectional and Time Series Data |
|
|
7 | (1) |
|
|
|
8 | (4) |
|
|
|
8 | (1) |
|
|
|
9 | (3) |
|
|
|
12 | (1) |
|
|
|
12 | (2) |
|
|
|
14 | (1) |
|
Statistical Analysis Using Microsoft Excel |
|
|
15 | (15) |
|
Data Sets and Excel Worksheets |
|
|
16 | (2) |
|
Using Excel for Statistical Analysis |
|
|
18 | (1) |
|
|
|
19 | (1) |
|
|
|
20 | (1) |
|
|
|
21 | (6) |
|
Appendix 1.1 An Introduction to SWStat+ |
|
|
27 | (3) |
|
Descriptive Statistics: Tabular and Graphical Presentations |
|
|
30 | (59) |
|
Statistics in Practice: Colgate-Palmolive Company |
|
|
31 | (1) |
|
Summarizing Qualitative Data |
|
|
32 | (9) |
|
|
|
32 | (1) |
|
Using Excel's Countif Function to Construct a Frequency Distribution |
|
|
33 | (1) |
|
Relative Frequency and Percent Frequency Distributions |
|
|
34 | (1) |
|
Using Excel to Construct Relative Frequency and Percent Frequency Distributions |
|
|
35 | (1) |
|
Bar Graphs and Pie Charts |
|
|
36 | (1) |
|
Using Excel's Chart Wizard to Construct Bar Graphs and Pie Charts |
|
|
36 | (5) |
|
Summarizing Quantitative Data |
|
|
41 | (17) |
|
|
|
41 | (2) |
|
Using Excel's Frequency Function to Construct a Frequency Distribution |
|
|
43 | (2) |
|
Relative Frequency and Percent Frequency Distributions |
|
|
45 | (1) |
|
|
|
45 | (1) |
|
Using Excel's Chart Wizard to Construct a Histogram |
|
|
46 | (2) |
|
|
|
48 | (3) |
|
Using Excel's Histogram Tool to Construct a Frequency Distribution and Histogram |
|
|
51 | (7) |
|
Exploratory Data Analysis: The Stem-and-Leaf Display |
|
|
58 | (5) |
|
Crosstabulations and Scatter Diagrams |
|
|
63 | (26) |
|
|
|
63 | (3) |
|
Using Excel's PivotTable Report to Construct a Crosstabulation |
|
|
66 | (3) |
|
|
|
69 | (1) |
|
Scatter Diagram and Trendline |
|
|
70 | (2) |
|
Using Excel's Chart Wizard to Construct a Scatter Diagram and a Trendline |
|
|
72 | (6) |
|
|
|
78 | (2) |
|
|
|
80 | (1) |
|
|
|
80 | (1) |
|
|
|
81 | (6) |
|
Case Problem Pelican Stores |
|
|
87 | (2) |
|
Descriptive Statistics: Numerical Measures |
|
|
89 | (66) |
|
Statistics in Practice: Small Fry Design |
|
|
90 | (1) |
|
|
|
91 | (12) |
|
|
|
91 | (1) |
|
|
|
92 | (1) |
|
|
|
93 | (1) |
|
Using Excel to Compute the Mean, Median, and Mode |
|
|
94 | (1) |
|
|
|
95 | (1) |
|
|
|
96 | (1) |
|
Using Excel's Rank and Percentile Tool to Compute Percentiles and Quartiles |
|
|
97 | (6) |
|
|
|
103 | (10) |
|
|
|
104 | (1) |
|
|
|
104 | (1) |
|
|
|
105 | (1) |
|
|
|
106 | (2) |
|
Using Excel to Compute the Sample Variance and Sample Standard Deviation |
|
|
108 | (1) |
|
|
|
108 | (1) |
|
Using Excel's Descriptive Statistics Tool |
|
|
108 | (5) |
|
Measures of Distribution Shape, Relative Location, and Detecting Outliers |
|
|
113 | (7) |
|
|
|
113 | (2) |
|
|
|
115 | (1) |
|
|
|
116 | (1) |
|
|
|
116 | (1) |
|
|
|
117 | (3) |
|
Exploratory Data Analysis |
|
|
120 | (5) |
|
|
|
120 | (1) |
|
|
|
121 | (4) |
|
Measures of Association Between Two Variables |
|
|
125 | (10) |
|
|
|
125 | (2) |
|
Interpretation of the Covariance |
|
|
127 | (2) |
|
|
|
129 | (1) |
|
Interpretation of the Correlation Coefficient |
|
|
130 | (2) |
|
Using Excel to Compute the Covariance and Correlation Coefficient |
|
|
132 | (3) |
|
The Weighted Mean and Working with Grouped Data |
|
|
135 | (20) |
|
|
|
135 | (1) |
|
|
|
136 | (5) |
|
|
|
141 | (1) |
|
|
|
141 | (1) |
|
|
|
142 | (2) |
|
|
|
144 | (5) |
|
Case Problem 1 Pelican Stores |
|
|
149 | (1) |
|
Case Problem 2 National Health Care Association |
|
|
150 | (1) |
|
Case Problem 3 Business Schools of Asia-Pacific |
|
|
151 | (1) |
|
Appendix 3.1 Constructing a Box Plot Using SWStat+ |
|
|
151 | (4) |
|
Introduction to Probability |
|
|
155 | (45) |
|
Statistics in Practice: Morton International |
|
|
156 | (1) |
|
Experiments, Counting Rules, and Assigning Probabilities |
|
|
157 | (10) |
|
Counting Rules, Combinations, and Permutations |
|
|
157 | (5) |
|
|
|
162 | (2) |
|
Probabilities for the KP&L Project |
|
|
164 | (3) |
|
Events and Their Probabilities |
|
|
167 | (4) |
|
Some Basic Relationships of Probability |
|
|
171 | (6) |
|
|
|
171 | (1) |
|
|
|
172 | (5) |
|
|
|
177 | (8) |
|
|
|
181 | (1) |
|
|
|
181 | (4) |
|
|
|
185 | (15) |
|
|
|
188 | (1) |
|
Using Excel to Compute Posterior Probabilities |
|
|
189 | (3) |
|
|
|
192 | (1) |
|
|
|
192 | (1) |
|
|
|
193 | (1) |
|
|
|
194 | (4) |
|
Case Problem Hamilton County Judges |
|
|
198 | (2) |
|
Discrete Probability Distributions |
|
|
200 | (40) |
|
Statistics in Practice: Citibank |
|
|
201 | (1) |
|
|
|
201 | (3) |
|
Discrete Random Variables |
|
|
202 | (1) |
|
Continuous Random Variables |
|
|
203 | (1) |
|
Discrete Probability Distributions |
|
|
204 | (6) |
|
Expected Value and Variance |
|
|
210 | (5) |
|
|
|
210 | (1) |
|
|
|
210 | (1) |
|
Using Excel to Compute the Expected Value, Variance, and Standard Deviation |
|
|
211 | (4) |
|
Binomial Probability Distribution |
|
|
215 | (11) |
|
|
|
216 | (1) |
|
Martin Clothing Store Problem |
|
|
216 | (5) |
|
Using Excel to Compute Binomial Probabilities |
|
|
221 | (2) |
|
Expected Value and Variance for the Binomial Probability Distribution |
|
|
223 | (3) |
|
Poisson Probability Distribution |
|
|
226 | (5) |
|
An Example Involving Time Intervals |
|
|
226 | (1) |
|
An Example Involving Length or Distance Intervals |
|
|
227 | (1) |
|
Using Excel to Compute Poisson Probabilities |
|
|
228 | (3) |
|
Hypergeometric Probability Distribution |
|
|
231 | (9) |
|
Using Excel to Compute Hypergeometric Probabilities |
|
|
233 | (2) |
|
|
|
235 | (1) |
|
|
|
235 | (1) |
|
|
|
236 | (1) |
|
|
|
237 | (3) |
|
Continuous Probability Distributions |
|
|
240 | (31) |
|
Statistics in Practice: Procter & Gamble |
|
|
241 | (1) |
|
Uniform Probability Distribution |
|
|
242 | (4) |
|
Area as a Measure of Probability |
|
|
243 | (3) |
|
Normal Probability Distribution |
|
|
246 | (15) |
|
|
|
246 | (2) |
|
Standard Normal Probability Distribution |
|
|
248 | (5) |
|
Computing Probabilities for Any Normal Probability Distribution |
|
|
253 | (1) |
|
Grear Tire Company Problem |
|
|
254 | (2) |
|
Using Excel to Compute Normal Probabilities |
|
|
256 | (5) |
|
Exponential Probability Distribution |
|
|
261 | (10) |
|
Computing Probabilities for the Exponential Distribution |
|
|
262 | (1) |
|
Relationship Between the Poisson and Exponential Distributions |
|
|
263 | (1) |
|
Using Excel to Compute Exponential Probabilities |
|
|
263 | (3) |
|
|
|
266 | (1) |
|
|
|
266 | (1) |
|
|
|
266 | (1) |
|
|
|
267 | (2) |
|
Case Problem Specialty Toys |
|
|
269 | (2) |
|
Sampling and Sampling Distribution |
|
|
271 | (37) |
|
Statistics in Practice: MeadWestvaco Corporation |
|
|
272 | (1) |
|
The Electronics Associates Sampling Problem |
|
|
273 | (1) |
|
|
|
274 | (6) |
|
Sampling from a Finite Population |
|
|
274 | (4) |
|
Sampling from an Infinite Population |
|
|
278 | (2) |
|
|
|
280 | (3) |
|
Introduction to Sampling Distributions |
|
|
283 | (3) |
|
Sampling Distribution of x |
|
|
286 | (10) |
|
|
|
286 | (1) |
|
|
|
287 | (1) |
|
Form of the Sampling Distribution of x |
|
|
288 | (2) |
|
Sampling Distribution of x for the EAI Problem |
|
|
290 | (1) |
|
Practical Value of the Sampling Distribution of x |
|
|
290 | (2) |
|
Relationship Between Sample Size and the Sampling Distribution of x |
|
|
292 | (4) |
|
Sampling Distribution of p |
|
|
296 | (5) |
|
|
|
296 | (1) |
|
|
|
297 | (1) |
|
Form of the Sampling Distribution of p |
|
|
297 | (1) |
|
Practical Value of the Sampling Distribution of p |
|
|
298 | (3) |
|
|
|
301 | (7) |
|
Stratified Random Sampling |
|
|
301 | (1) |
|
|
|
301 | (1) |
|
|
|
302 | (1) |
|
|
|
303 | (1) |
|
|
|
303 | (1) |
|
|
|
304 | (1) |
|
|
|
304 | (1) |
|
|
|
305 | (1) |
|
|
|
305 | (3) |
|
|
|
308 | (39) |
|
Statistics in Practice: Food Lion |
|
|
309 | (1) |
|
|
|
310 | (8) |
|
Margin of Error and the Interval Estimate |
|
|
310 | (4) |
|
|
|
314 | (2) |
|
|
|
316 | (2) |
|
Population Mean: σ Unknown |
|
|
318 | (10) |
|
Margin of Error and the Interval Estimate |
|
|
319 | (3) |
|
|
|
322 | (1) |
|
|
|
323 | (1) |
|
|
|
323 | (2) |
|
Summary of Interval Estimation Procedures |
|
|
325 | (3) |
|
Determining the Sample Size |
|
|
328 | (3) |
|
|
|
331 | (16) |
|
|
|
332 | (2) |
|
Determining the Sample Size |
|
|
334 | (4) |
|
|
|
338 | (1) |
|
|
|
339 | (1) |
|
|
|
339 | (1) |
|
|
|
340 | (3) |
|
Case Problem 1 Bock Investment Services |
|
|
343 | (1) |
|
Case Problem 2 Gulf Real Estate Properties |
|
|
343 | (3) |
|
Case Problem 3 Metropolitan Research, Inc. |
|
|
346 | (1) |
|
|
|
347 | (46) |
|
Statistics in Practice: John Morrell & Company |
|
|
348 | (1) |
|
Developing Null and Alternative Hypotheses |
|
|
349 | (2) |
|
Testing Research Hypotheses |
|
|
349 | (1) |
|
Testing the Validity of a Claim |
|
|
349 | (1) |
|
Testing in Decision-Making Situations |
|
|
350 | (1) |
|
Summary of Forms for Null and Alternative Hypotheses |
|
|
350 | (1) |
|
Type I and Type II Errors |
|
|
351 | (3) |
|
|
|
354 | (16) |
|
|
|
354 | (6) |
|
|
|
360 | (3) |
|
|
|
363 | (1) |
|
Summary and Practical Advice |
|
|
364 | (2) |
|
Relationship Between Interval Estimation and Hypothesis Testing |
|
|
366 | (4) |
|
Population Mean: σ Unknown |
|
|
370 | (10) |
|
|
|
371 | (1) |
|
|
|
372 | (2) |
|
|
|
374 | (2) |
|
Summary and Practical Advice |
|
|
376 | (4) |
|
|
|
380 | (13) |
|
|
|
382 | (2) |
|
|
|
384 | (2) |
|
|
|
386 | (1) |
|
|
|
387 | (1) |
|
|
|
387 | (1) |
|
|
|
388 | (2) |
|
Case Problem 1 Quality Associates, Inc. |
|
|
390 | (2) |
|
Case Problem 2 Unemployment Study |
|
|
392 | (1) |
|
Comparisons Involving Means |
|
|
393 | (57) |
|
Statistics in Practice: Fisons Corporation |
|
|
394 | (1) |
|
Inferences About the Difference Between Two Population Means: σ1 and σ2 Known |
|
|
395 | (10) |
|
Interval Estimation of μ1 - μ2 |
|
|
395 | (2) |
|
Using Excel to Construct a Confidence Interval |
|
|
397 | (2) |
|
Hypothesis Tests About μ1 - μ2 |
|
|
399 | (2) |
|
Using Excel to Conduct a Hypothesis Test |
|
|
401 | (2) |
|
|
|
403 | (2) |
|
Inferences About the Difference Between Two Population Means: σ1 and σ2 Unknown |
|
|
405 | (12) |
|
Interval Estimation of μ1 - μ2 |
|
|
406 | (1) |
|
Using Excel to Construct a Confidence Interval |
|
|
407 | (2) |
|
Hypothesis Tests About μ1 - μ2 |
|
|
409 | (2) |
|
Using Excel to Conduct a Hypothesis Test |
|
|
411 | (2) |
|
|
|
413 | (4) |
|
Inferences About the Difference Between Two Population Means: Matched Samples |
|
|
417 | (7) |
|
Using Excel to Conduct a Hypothesis Test |
|
|
419 | (5) |
|
Introduction to Analysis of Variance |
|
|
424 | (4) |
|
Assumptions for Analysis of Variance |
|
|
425 | (1) |
|
|
|
425 | (3) |
|
Analysis of Variance: Testing for the Equality of k Population Means |
|
|
428 | (22) |
|
Between-Treatments Estimate of Population Variance |
|
|
429 | (1) |
|
Within-Treatments Estimate of Population Variance |
|
|
430 | (1) |
|
Comparing the Variance Estimates: The F Test |
|
|
430 | (3) |
|
|
|
433 | (1) |
|
|
|
433 | (6) |
|
|
|
439 | (1) |
|
|
|
439 | (1) |
|
|
|
440 | (2) |
|
|
|
442 | (4) |
|
|
|
446 | (1) |
|
Case Problem 2 Wentworth Medical Center |
|
|
447 | (1) |
|
Case Problem 3 Compensation for ID Professionals |
|
|
448 | (2) |
|
Comparisons Involving Proportions and a Test of Independence |
|
|
450 | (34) |
|
Statistics in Practice: United Way |
|
|
451 | (1) |
|
Inferences About the Difference Between Two Population Proportions |
|
|
452 | (9) |
|
Interval Estimation of p1 - p2 |
|
|
452 | (2) |
|
Using Excel to Construct a Confidence Interval |
|
|
454 | (2) |
|
Hypothesis Tests About p1 - p2 |
|
|
456 | (1) |
|
Using Excel to Conduct a Hypothesis Test |
|
|
457 | (4) |
|
Hypothesis Test for Proportions of a Multinomial Population |
|
|
461 | (8) |
|
Using Excel to Conduct a Goodness of Fit Test |
|
|
466 | (3) |
|
|
|
469 | (15) |
|
Using Excel to Conduct a Test of Independence |
|
|
473 | (4) |
|
|
|
477 | (1) |
|
|
|
477 | (1) |
|
|
|
478 | (1) |
|
|
|
478 | (5) |
|
Case Problem A Bipartisan Agenda for Change |
|
|
483 | (1) |
|
|
|
484 | (75) |
|
Statistics in Practice: Alliance Data Systems |
|
|
485 | (1) |
|
Simple Linear Regression Model |
|
|
486 | (3) |
|
Regression Model and Regression Equation |
|
|
486 | (1) |
|
Estimated Regression Equation |
|
|
487 | (2) |
|
|
|
489 | (12) |
|
Using Excel to Develop a Scatter Diagram and Compute the Estimated Regression Equation |
|
|
493 | (8) |
|
Coefficient of Determination |
|
|
501 | (9) |
|
Using Excel to Compute the Coefficient of Determination |
|
|
505 | (1) |
|
|
|
505 | (5) |
|
|
|
510 | (1) |
|
|
|
511 | (10) |
|
|
|
512 | (1) |
|
|
|
512 | (2) |
|
Confidence Interval for β1 |
|
|
514 | (1) |
|
|
|
515 | (2) |
|
Some Cautions About the Interpretation of Significance Tests |
|
|
517 | (4) |
|
|
|
521 | (6) |
|
Using Excel's Regression Tool for the Armand's Pizza Parlors Problem |
|
|
521 | (2) |
|
Interpretation of Estimated Regression Equation Output |
|
|
523 | (1) |
|
Interpretation of ANOVA Output |
|
|
523 | (1) |
|
Interpretation of Regression Statistics Output |
|
|
524 | (3) |
|
Using the Estimated Regression Equation for Estimation and Prediction |
|
|
527 | (8) |
|
|
|
527 | (1) |
|
|
|
527 | (1) |
|
Confidence Interval Estimate of the Mean Value of y |
|
|
527 | (2) |
|
Prediction Interval Estimate of an Individual Value of y |
|
|
529 | (2) |
|
Using Excel to Develop Confidence and Prediction Interval Estimates |
|
|
531 | (4) |
|
Residual Analysis: Validating Model Assumptions |
|
|
535 | (24) |
|
|
|
536 | (3) |
|
|
|
539 | (1) |
|
Using Excel's Regression Tool to Construct a Residual Plot |
|
|
539 | (3) |
|
|
|
542 | (1) |
|
|
|
543 | (1) |
|
|
|
543 | (2) |
|
|
|
545 | (6) |
|
Case Problem 1 Spending and Student Achievement |
|
|
551 | (1) |
|
Case Problem 2 U.S. Department of Transportation |
|
|
552 | (1) |
|
Case Problem 3 Alumni Giving |
|
|
553 | (2) |
|
Case Problem 4 Major League Baseball Teams Values |
|
|
555 | (1) |
|
Appendix 12.1 Regression Analysis with SWStat+ |
|
|
555 | (4) |
|
|
|
559 | (50) |
|
Statistics in Practice: International Paper |
|
|
560 | (1) |
|
Multiple Regression Model |
|
|
561 | (1) |
|
Regression Model and Regression Equation |
|
|
561 | (1) |
|
Estimated Multiple Regression Equation |
|
|
561 | (1) |
|
|
|
562 | (10) |
|
An Example: Butler Trucking Company |
|
|
563 | (3) |
|
Using Excel's Regression Tool to Develop the Estimated Multiple Regression Equation |
|
|
566 | (1) |
|
Note on Interpretation of Coefficients |
|
|
567 | (5) |
|
Multiple Coefficient of Determination |
|
|
572 | (3) |
|
|
|
575 | (2) |
|
|
|
577 | (7) |
|
|
|
578 | (2) |
|
|
|
580 | (1) |
|
|
|
581 | (3) |
|
Using the Estimated Regression Equation for Estimation and Prediction |
|
|
584 | (2) |
|
Qualitative Independent Variables |
|
|
586 | (23) |
|
An Example: Johnson Filtration. Inc. |
|
|
587 | (2) |
|
Interpreting the Parameters |
|
|
589 | (2) |
|
More Complex Qualitative Variables |
|
|
591 | (4) |
|
|
|
595 | (1) |
|
|
|
596 | (1) |
|
|
|
596 | (1) |
|
|
|
597 | (6) |
|
Case Problem 1 Consumer Research, Inc. |
|
|
603 | (1) |
|
Case Problem 2 Predicting Student Proficiency Test Scores |
|
|
604 | (1) |
|
Case Problem 3 Alumni Giving |
|
|
605 | (2) |
|
Appendix 13.1 Multiple Regression Analysis with SWStat+ |
|
|
607 | (2) |
|
Statistical Methods for Quality Control |
|
|
609 | (37) |
|
Statistics in Practice: Dow Chemical |
|
|
610 | (1) |
|
Philosophies and Frameworks |
|
|
611 | (3) |
|
Malcolm Baldrige National Quality Award |
|
|
611 | (1) |
|
|
|
612 | (1) |
|
|
|
612 | (2) |
|
Statistical Process Control |
|
|
614 | (17) |
|
|
|
615 | (1) |
|
x Chart: Process Mean and Standard Deviation Known |
|
|
616 | (2) |
|
x Chart: Process Mean and Standard Deviation Unknown |
|
|
618 | (3) |
|
|
|
621 | (2) |
|
Using Excel to Construct an R Chart and an x Chart |
|
|
623 | (3) |
|
|
|
626 | (2) |
|
|
|
628 | (1) |
|
Interpretation of Control Charts |
|
|
629 | (2) |
|
|
|
631 | (15) |
|
KALI, Inc.: An Example of Acceptance Sampling |
|
|
633 | (1) |
|
Computing the Probability of Accepting a Lot |
|
|
633 | (2) |
|
Selecting an Acceptance Sampling Plan |
|
|
635 | (2) |
|
|
|
637 | (2) |
|
|
|
639 | (1) |
|
|
|
640 | (1) |
|
|
|
641 | (1) |
|
|
|
642 | (4) |
| Appendix A: References and Bibliography |
|
646 | (2) |
| Appendix B: Tables |
|
648 | (11) |
| Appendix C: Summation Notation |
|
659 | (2) |
| Appendix D: Self-Test Solutions and Answers to Even-Numbered Exercises |
|
661 | (30) |
| Appendix E: Using Excel Functions |
|
691 | (6) |
| Index |
|
697 | |