A Microsoft Excel Companion for Business Statistics

David L. Eldredge is Professor of Computer Science in the College of Business and Public Policy at Murray State University. He earned a Bachelor of Science degree in aerospace engineering from Iowa State University, and an M.S. and a Ph.D. in operations research from the Ohio State University. Professor Eldredge's current teaching responsibilities include management science for Murray State University's MBA program and business statistics for the undergraduate business administration program. He served as Dean of the College of Business for eight years. Dave Eldredge has had over fifteen books and papers published primarily in the areas of simulation and gaming, and the use of Microsoft(R) Excel for data analysis. He also has ten years of industrial experience with four different Fortune 500 firms. Dave Eldredge and his wife Judy are parents of three daughters -- Kristi, Lynn and Tracey - and have seven grandchildren. The Eldredges share a love for camping and travel, they have visited all 50 states and many other countries.

1. Introduction to Statistics with Excel. 2. Descriptive Charts and Graphs. 3. Descriptive Numerical Measures. 4. Probability and Sampling Distributions. 5. Statistical Inference for Population Means. 6. Statistical Inference for Population Proportions. 7. Statistical Inference for Population Variances. 8. Analysis of Variance. 9. Applications of the Chi-Square Statistic. 10. Regression Analysis. 11. Time Series Forecasting. 12. Statistical Quality Control Charts. Appendix A. Excel Data Analysis Tools. Appendix B. Excel Statistical Functions. Appendix C. Procedures for Constructing a Box Plot.