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_4

4. Linear Discriminant Analysis

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 discriminant analysis (LDA) is similar to linear regression and K-means clustering, but different from both, too. K-means clustering is an unsupervised classification method, while LDA is supervised since its classification is trained on known data, however. The predictive results are quantitatively numerical in linear regression, while they are qualitatively categorical in LDA.

LDA tries to find the ...