Apply single linkage cluster analysis to the first five records in the Excel file Sales Data, using the variables Percent Gross Profit, Industry Code, and Competitive Rating, and draw a dendogram illustrating the clustering process. O O CON | 0 - 0 - 0 ) n = h l 5 Nh C N O Customer Percent Gross Pro Gross Sales 51.0% $170.00 2 32.0% $181.00 3 20.0% $203.00 4 22.0% $249.00 5 21.0% $476.00 6 21.0% $476.00 22.0% $635.00 8 34.0% $856.00 9 26.0% $1,062.00 10 16.6% $1,110.00 11 20.0% $1,153.00 12 36.0% $1,392.00 13 18.0% $1,743.00 14 20.0% $2,307.00 15 5.0% $2,534.00 16 29.0% $2.683.00 17 10.0% $2,780.00 18 37.0% $3,272.00 19 60.0% $3,864.00 20 24.0% $3,988.00 21 9.0% $4,072.00 22 50.0% $4,190.00 23 17.0% $4,219.00 24 32.0% $4,711.00 25 15.0% $4,824.00 26 10.0% $4,878.00 27 13.0% $5,157.00 28 22.0% $5,552.00 29 17.0% $5,876.00 30 19.0% $5,888.00 31 6.0% $7,632.00 32 23.0% $8,058.00 33 23.0% $12,056.00 34 14.0% $12,981.00 35 22.0% $13,406.00 36 14.0% $15,882.00 37 28.0% $16,343.00 38 27.0% $19,985.00 39 3.0% $20,160.00 40 46.0% $26,616.00 41 26.0% $28,018.00 42 11.0% $28,950.00 43 18.0% $29,646.00 44 37.0% $31,019.00 45 20.0% $31,305.00 46 21.0% $34,769.00 47 10.0% $34,8 17.00 48 14.0% $38,609.00 9.0% $38,923.00 50 16.0% $40,536.00 51 22.0% $54,851.00 52 21.0% $54,861.00 53 17.0% $58,063.00 54 11.0% $62,862.00 55 7.0% $78,574.00 56 14.0% $92,776.00 57 15.0% $112,837.00 58 13.0% $115,999.00 59 21.0% $120,854.00 60 14.0% $179, 101.00 Gross Profit Industry Cod Competitive Rating $86.70 1 2 $57.92 3 $40.60 22 2 $54.78 5 1 $99.96 5 1 $99.96 5 4 $139.70 2 3 $291.04 3 3 $276.12 4 2 $183.71 7 $230.60 7 3 $501.12 2 $313.74 4 2 $461,40 7 $126.70 14 5 $778.07 2 $278.00 3 $1,210.64 5 3 $2,318.40 $957.12 6 $366.48 7 $2,095.00 5 $717.23 3 $1,507.52 7 1 $723.60 3 $487.80 7 4 S670.41 7 2. $1,221.44 2. $998.92 1 $1,118.72 6 $457.92 5 $1,853,34 3 $2,772.88 2 $1,817.34 2 4 $2,949.32 2 3 $2,223.48 7 3 $4,576.04 3 $5,395.95 5 3 $604.80 5 5 $12,243.36 5 $7,284.68 5 $3,184.50 4 $5,336.28 4 3 $11,477.03 6 1 $6,261.00 2 3 $7,301.49 7 1 $3,48 1.70 4 3 $5,405.26 1 3 $3,503.07 2 5 $6,485.76 4 3 $12,067.22 6 2 $11,520.81 17 2 $9,870.71 5 4 $6,91482 4 5 $5,500.18 $12,988.64 4 3 $16,925.55 1 $15,079.87 4 $25,379.34 5 $25,074.14 16 NN 49 A Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to