Home » Statistical Analysis Using Excel

Statistical Analysis Using Excel

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
  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
  11. Check if a number is prime with Excel
  12. Generating prime numbers in an interval with Excel
  13. Counting prime numbers in an interval with Excel
  14. Calculating Intersection between curve and straight line with Excel
  15. Calculating Intersection of two linear straight lines with Excel
  16. Generating Unique Random Numbers in an interval with Excel
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
ListenData Logo
Spread the Word!
Share
Subscribe to: Posts (Atom)
Looks like you are using an ad blocker!

To continue reading you need to turnoff adblocker and refresh the page. We rely on advertising to help fund our site. Please whitelist us if you enjoy our content.