How do we use the spreadsheet for KNN?

By Kardi Teknomo, PhD.

<Previous | Next | Contents>

You can download the spreadsheet companion of this tutorial here.

KNN Spreadsheet for classification
KNN spreadsheet for interpolation
KNN spreadsheet for extrapolation

The spreadsheet does not contain any macro. KNN algorithm use only simple MS excel functions

SMALL – return the k-th smallest value of the array input

COUNTIF – count number of cells that pass some simple criteria

RANDBETWEEN – to generate 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 data.

Yellow cells are for input, other color are results or computation.

Give your feedback and rate this tutorial

<Previous | Next | Contents>

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi. K-Nearest Neighbors Tutorial. http:\\people.revoledu.com\kardi\ tutorial\KNN\