Statistics for Managers Using Microsoft Excel

Preface 

1 Introduction and Data Collection 

2 Presenting Data in Tables 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.        Review of Arithmetic, Algebra, and Logarithms 

B.        Summation Notation 

C.        Statistical Symbols and Greek Alphabet 

D.        CD-ROM Contents 

E.         Tables 

F.         Configuring Microsoft Excel and Installing PHStat 

Self-Test Solutions and Answers to Selected Even-Numbered Problems 

Index 

CD-ROM Topics

4.5       Counting Rules 

5.6       Using the Poisson Distribution to Approximate the Binomial Distribution 

6.6       The Normal Approximation to the Binomial Distribution 

7.6       Sampling from Finite Populations 

8.7       Estimation and Sample Size Determination for Finite Populations 

9.7       The Power of a Test 

11.3     The Randomized Block Design 

12.7     Chi-Square Test for a Variance or Standard Deviation