Data Analysis for Managers with Microsoft Excel /
S. Christian Albright, Wayne L. Winston, Christopher Zappe ; with case studies by Mark Broadie, Peter Kolesar.
- 2nd ed.
- Belmont, CA : Thomson/Brooks/Cole, c2004.
- xxi, 952 p. : ill. ; 27 cm. + 1 CD-ROM (4 3/4 in.)
Rev. ed. of Managerial statistics. 1st ed. 1990. CD-ROM includes latest version of Stat Pro and Decision Tools.
Includes bibliographical references (p. 943-945) and index.
Introduction to Data Analysis for Managers. Part I Getting, Describing and Summarizing Data: Describing Data - Graphs and Tables; Describing Data - Summary Measures; Getting the Right Data. Part II Probability, Uncertainty and Decision Making: Probability and Probability Distributions; Normal, Binomial, Poisson and Exponential Distributions; Decision Making Under Uncertainty. Part III Statistical Inference: Sampling and Sampling Distributions; Confidence Interval Estimation; Hypothesis Testing. Part IV Regression, Forecasting and Time Series: Regression Analysis - Estimating Relationships; Regression Analysis - Statistical Inference; Time Series Analysis and Forecasting. Part V Other Statistical Tools: Analysis of Variance and Experimental Design; Data Mining Techniques: Discriminant Analysis, Logistic Regression and OLAP; Statistical Process Control. Appendix: Statistical Reporting.
Presenting core statistical methods in a modern, unified spreadsheet-oriented approach, this text focuses on applications to business. It illustrates a variety of statistical methods to help students analyse data sets and uncover important information to aid decision-making.