MS Excel can be used for performing statistical analysis ranging from descriptive statistics to statistical modeling. This post describes a set of tutorials which are useful for learning Statistics using MS Excel.

In today's time, Python and R are the tools which data analysts use for building models but there are many times MS Excel would be the easiest and quickest way for statistical analysis. For example, you want to build a regression model and want to see the impact of predictors to the target variable. To do it in R and Python, you need to import data and then code for model development. In Excel it would be a click of button as raw data is generally available in CSV and Excel format.

Statistical Analysis Using Excel

- Install Analysis ToolPak Add-In
- Descriptive Statistics with Excel
- Frequency Distribution with Excel
- Normal Distribution with Excel
- Sample Size Calculator with Excel
- Correlation Matrix with Analysis ToolPak AddIn
- Calculating Correlation Matrix with Formula
- Calculating Partial Correlation Matrix with Excel VBA
- Calculating Partial Correlation Matrix (Formula)
- Check if a number is prime with Excel
- Generating prime numbers in an interval with Excel
- Counting prime numbers in an interval with Excel
- Calculating Intersection between curve and straight line with Excel
- Calculating Intersection of two linear straight lines with Excel
- Generating Unique Random Numbers in an interval with Excel

Predictive Modeling Using Excel

- Creating Logistic Regression with Excel
- Excel Add-In for Logistic Regression
- Creating ROC Curve in Excel
- Confusion Matrix with Excel
- Calculating Hosmer Lemeshow Test with Excel

Templates For Statistical Analysis

Share Share Tweet