| Preface |
|
xv | |
|
Introduction to Managerial Statistics |
|
|
2 | (22) |
|
|
|
4 | (2) |
|
|
|
6 | (5) |
|
Excel versus Stand-alone Statistical Software |
|
|
11 | (1) |
|
|
|
12 | (9) |
|
|
|
21 | (3) |
|
Case Study: Entertainment on a Cruise Ship |
|
|
22 | (2) |
|
Describing Data: Graphs and Tables |
|
|
24 | (48) |
|
|
|
26 | (1) |
|
|
|
27 | (4) |
|
Frequency Tables and Histograms |
|
|
31 | (11) |
|
Analyzing Relationships with Scatterplots |
|
|
42 | (4) |
|
|
|
46 | (5) |
|
Exploring Data with Pivot Tables |
|
|
51 | (9) |
|
Pivot Table Changes in Excel 2000 |
|
|
60 | (3) |
|
|
|
63 | (9) |
|
Case Study: Customer Arrivals at Bank98 |
|
|
70 | (1) |
|
Case Study: Automobile Production and Purchases |
|
|
70 | (1) |
|
Case Study: Saving, Spending, and Social Climbing |
|
|
71 | (1) |
|
Describing Data: Summary Measures |
|
|
72 | (52) |
|
|
|
74 | (1) |
|
Measures of Central Location |
|
|
74 | (2) |
|
Quartiles and Percentiles |
|
|
76 | (1) |
|
Minimum, Maximum, and Range |
|
|
77 | (1) |
|
Measures of Variability: Variance and Standard Deviation |
|
|
78 | (4) |
|
Obtaining Summary Measures with Add-Ins |
|
|
82 | (5) |
|
Measures of Association: Covariance and Correlation |
|
|
87 | (4) |
|
Describing Data Sets with Boxplots |
|
|
91 | (4) |
|
|
|
95 | (17) |
|
|
|
112 | (12) |
|
Case Study: The Dow-Jones Averages |
|
|
120 | (2) |
|
Case Study: Other Market Indexes |
|
|
122 | (2) |
|
Getting the Right Data in Excel |
|
|
124 | (54) |
|
|
|
126 | (1) |
|
|
|
127 | (9) |
|
|
|
136 | (7) |
|
Complex Queries with the Advanced Filter |
|
|
143 | (7) |
|
Importing External Data from Access |
|
|
150 | (12) |
|
Creating Pivot Tables from External Data |
|
|
162 | (3) |
|
|
|
165 | (10) |
|
|
|
175 | (3) |
|
Case Study: EduToys, Inc. |
|
|
176 | (2) |
|
Probability and Probability Distributions |
|
|
178 | (64) |
|
|
|
180 | (1) |
|
|
|
181 | (6) |
|
Distribution of a Single Random Variable |
|
|
187 | (4) |
|
An Introduction to Simulation |
|
|
191 | (5) |
|
Subjective Versus Objective Probabilities |
|
|
196 | (2) |
|
Derived Probability Distributions |
|
|
198 | (4) |
|
Distribution of Two Random Variables: Scenario Approach |
|
|
202 | (7) |
|
Distribution of Two Random Variables: Joint Probability Approach |
|
|
209 | (10) |
|
Independent Random Variables |
|
|
219 | (5) |
|
Weighted Sums of Random Variables |
|
|
224 | (7) |
|
|
|
231 | (11) |
|
Case Study: Simpson's Paradox |
|
|
240 | (2) |
|
Normal, Binomial, and Poisson Distributions |
|
|
242 | (56) |
|
|
|
244 | (1) |
|
|
|
245 | (9) |
|
Applications of the Normal Distribution |
|
|
254 | (12) |
|
The Binomial Distribution |
|
|
266 | (4) |
|
Applications of the Binomial Distribution |
|
|
270 | (12) |
|
|
|
282 | (4) |
|
Fitting a Probability Distribution to Data: BestFit |
|
|
286 | (3) |
|
|
|
289 | (9) |
|
Case Study: EuroWatch Company |
|
|
295 | (1) |
|
Case Study: Cashing in on the Lottery |
|
|
296 | (2) |
|
Decision Making Under Uncertainty |
|
|
298 | (78) |
|
|
|
300 | (1) |
|
Elements of a Decision Analysis |
|
|
301 | (11) |
|
The Precision Tree Add-In |
|
|
312 | (10) |
|
Introduction to Influence Diagrams |
|
|
322 | (6) |
|
More Single-Stage Examples |
|
|
328 | (10) |
|
Multistage Decision Problems |
|
|
338 | (9) |
|
|
|
347 | (8) |
|
Incorporating Attitudes Toward Risk |
|
|
355 | (8) |
|
|
|
363 | (13) |
|
Case Study: Jogger Shoe Company |
|
|
374 | (1) |
|
Case Study: Westhouser Paper Company |
|
|
374 | (2) |
|
Sampling and Sampling Distributions |
|
|
376 | (46) |
|
|
|
378 | (1) |
|
|
|
378 | (1) |
|
Methods for Selecting Random Samples |
|
|
379 | (16) |
|
An Introduction to Estimation |
|
|
395 | (17) |
|
|
|
412 | (10) |
|
Case Study: Sampling from Videocassette Renters |
|
|
421 | (1) |
|
Confidence Interval Estimation |
|
|
422 | (64) |
|
|
|
424 | (1) |
|
|
|
425 | (4) |
|
Confidence Interval for a Mean |
|
|
429 | (5) |
|
Confidence Interval for a Total |
|
|
434 | (3) |
|
Confidence Interval for a Proporation |
|
|
437 | (5) |
|
Confidence Interval for a Standard Deviation |
|
|
442 | (4) |
|
Confidence Interval for the Difference Between Means |
|
|
446 | (12) |
|
Confidence Interval for the Difference Between Proportions |
|
|
458 | (8) |
|
Controlling Confidence Interval Length |
|
|
466 | (7) |
|
|
|
473 | (13) |
|
Case Study: Harrigan University Admissions |
|
|
480 | (1) |
|
Case Study: Employee Retention at D & Y |
|
|
481 | (1) |
|
Case Study: Delivery Times at SnowPea Restaurant |
|
|
482 | (1) |
|
Case Study: The Bodfish Lot Cruise |
|
|
483 | (3) |
|
|
|
486 | (60) |
|
|
|
488 | (1) |
|
Concepts in Hypothesis Testing |
|
|
489 | (6) |
|
Hypothesis Tests for a Population Mean |
|
|
495 | (10) |
|
Hypothesis Tests for Other Parameters |
|
|
505 | (21) |
|
|
|
526 | (6) |
|
Chi-Square Test for Independence |
|
|
532 | (5) |
|
|
|
537 | (9) |
|
Case Study: Regression Toward the Mean |
|
|
542 | (1) |
|
Case Study: Baseball Statistics |
|
|
543 | (1) |
|
Case Study: The Wichita Anti-Drunk Driving Advertising Campaign |
|
|
543 | (3) |
|
Statistical Process Control |
|
|
546 | (62) |
|
|
|
549 | (1) |
|
|
|
550 | (3) |
|
Basic Ideas Behind Control Charts |
|
|
553 | (2) |
|
Control Charts for Variables |
|
|
555 | (20) |
|
Control Charts for Attributes |
|
|
575 | (8) |
|
|
|
583 | (11) |
|
|
|
594 | (14) |
|
Case Study: The Lamination Process at Intergalactica |
|
|
599 | (2) |
|
Case Study: Paper Production for Fornax at the Pluto Mill |
|
|
601 | (7) |
|
Analysis of Variance and Experimental Design |
|
|
608 | (46) |
|
|
|
610 | (3) |
|
|
|
613 | (12) |
|
The Multiple Comparison Problem |
|
|
625 | (6) |
|
|
|
631 | (12) |
|
More About Experimental Design |
|
|
643 | (9) |
|
|
|
652 | (2) |
|
Case Study: Krentz Appraisal Services |
|
|
653 | (1) |
|
Regression Analysis: Estimating Relationships |
|
|
654 | (68) |
|
|
|
656 | (2) |
|
Scatterplots: Graphing Relationships |
|
|
658 | (9) |
|
Correlations: Indicators of Linear Relationships |
|
|
667 | (2) |
|
|
|
669 | (10) |
|
|
|
679 | (6) |
|
|
|
685 | (26) |
|
|
|
711 | (2) |
|
|
|
713 | (9) |
|
Case Study: Quantity Discounts at the FirmChair Company |
|
|
720 | (1) |
|
Case Study: Housing Price Structure in MidCity |
|
|
720 | (1) |
|
Case Study: Demand for French Bread at Howie's |
|
|
721 | (1) |
|
Case Study: Investing for Retirement |
|
|
721 | (1) |
|
Regression Analysis: Statistical Inference |
|
|
722 | (75) |
|
|
|
724 | (1) |
|
|
|
725 | (3) |
|
Inferences About the Regression Coefficients |
|
|
728 | (6) |
|
|
|
734 | (4) |
|
Include/Exclude Decisions |
|
|
738 | (5) |
|
|
|
743 | (5) |
|
A Test for the Overall Fit: The ANOVA Table |
|
|
748 | (4) |
|
|
|
752 | (9) |
|
|
|
761 | (6) |
|
Violations of Regression Assumptions |
|
|
767 | (4) |
|
|
|
771 | (8) |
|
|
|
779 | (18) |
|
Case Study: The Artsy Corporation |
|
|
790 | (1) |
|
Case Study: Heating Oil at Dupree Fuels Company |
|
|
791 | (2) |
|
Case Study: Developing a Flexible Budget at the Gunderson Plant |
|
|
793 | (1) |
|
Case Study: Forecasting Overhead at Wagner Printers |
|
|
794 | (3) |
|
Discriminant Analysis and Logistic Regression |
|
|
797 | (39) |
|
|
|
799 | (1) |
|
|
|
800 | (19) |
|
|
|
819 | (15) |
|
Choosing Between the Two Methods |
|
|
834 | (1) |
|
|
|
834 | (2) |
|
Case Study: Understanding Cereal Brand Preferences |
|
|
835 | (1) |
|
Time Series Analysis and Forecasting |
|
|
836 | (70) |
|
|
|
838 | (1) |
|
Forecasting Methods: An Overview |
|
|
839 | (4) |
|
|
|
843 | (10) |
|
|
|
853 | (4) |
|
|
|
857 | (6) |
|
Regression-Based Trend Models |
|
|
863 | (7) |
|
|
|
870 | (6) |
|
|
|
876 | (14) |
|
Deseasonalizing: The Ratio-to-Moving-Averages Method |
|
|
890 | (4) |
|
Estimating Seasonality with Regression |
|
|
894 | (5) |
|
|
|
899 | (1) |
|
|
|
900 | (6) |
|
Case Study: Arrivals at the Credit Union |
|
|
904 | (1) |
|
Case Study: Forecasting Weekly Sales at Amanta |
|
|
904 | (2) |
|
|
|
906 | (20) |
|
|
|
907 | (1) |
|
Suggestions for Good Statistical Report Writing |
|
|
908 | (5) |
|
Examples of Statistical Reports |
|
|
913 | (12) |
|
|
|
925 | (1) |
| References |
|
926 | (3) |
| Index |
|
929 | |