MS Excel can be used for performing statistical analysis ranging from descriptive statistics to statistical modeling. This post describe a set of tutorials which are useful for learning Statistics using MS Excel. In today's time R and Python 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 basic linear (or non-linear) regression model and want to see the coefficients or magnitude of impact of independent variable 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. If you are wondering whether to learn MS Excel given you know R and Python, I would say go for it as it would improve your daily productivity a big time.
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)
- Calculating Hosmer Lemeshow Test with Excel 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
Templates For Statistical Analysis