Statistics For Managers Using Microsoft Excel

0.0

It was the first book to thoroughly integrate the use of Microsoft Excel as a statistical tool for analysis and interpretation based on the needs of the workplace. The Fifth Edition has Enhanced Excel coverage – In-chapter worksheet illustrations include cell formulas. Also all Excel instructions have been revised and gathered into end-of-chapter Excel Companions for easier reference. Ready for Excel 2007 – Step-by-step instructions feature command sequences that are compatible with all Excel versions. For tasks that are fundamentally different in Excel 2007, the Excel Companions include paired sets of Excel 97-2003 and Excel 2007 instructions. From the Authors’ Desktop – This feature enhances chapter topics and raises important issues. Examples and Exercises – Several applied examples and exercises with data from The Wall Street Journal, USA Today, Consumer Reports, and other sources have been added. Many problems have been revised to help students better analyze and apply the relevant statistical concepts. Table of Contents Preface 1. Introduction and Data Collection 2. Presenting Data in Table and Charts 3. Numerical Descriptive Measures 4. Basic Probability 5. Some Important Discrete Probability Distributions 6. The Normal Distribution and Other Continuous Distributions 7. Sampling and Sampling Distributions 8. Confidence Interval Estimation 9. Fundamentals of Hypothesis Testing: One-Sample Tests 10. Two-Sample Tests 11. Analysis of Variance 12. Chi-Square Tests and Nonparametric Tests 13. Simple Linear Regression 14. Introduction to Multiple Regression 15. Multiple Regression Model Building 16. Time-Series Forecasting and Index Numbers 17. Decision Making 18. Statistical Applications in Quality Management Appendices A-F Self-Test Solutions and Answers to Selected Even-Numbered Problems Index