Question

Use the K-NN algorithm to classify the new data in the excel file Credit Approval Decisions Coded using only credit score and years of credit history as input variables.

We're only allowed to use excel or analytic solver to answer problems. I don't know what python is.

Homeowner	Credit Score	Years of Credit History	Revolving Balance ($)	Revolving Utilization (%)	Decision
Y	592	3	21000	15	Reject
N	653	8	4000	90	Reject
Y	576	1	8500	25	Reject
N	733	4	16300	70	Approve
N	726	13	2500	90	Approve
Y	675	14	16700	18	Approve

k	Distance	Classification
1
2
3
4
5

Answer 1

I have taken the sample test data as 500,2.

I computed euclidean distances for k=2 as given in the table. The table is Rank, Euclidean distance and label.

Finally i have computed the answer