|
Introduction to Data Analysis and Decision Making |
|
|
1 | (28) |
|
|
|
2 | (2) |
|
|
|
4 | (7) |
|
|
|
11 | (10) |
|
|
|
21 | (5) |
|
|
|
26 | (3) |
|
Case 1.1 Entertainment on a Cruise Ship |
|
|
27 | (2) |
|
PART 1 Getting, Describing, and Summarizing Data |
|
|
29 | (164) |
|
Describing Data: Graphs and Tables |
|
|
31 | (48) |
|
|
|
33 | (1) |
|
|
|
33 | (5) |
|
Frequency Tables and Histograms |
|
|
38 | (10) |
|
Analyzing Relationships with Scatterplots |
|
|
48 | (4) |
|
|
|
52 | (5) |
|
Exploring Data with Pivot Tables |
|
|
57 | (11) |
|
|
|
68 | (11) |
|
Case 2.1 Customer Arrivals at Bank98 |
|
|
75 | (1) |
|
Case 2.2 Automobile Production and Purchases |
|
|
76 | (1) |
|
Case 2.3 Saving, Spending, and Social Climbing |
|
|
77 | (2) |
|
Describing Data: Summary Measures |
|
|
79 | (56) |
|
|
|
81 | (1) |
|
Measures of Central Location |
|
|
82 | (3) |
|
Quartiles and Percentiles |
|
|
85 | (1) |
|
Minimum, Maximum, and Range |
|
|
85 | (1) |
|
Measures of Variability: Variance and Standard Deviation |
|
|
86 | (5) |
|
Obtaining Summary Measures with Add-Ins |
|
|
91 | (4) |
|
Measures of Association: Covariance and Correlation |
|
|
95 | (4) |
|
Describing Data Sets with Boxplots |
|
|
99 | (5) |
|
|
|
104 | (20) |
|
|
|
124 | (11) |
|
Case 3.1 The Dow Jones Averages |
|
|
131 | (2) |
|
Case 3.2 Other Market Indexes |
|
|
133 | (1) |
|
Case 3.3 Correct Interpretation of Means |
|
|
134 | (1) |
|
|
|
135 | (58) |
|
|
|
136 | (1) |
|
|
|
137 | (3) |
|
|
|
140 | (6) |
|
Complex Queries with the Advanced Filter |
|
|
146 | (6) |
|
Importing External Data from Access |
|
|
152 | (11) |
|
Creating Pivot Tables from External Data |
|
|
163 | (2) |
|
|
|
165 | (8) |
|
Other Data Sources on the Web |
|
|
173 | (6) |
|
|
|
179 | (7) |
|
|
|
186 | (7) |
|
|
|
191 | (2) |
|
PART 2 Probability, Uncertainty, and Decision Making |
|
|
193 | (182) |
|
Probability and Probability Distributions |
|
|
195 | (50) |
|
|
|
196 | (1) |
|
|
|
197 | (7) |
|
Distribution of a Single Random Variable |
|
|
204 | (5) |
|
An Introduction to Simulation |
|
|
209 | (4) |
|
Distribution of Two Random Variables: Scenario Approach |
|
|
213 | (6) |
|
Distribution of Two Random Variables: Joint Probability Approach |
|
|
219 | (6) |
|
Independent Random Variables |
|
|
225 | (4) |
|
Weighted Sums of Random Variables |
|
|
229 | (7) |
|
|
|
236 | (9) |
|
Case 5.1 Simpson's Paradox |
|
|
243 | (2) |
|
Normal, Binomial, Poisson, and Exponential Distributions |
|
|
245 | (60) |
|
|
|
247 | (1) |
|
|
|
247 | (9) |
|
Applications of the Normal Distribution |
|
|
256 | (12) |
|
The Binomial Distribution |
|
|
268 | (5) |
|
Applications of the Binomial Distribution |
|
|
273 | (11) |
|
The Poisson and Exponential Distributions |
|
|
284 | (5) |
|
Fitting a Probability Distribution to Data: BestFit |
|
|
289 | (5) |
|
|
|
294 | (11) |
|
Case 6.1 EuroWatch Company |
|
|
301 | (1) |
|
Case 6.2 Cashing in on the Lottery |
|
|
302 | (3) |
|
Decision Making under Uncertainty |
|
|
305 | (70) |
|
|
|
306 | (1) |
|
Elements of a Decision Analysis |
|
|
307 | (13) |
|
|
|
320 | (12) |
|
|
|
332 | (5) |
|
Multistage Decision Problems |
|
|
337 | (15) |
|
Incorporating Attitudes Toward Risk |
|
|
352 | (6) |
|
|
|
358 | (17) |
|
Case 7.1 Jogger Shoe Company |
|
|
370 | (1) |
|
Case 7.2 Westhouser Paper Company |
|
|
371 | (1) |
|
Case 7.3 Biotechnical Engineering |
|
|
372 | (3) |
|
PART 3 Statistical Inference |
|
|
375 | (184) |
|
Sampling and Sampling Distributions |
|
|
377 | (44) |
|
|
|
378 | (1) |
|
|
|
378 | (1) |
|
Methods for Selecting Random Samples |
|
|
379 | (14) |
|
An Introduction to Estimation |
|
|
393 | (18) |
|
|
|
411 | (10) |
|
Case 8.1 Sampling from Videocassette Renters |
|
|
419 | (2) |
|
Confidence Interval Estimation |
|
|
421 | (66) |
|
|
|
422 | (1) |
|
|
|
423 | (6) |
|
Confidence Interval for a Mean |
|
|
429 | (6) |
|
Confidence Interval for a Total |
|
|
435 | (3) |
|
Confidence Interval for a Proportion |
|
|
438 | (5) |
|
Confidence Interval for a Standard Deviation |
|
|
443 | (3) |
|
Confidence Interval for the Difference Between Means |
|
|
446 | (15) |
|
Confidence Interval for the Difference Between Proportions |
|
|
461 | (6) |
|
Controlling Confidence Interval Length |
|
|
467 | (8) |
|
|
|
475 | (12) |
|
Case 9.1 Harrigan University Admissions |
|
|
482 | (1) |
|
Case 9.2 Employee Retention at D&Y |
|
|
483 | (1) |
|
Case 9.3 Delivery Times at SnowPea Restaurant |
|
|
484 | (1) |
|
Case 9.4 The Bodfish Lot Cruise |
|
|
485 | (2) |
|
|
|
487 | (72) |
|
|
|
488 | (1) |
|
Concepts in Hypothesis Testing |
|
|
489 | (7) |
|
Hypothesis Tests for a Population Mean |
|
|
496 | (7) |
|
Hypothesis Tests for Other Parameters |
|
|
503 | (22) |
|
|
|
525 | (6) |
|
Chi-Square Test for Independence |
|
|
531 | (6) |
|
|
|
537 | (7) |
|
|
|
544 | (15) |
|
Case 10.1 Regression Toward the Mean |
|
|
551 | (1) |
|
Case 10.2 Baseball Statistics |
|
|
552 | (1) |
|
Case 10.3 The Wichita Anti-Drunk Driving Advertising Campaign |
|
|
553 | (2) |
|
Case 10.4 Deciding Whether to Switch to a New Toothpaste Dispenser |
|
|
555 | (3) |
|
Case 10.5 Removing Vioxx from the Market |
|
|
558 | (1) |
|
PART 4 Regression, Forecasting, and Time Series |
|
|
559 | (218) |
|
Regression Analysis: Estimating Relationships |
|
|
561 | (72) |
|
|
|
562 | (3) |
|
Scatterplots: Graphing Relationships |
|
|
565 | (8) |
|
Correlations: Indicators of Linear Relationships |
|
|
573 | (2) |
|
|
|
575 | (11) |
|
|
|
586 | (6) |
|
|
|
592 | (26) |
|
|
|
618 | (2) |
|
|
|
620 | (13) |
|
Case 11.1 Quantity Discounts at the FirmChair Company |
|
|
628 | (1) |
|
Case 11.2 Housing Price Structure in MidCity |
|
|
629 | (1) |
|
Case 11.3 Demand for French Bread at Howie's |
|
|
630 | (1) |
|
Case 11.4 Investing for Retirement |
|
|
631 | (2) |
|
Regression Analysis: Statistical Inference |
|
|
633 | (70) |
|
|
|
635 | (1) |
|
|
|
635 | (4) |
|
Inferences About the Regression Coefficients |
|
|
639 | (10) |
|
|
|
649 | (3) |
|
Include/Exclude Decisions |
|
|
652 | (5) |
|
|
|
657 | (5) |
|
|
|
662 | (8) |
|
|
|
670 | (6) |
|
Violations of Regression Assumptions |
|
|
676 | (5) |
|
|
|
681 | (5) |
|
|
|
686 | (17) |
|
Case 12.1 The Artsy Corporation |
|
|
697 | (2) |
|
Case 12.2 Heating Oil at Dupree Fuels Company |
|
|
699 | (1) |
|
Case 12.3 Developing a Flexible Budget at the Gunderson Plant |
|
|
700 | (1) |
|
Case 12.4 Forecasting Overhead at Wagner Printers |
|
|
701 | (2) |
|
Time Series Analysis and Forecasting |
|
|
703 | (74) |
|
|
|
704 | (1) |
|
Forecasting Methods: An Overview |
|
|
705 | (6) |
|
|
|
711 | (8) |
|
Regression-Based Trend Models |
|
|
719 | (8) |
|
|
|
727 | (4) |
|
|
|
731 | (5) |
|
|
|
736 | (6) |
|
|
|
742 | (11) |
|
|
|
753 | (15) |
|
|
|
768 | (9) |
|
Case 13.1 Arrivals at the Credit Union |
|
|
774 | (1) |
|
Case 13.2 Forecasting Weekly Sales at Amanta |
|
|
775 | (2) |
|
|
|
777 | (278) |
|
Introduction to Optimization Modeling |
|
|
779 | (58) |
|
|
|
780 | (1) |
|
Introduction to Optimization |
|
|
780 | (2) |
|
|
|
782 | (11) |
|
|
|
793 | (7) |
|
Properties of Linear Models |
|
|
800 | (3) |
|
Infeasibility and Unboundedness |
|
|
803 | (2) |
|
|
|
805 | (9) |
|
A Multiperiod Production Model |
|
|
814 | (9) |
|
A Comparison of Algebraic and Spreadsheet Models |
|
|
823 | (1) |
|
A Decision Support System |
|
|
824 | (2) |
|
|
|
826 | (11) |
|
Appendix Information on Solvers |
|
|
832 | (1) |
|
Case 14.1 Shelby Shelving |
|
|
833 | (2) |
|
Case 14.2 Sonoma Valley Wines |
|
|
835 | (2) |
|
Optimization Modeling: Applications |
|
|
837 | (98) |
|
|
|
838 | (1) |
|
Workforce Scheduling Models |
|
|
839 | (7) |
|
|
|
846 | (6) |
|
|
|
852 | (18) |
|
Aggregate Planning Models |
|
|
870 | (9) |
|
|
|
879 | (10) |
|
Integer Programming Models |
|
|
889 | (19) |
|
|
|
908 | (13) |
|
|
|
921 | (14) |
|
Case 15.1 Giant Motor Company |
|
|
928 | (2) |
|
Case 15.2 GMS Stock Hedging |
|
|
930 | (2) |
|
Case 15.3 Durham Asset Management |
|
|
932 | (3) |
|
Introduction to Simulation Modeling |
|
|
935 | (64) |
|
|
|
936 | (1) |
|
Real Applications of Simulation |
|
|
937 | (1) |
|
Probability Distributions for Input Variables |
|
|
938 | (16) |
|
Simulation with Built-In Excel Tools |
|
|
954 | (12) |
|
|
|
966 | (15) |
|
The Effects of Input Distributions on Results |
|
|
981 | (8) |
|
|
|
989 | (10) |
|
Case 16.1 Ski Jacket Production |
|
|
996 | (1) |
|
Case 16.2 Ebony Bath Soap |
|
|
997 | (2) |
|
|
|
999 | (56) |
|
|
|
1000 | (1) |
|
|
|
1000 | (14) |
|
|
|
1014 | (14) |
|
|
|
1028 | (13) |
|
Simulating Games of Chance |
|
|
1041 | (6) |
|
|
|
1047 | (8) |
|
Case 17.1 College Fund Investment |
|
|
1053 | (1) |
|
Case 17.2 Bond Investment Strategy |
|
|
1054 | (1) |
|
Appendix A Statistical Reporting |
|
|
1055 | (19) |
|
|
|
1055 | (1) |
|
Suggestions for Good Statistical Reporting |
|
|
1056 | (5) |
|
Examples of Statistical Reports |
|
|
1061 | (12) |
|
|
|
1073 | (1) |
| References |
|
1074 | (3) |
| Index |
|
1077 | |