Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods

© Hong Zhou 2020

H. ZhouLearn Data Mining Through Excelhttps://doi.org/10.1007/978-1-4842-5982-5_2

2. Linear Regression

Hong Zhou¹ 

(1)

University of Saint Joseph, West Hartford, CT, USA

 

Please download the sample Excel files from https://github.com/hhohho/Learn-Data-Mining-through-Excel for this chapter’s exercises.

General Understanding

Linear regression is a predictive model in which training data is employed to construct a linear model to make predictions on the scoring data. When we talk about a linear model, we mean that the relationship between the target (dependent variable) and the attribute(s) (independent variables) is linear. It is a convention to use the terminologies “independent variable” and “dependent variable” in regression analysis. ...