NEED HELP WITH #7

6. Apply single linkage cluster analysis to the first five records in the Excel file Sales Data, using the vari- ables Percent Gross Profit, Industry Code, and Com- petitive Rating, and draw a dendogram illustrating the clustering process. Classification 7. Using the approach described in Example 10.6, clas- sify 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. 6. Apply single linkage cluster analysis to the first five records in the Excel file Sales Data, using the vari- ables Percent Gross Profit, Industry Code, and Com- petitive Rating, and draw a dendogram illustrating the clustering process. Classification 7. Using the approach described in Example 10.6, clas- sify 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