How can I use the K nearest neighbor formula in excel?
If the distances are in cells say b2: b41, then you can furnish the formula in cel C2 (say)
=small(b2:b41, 3) to get 3rd smallest element
Content will be erased after question is completed.
Enter the email address associated with your account, and we will email you a link to reset your password.
Forgot your password?