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