Using all the data on the Clean Data worksheet tab rescaled with standardization, apply the KNN algorithm with k $=10$ to this problem to classify each of the following applicants as either likely to default $($defined as more than a $10$ percent chance of default$)$ or not likely to default $($defined as a $10$ percent chance of default or less$).$ Also indicate the estimated probability of default for each.

The data contains the following columns:

Loan Annual Income Credit Score Late Payments Default Default $0/1$

$1$ $$82,0007412$ No $0$

$2$ $$28,0003420$ No $0$

$.......$

$.....$

$....$

a$)$ The loan applicant has an annual income of $$54,000$ and a credit rating of $750.$

b$)$ The loan applicant has an annual income of $$112,000$ and a credit rating of $630$

Please solve using Excel Analytics Solver