excel

Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Click the icon to view the table of classified records. Distance Complete the table below for the nearest neighbors and for the classification of the new record for each value of k k Classification 1 2 Y V Y Loan Purpose Business 3 4 5 (Round to four decimal places as needed.). Checking 500 Savings 800 Months Months Customer Employed 15 20 D rds. nd fo Loan Purpose Furniture Small Appliance Furniture Used Car Furniture New Car New Car Business New Car Used Car New Car New Car Small Appliance Large Appliance Small Appliance Small Appliance Business New Car New Car Furniture New Car Small Appliance Business Business Checking 638 6509 0 2484 Ooo 0 0 15328 0 500 9621 0 ooc 0 0 317 0 0 942 0 8176 0 2715 8948 Savings 347 493 485 0 746 1366 200 0 806 104 369 308 10853 409 4449 10980 265 500 3036 909 12230 18716 1435 110 Months Customer 13 37 37 49 13 19 22 25 19 37 10 25 25 49 25 13 13 28 25 25 7 19 49 31 Months Employed 14 9 23 46 16 17 9 9 3 25 16 41 81 15 87 17 10 7 36 3 5 93 14 90 Credit Risk High High High Low Low Low High Low High High Low High Low High High High Low High Low Low Low Low High High 0 fo Large Appliance Small Appliance Small Appliance Furniture Small Appliance Furniture Furniture Small Appliance Used Car Education Education Business New Car New Car New Car Used Car Small Appliance Business Small Appliance New Car Small Appliance Small Appliance Business Education Used Car New Car 0 0 156 0 946 0 0 0 219 977 197 0 0 0 0 0 231 929 0 0 16630 296 0000 0 1238 364 0 636 0 734 8944 867 841 463 0 859 857 207 648 904 702 124 519 412 0 818 4973 471 276 579 13 13 13 22 16 37 25 31 43 10 37 19 11 13 15 49 10 9 31 25 11 19 25 7 25 22 12 58 41 83 111 66 27 0 61 17 23 34 119 57 119 99 1 23 22 47 93 17 52 91 70 High Low High Low Low High Low Low Low High Low High Low High High High Low Low Low High Low Low Low High Low Low Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Click the icon to view the table of classified records. Distance Complete the table below for the nearest neighbors and for the classification of the new record for each value of k k Classification 1 2 Y V Y Loan Purpose Business 3 4 5 (Round to four decimal places as needed.). Checking 500 Savings 800 Months Months Customer Employed 15 20 D rds. nd fo Loan Purpose Furniture Small Appliance Furniture Used Car Furniture New Car New Car Business New Car Used Car New Car New Car Small Appliance Large Appliance Small Appliance Small Appliance Business New Car New Car Furniture New Car Small Appliance Business Business Checking 638 6509 0 2484 Ooo 0 0 15328 0 500 9621 0 ooc 0 0 317 0 0 942 0 8176 0 2715 8948 Savings 347 493 485 0 746 1366 200 0 806 104 369 308 10853 409 4449 10980 265 500 3036 909 12230 18716 1435 110 Months Customer 13 37 37 49 13 19 22 25 19 37 10 25 25 49 25 13 13 28 25 25 7 19 49 31 Months Employed 14 9 23 46 16 17 9 9 3 25 16 41 81 15 87 17 10 7 36 3 5 93 14 90 Credit Risk High High High Low Low Low High Low High High Low High Low High High High Low High Low Low Low Low High High 0 fo Large Appliance Small Appliance Small Appliance Furniture Small Appliance Furniture Furniture Small Appliance Used Car Education Education Business New Car New Car New Car Used Car Small Appliance Business Small Appliance New Car Small Appliance Small Appliance Business Education Used Car New Car 0 0 156 0 946 0 0 0 219 977 197 0 0 0 0 0 231 929 0 0 16630 296 0000 0 1238 364 0 636 0 734 8944 867 841 463 0 859 857 207 648 904 702 124 519 412 0 818 4973 471 276 579 13 13 13 22 16 37 25 31 43 10 37 19 11 13 15 49 10 9 31 25 11 19 25 7 25 22 12 58 41 83 111 66 27 0 61 17 23 34 119 57 119 99 1 23 22 47 93 17 52 91 70 High Low High Low Low High Low Low Low High Low High Low High High High Low Low Low High Low Low Low High Low Low