Chapter 10 Data Mining
Instructions: Please submit your work in one single Excel file with one tab/worksheet for each problem.
1. (25 points) Apply single linkage cluster analysis to Berkeley, Cal Tech, UCLA, and UNC in the Excel file Colleges and Universities Cluster Analysis Worksheet and draw a dendrogram illustrating the clustering process.
2. In the Excel file Credit Risk Data, classify the following record:
a. (25 points) Using k-NN algorithm for k=1 to 5.
b. (25 points) Using discriminant analysis.
3. (25 points) The Excel file Automobile Options provides data on options ordered together for a particular model of automobile. Consider the following rules:
a. Rule 1: If Fastest Engine, then Traction Control.
b. Rule 2: If Faster Engine and 16-inch Wheels, then 3 Year Warranty.
Compute the support, confidence, and lift for each of these rules.