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

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

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

2. Linear Regression

Hong Zhou¹  

(1)

Department of Mathematics and Computer Science, University of Saint Joseph, West Hartford, CT, USA

 

Please download the sample Excel files from https://github.com/hhohho/Learn-Data-Mining-through-Excel-2 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) ...