Use the data below and find the clusters using single link technique. Use Euclidean distance and draw the dendrogram.

In order to get full credit, show your all work done step by step including the cell calculations using excel functions.

X Y

P$10\mathrm{.}350\mathrm{.}68$

P$20\mathrm{.}170\mathrm{.}43$

P$30\mathrm{.}330\mathrm{.}25$

P$40\mathrm{.}210\mathrm{.}18$

P$50\mathrm{.}080\mathrm{.}29$

P$60\mathrm{.}210\mathrm{.}04$