In the Excel file Credit Risk Data, classify the following record:

Loan education Checking $600$ Savings $3500$ Months Customer $30$ Months Employed $45$ Gender M Marital Status Single Age $27$ Housing Rent Years $3$ Job skilled

Using k$-$NN algorithm for k$=1$ to $5.$

Using discriminant analysis.

slove in excel.