Linear Regression using Excel


Linear Regression is one of the very popular and important methods for Predictive Analytics. This process is simple and provides reasonable results.

In this series of lectures, I discuss conducting Linear Regression using Excel. We explore different tools provided by Excel. More importantly, I discuss the different output provided by the Excel tools and the theory behind them.

Linear Regression

Demonstration

Linear Regression using LINEST()

Linear Regression using Data Analysis Tool Kit

Multi-Variate Linear Regression

%d bloggers like this: