Statistical Analysis Using Excel

The following links describe a set of tutorials for statistics with Excel which are useful for learning Statistics using MS Excel.

Statistical Analysis Using Excel

1. Install Analysis ToolPak Add-In
2. Descriptive Statistics with Excel
3. Frequency Distribution with Excel
4. Normal Distribution with Excel
5. Sample Size Calculator with Excel
6. Correlation Matrix with Analysis ToolPak AddIn
7. Calculating Correlation Matrix with Formula
8. Calculating Partial Correlation Matrix with Excel VBA
9. Calculating Partial Correlation Matrix (Formula)
10. Calculating Hosmer Lemeshow Test with Excel Formula

Templates For Statistical Analysis

1. Calculating Dependent Sample T Test : Excel Template
2. Calculating Independent Two Sample T Test : Excel Template
3. Pearson's Correlation Coefficient Formula Explained - Excel Template
4. Calculating Simple Linear Regression - Excel Template
5. Gain and Lift Charts - Excel Template

Subscribe to get Email Updates!