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_7

7. K-Nearest Neighbors

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

People tend to make decisions or take actions based on the advice from people around them. It happens from time to time in our lives that we take suggestions from people around us, especially from those who are very close to us. The data mining method, k-nearest neighbor (K-NN) method, is a reflection of such a real-life moment. Here, k indicates that the decision is based on k neighbors. For example, among 10,000 ...