I am stuck on questions 8 & 9 on my homework. I just need to create k-NN algorithms in Excel, but am lost.

8. Use the k-NN algorithm to classify the new records in the Excel file Credit Approval Decisions Classification Data using only Credit Score and Years of Credit History for k=1 to 5 . 9. Use discriminant analysis to classify the new records in the Excel file Credit Approval Decisions Discriminant Analysis using only Credit Score and Years of Credit History as input variables. Credit Approval Decisions 8. Use the k-NN algorithm to classify the new records in the Excel file Credit Approval Decisions Classification Data using only Credit Score and Years of Credit History for k=1 to 5 . 9. Use discriminant analysis to classify the new records in the Excel file Credit Approval Decisions Discriminant Analysis using only Credit Score and Years of Credit History as input variables. Credit Approval Decisions