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. 4 ch 9 1 Sales Data 2 3 Customer Percent Gross Pro Gross Sales Gross Profit Industry Cod Competitive Rating* 1 51.0% $170.00 $86.70 2 5 2 320% $181.00 $57.92 4 6 3 20.0% $203.00 $40.60 2 7 4 22.0% $249.00 $54.78 1 8 5 21.0% $476.00 $99.96 5 1 6 21.0% $476.00 $99.96 5 4 7 22.0% $635.00 $139.70 2 3 11 8 34.0% $856.00 $291.04 3 3 12 9 26.0% $1,062.00 $276.12 44 2 13 10 16.6% $1,110.00 $183.71 7 3 14 11 20.0% $1,153.00 $230.60 7 3 15 12 36.0% $1 392.00 $501.12 4 2 16 13 18.0% $1,743.00 $313.74 14 20.0% $2,307,00 $461.40 3 16 15 5.0% $2,534.00 $126.70 5 19 18 29.0% $2.683.00 $778.07 2 20 17 10.0% $2,780.00 $278.00 2 21 18 37.0% $3.272.00 $1.210.64 22 19 80.0% $3,864 00 $2,318.40 23 20 24.0% $3,988 00 S957 12 6 24 21 9.0% S407200 $368 48 7 Sun NL 10 w WUNNON FON B Number Styles Com 4 G H 25 A 22 23 24 26 27 28 29 30 31 32 33 34 25 36 37 SE 2 31 32 33 34 35 36 37 38 C $4.190.00 $4,219 00 $4,711.00 $4824.00 $4,878.00 $5,15700 $5,552 00 $5,876.00 $5,888.00 $7,632.00 $8,058.00 $12,056.00 $12,981.00 $13,406.00 $15,882.00 $16,343.00 $19,985.00 $20,160.00 $26,618 00 $28,018.00 $28,950,00 $29.646.00 $31,01900 $31,305.00 $34 769.00 50.0% 17.0% 32.0% 150% 10.0% 13.0% 22.0% 170% 19.0% 6.0% 23.0% 23.0% 14.0% 220% 140% 28.0% 27.0% 3.0% 46 0% 26.0% 11.0% 18.0% 37 0% 20.0% 21.0% + Alignment D $2,095.00 $717 23 $1,507.52 $723.60 $487 80 $670.41 $1,221.44 $998 92 $1,118.72 $457.92 $1,853 34 $2,772 88 $1817 34 $2,949.32 $2,223.48 $4,576.04 $5,395.95 $604 80 $12,243 36 $7 284 68 $3,184,50 $5,336 28 S11,47703 56 26100 $7 301 49 3 4 1 3 4 2 3 3 4 4 3 2 4 3 3 3 3 6 E 5 3 7 6 7 7 2 1 6 5 3 7 2 2 7 3 5 5 5 5 4 4 39 40 41 42 43 44 40 41 42 43 44 45 46 NOOR 46 47 4a 49 2 2 G H 4 lipboard Font Alignment Number Styles B D 46 21.0% $34,769.00 $7,301.49 7 1 47 10.0% $34,817.00 $3,481.70 3 48 14.0% $38,609.00 $5,405 26 1 3 49 9.0% $38,923.00 $3,503.07 2 5 3 50 16.0% $40,536.00 $6,485.76 4 3 51 22.0% $54,851.00 $12,067 22 6 2 5 52 21.0% $54,861.00 $11,520.81 7 2 6 53 17.0% $58,063.00 $9,870.71 4 7 54 11.0% $62,862.00 $6,914.82 4 5 58 55 7.0% $78,574.00 $5,500.18 3 5 59 56 14.0% $92,776.00 $12,962.64 3 57 15.0% $112,837.00 $16,925.55 4 61 58 13.0% $115,999.00 $15,079.87 4 5 62 59 21.0% $120,854.00 $25,379,34 5 4 63 60 14.0% $179,101,00 $25,074 14 6 3 54 65 "Rates the amount of competition for sales of the products sold to these customers 1 = very little competition to 5 = very competitive 66 67 68 NAWAGAN-Am