all needed information is supplied. Please show steps and processes in excel

Using the approach described In 10.6, classify the first record in the worksheet Records to Classify In the Excel file Credit Risk Data using the k-NN algorithm for k = 1 to 5. Use only Checking, Savings, Months Customer, and Months employed. (Question 10.6 ls below) 10.6 Apply single linkage cluster analysis to the first five records In the excel file Sales Data and draw a dendogram illustrating the process. Checking Savings Months Customer Months Employed $600 $3,500 30 45 $500 $800 15 20 $250 $250 15 48 $101 $3,871 10 16 $300 $400 10 5 $790 $3,000 8 24 $680 $600 50 18 $644 $2,000 20 60 $100 $8,000 12 $0 $900 25 4 90 Using the approach described In 10.6, classify the first record in the worksheet Records to Classify In the Excel file Credit Risk Data using the k-NN algorithm for k = 1 to 5. Use only Checking, Savings, Months Customer, and Months employed. (Question 10.6 ls below) 10.6 Apply single linkage cluster analysis to the first five records In the excel file Sales Data and draw a dendogram illustrating the process. Checking Savings Months Customer Months Employed $600 $3,500 30 45 $500 $800 15 20 $250 $250 15 48 $101 $3,871 10 16 $300 $400 10 5 $790 $3,000 8 24 $680 $600 50 18 $644 $2,000 20 60 $100 $8,000 12 $0 $900 25 4 90