In Problem 2, you found a normalized distance matrix between Berkeley, Cal Tech, UCLA, and UNC for the Excel file Colleges and Universities Cluster Analysis Worksheet. Apply single linkage clustering to these schools and draw a dendogram illustrating the clustering process.

Data from Problem 2.

For the Excel file Colleges and Universities Cluster Analysis Worksheet, compute the normalized Euclidean distances between Berkeley, Cal Tech, UCLA, and UNC, and illustrate the results in a distance matrix