◀ Previous

Slide 13.9: A kNN example for interpolation and smoothing (cont.) Slide 13.11: Strengths and weaknesses of kNN Home         Print version

▶ Next

How Do We Use the Spreadsheet for kNN?

---

This tutorial is accompanied with three spreadsheet files as follows:

• kNN Spreadsheet for classification
• kNN spreadsheet for interpolation
• kNN spreadsheet for extrapolation

The spreadsheet does not contain any macro. kNN algorithm uses only simple MS Excel functions:

• SMALL, which returns the k^th smallest value of the array input
• COUNTIF, which counts number of cells that pass some simple criteria
• RANDBETWEEN, which generates random integer between two values

You can change any value of K (number of neighbors) or the data to see the effect of prediction. Alternatively, you can just press F9 and it will automatically generate new random data.

◀ Previous

Slide 13.9: A kNN example for interpolation and smoothing (cont.) Slide 13.11: Strengths and weaknesses of kNN Home         Print version

▶ Next

Q:- Why are computers so smart?           A:- Because they listen to their motherboards.