This question is related to data mining topics K Nearest Neighbor (KNN)

Please use Microsoft Excel to solve this problem. Thank You

Consider the training examples shown in the following table for a binary classification. The table shows a training set for a problem of predicting whether a loan applicant will repay his/her loan obligation or defaulting on his/her loan. Defaulted Borrower Marital Status Single Married Single Married Divorced Married Divorced Single Married Single Annual Income 125K 100K 70K 120K 95K 60K 220K 85K 75K 90K Tid Home Owner Yes 4 Yes Yes Yes Yes Yes 10 Using the kNN approach that we discussed in the class, predict the class label for this test example, X = (Home Owner = No, Marital Status = Married, Income = $120K), Assume that k =3 and distance is L2 norm