An excel companion for business statistics / David L. Eldredge

Table of Content
Chapter 1. Introduction to statistics with excel
1.1. Using windows
1.2. Using excel
1.3. Using help
etc...

2. Descriptive graphs and graphs
2.1. The histogram analysis tool
2.2. The chart wizard
etc...

3. Descriptive numerical measures
3.1. The descriptive statistics analysis tool
3.2 The rank and percentile analysis tool
3.3 Combinations of statistical functions
etc...
4. Probability and sampling distributions
4.1. Discrete probability distributions
4.2. Continuous probability functions
4.3. Sampling distributions
etc...

5. Statistical Inference for population means
5.1. One population mean
5.2. The t-Test: Two-sample assuming unequal variance analysis tool
5.3 Two additional analysis tools for two independent samples
etc...

6. Statistical Inference for population proportions
6.1. One population proportion
6.2. Two population proportions
etc..

7. Statistical Inference for population variances
7.1. One population variance
7.2. The F-Test: Two-sample variances analysis
etc...

8. Analysis of variance
8.1.The Anova: Single: Single factor analysis tool
8.2. The Anova: Two factor without application analysis tool
8.3 The Anova: Two factor with application analysis tool
etc..

Chapter . Applications of the Chi-Square statistic
9.1. Goodness-of-Fit Test: Multinomial distributional
9.2. Test of independence contingency tables
9.3. The pivot table wizard
etc...

10. Regression analysis
10.1. Simple linear regression with trend line
10.2. Simple linear regression with the regression analysis tool
10.3. Multiple regression withy the regression analysis tool
etc...

11. Time series forecasting
11.1 Identification of appropriate forecasting methods
11.2 The moving Average analysis tool
11.3. The exponential smoothing analysis tool
etc...

12. Statistical quality control charts
12.1. X Chart for controlling process average
12.2. R Chart for controlling process variability
12.3. P Chart for controlling proportion of defective items
etc...
Appendices

Includes index