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.
Spread the Word!
Share