Please use excel to answer and i'll give you a good rating

10.3.7 Use the given data to classify the record below using the k-NN algorithm for k= 1 to 5. Loan Purpose Furniture Checking 101 Savings 3871 Months Months Customer Employed 10 16 Click the icon to view the table of classified records. Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. Distance Classification (Round to four decimal places as needed.) Mont Customer Months Employed Credit Risk la 739 12301 47541 9631 8891 123481 3871 01 3231 1381 14643 8001 6261 9041 32811 1781 717 109801 270 4571 6431 9791 6921 4701 Loan Purpos. Small Appliance Furniture Education Business Education Furniture Furniture Used Car Small Applianci Small Applianc Small Applianc Furniture Repairs New Car Education Used Car Small Applianc Small Applianc Used Car New Car Small Appliance Furniture Furniture New Car New Car Small Applianc Used Car Furniture Business New Car Business Used Car New Car New Car Education Small Appliand New Car Furniture New Car Small Appliance New Car Used Car Used Car Small Appliancl Small Applianc Furniture Used Car New Car Furniture Used Car 1921 12 LOW O High 45 Low O High 2 High 5 High 23 High 46 LOW 42 High 1191 LOW 115 Low 69 High OLOW 6 Low 20 High 89 High 10 High 17 High 25 Low 63 Low 6 Low 48 High 14 Low O LOW 2 Low 93 Low ZLOW 42 High 57 Low 24 High 14 High 111 LOW 37 High 17 Low 61 High 13 LOW 103 High 20 Low 54 High 621 Low 28 High 81 High 119 High 16 LOW 42 High 5 High 411 Low 27 High 17 Low 4 Low 6631 0 187161 147171 8351 01 91251 5981 13361 198121 0 891 11072 977 954 256 2961 5971 197661 58571 21411 503 6931 9731 5960 01 9041 1291 7981 2041 2472 10417 198111 33691 10.3.7 Use the given data to classify the record below using the k-NN algorithm for k= 1 to 5. Loan Purpose Furniture Checking 101 Savings 3871 Months Months Customer Employed 10 16 Click the icon to view the table of classified records. Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. Distance Classification (Round to four decimal places as needed.) Mont Customer Months Employed Credit Risk la 739 12301 47541 9631 8891 123481 3871 01 3231 1381 14643 8001 6261 9041 32811 1781 717 109801 270 4571 6431 9791 6921 4701 Loan Purpos. Small Appliance Furniture Education Business Education Furniture Furniture Used Car Small Applianci Small Applianc Small Applianc Furniture Repairs New Car Education Used Car Small Applianc Small Applianc Used Car New Car Small Appliance Furniture Furniture New Car New Car Small Applianc Used Car Furniture Business New Car Business Used Car New Car New Car Education Small Appliand New Car Furniture New Car Small Appliance New Car Used Car Used Car Small Appliancl Small Applianc Furniture Used Car New Car Furniture Used Car 1921 12 LOW O High 45 Low O High 2 High 5 High 23 High 46 LOW 42 High 1191 LOW 115 Low 69 High OLOW 6 Low 20 High 89 High 10 High 17 High 25 Low 63 Low 6 Low 48 High 14 Low O LOW 2 Low 93 Low ZLOW 42 High 57 Low 24 High 14 High 111 LOW 37 High 17 Low 61 High 13 LOW 103 High 20 Low 54 High 621 Low 28 High 81 High 119 High 16 LOW 42 High 5 High 411 Low 27 High 17 Low 4 Low 6631 0 187161 147171 8351 01 91251 5981 13361 198121 0 891 11072 977 954 256 2961 5971 197661 58571 21411 503 6931 9731 5960 01 9041 1291 7981 2041 2472 10417 198111 33691