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.

B NW 6 1 1 2 2 A E 1 Sales Data 2 3 Customer Percent Gross Pro Gross Sales Gross Profit Industry Cod Competitive Rating 4 1 51.0% $170.00 $86.70 1 2 5 2 32.0% $181.00 $57.92 3 4 3 20.0% $203.00 $40.60 2 2 7 4 22.0% $249.00 $54.78 5 8 5 21.0% $476.00 $99.96 5 9 6 21.0% $476.00 $99.96 5 4 10 7 22.0% $635.00 $139.70 3 11 8 34.0% $856.00 $291.04 3 3 9 26.0% $1,062.00 $276.12 4 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 4 2 17 14 20.0% $2,307.00 $461.40 7 3 18 15 5.0% $2,534.00 $126.70 4 5 19 16 29.0% $2,683.00 $778.07 7 2 20 17 10.0% $2,780.00 $278.00 2 3 21 18 37.0% $3,272.00 $1,210.64 5 3 22 19 60.0% $3,864.00 $2,318.40 7 23 20 24.0% $3,988.00 $957.12 6 3 24 21 9.0% $4,072.00 $366.48 7 3 25 22 50.0% $4,190.00 $2,095.00 5 3 26 23 17.0% $4,219.00 $717.23 3 4 27 24 32.0% $4,711.00 $1,507.52 7 28 25 15.0% $4,824.00 $723.60 6 3 29 26 10.0% $4,878.00 $487.80 7 4 30 27 13.0% $5,157.00 $670.41 7 2 31 28 22.0% $5,552.00 $1,221.44 2 3 32 29 17.0% $5,876.00 $998.92 3 33 30 19.0% $5,888.00 $1,118.72 6 4 34 31 6.0% $7,632.00 $457.92 5 4 35 32 23.0% $8,058.00 $1,853.34 3 3 36 33 23.0% $12,056.00 $2,772.88 7 2 37 34 14.0% $12,981.00 $1,817.34 2 4 38 35 22.0% $13,406.00 $2,949.32 3 39 36 14.0% $15,882.00 $2,223.48 7 3 40 37 28.0% $16,343.00 $4,576.04 3 3 1 1 1 WYNN 41 47 1 45 1 A B E F G H 40 37 28.0% $16,343.00 $4,576.04 3 3 38 27.0% $19,985.00 $5,395.95 5 3 42 39 3.0% $20,160.00 $604.80 5 5 43 40 46.0% $26,616.00 $12,243.36 5 2 44 41 26.0% $28,018.00 $7,284.68 5 3 45 42 11.0% $28,950.00 $3,184.50 4 4 46 43 18.0% $29,646.00 $5,336.28 4 3 44 37.0% $31,019.00 $11,477.03 6 48 20.0% $31,305.00 $6,261.00 2 3 49 46 21.0% $34,769.00 $7,301.49 7 50 47 10.0% $34,817.00 $3,481.70 4 3 51 48 14.0% $38,609.00 $5,405.26 1 3 52 49 9.0% $38,923.00 $3,503.07 2 5 53 50 16.0% $40,536.00 $6,485.76 4 3 54 51 22.0% $54,851.00 $12,067.22 6 2 55 52 21.0% $54,861.00 $11,520.81 7 2 56 53 17.0% $58,063.00 $9,870.71 5 4 57 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,988.64 4 3 60 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 64 65 "Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to 5 = very competitive 1 B NW 6 1 1 2 2 A E 1 Sales Data 2 3 Customer Percent Gross Pro Gross Sales Gross Profit Industry Cod Competitive Rating 4 1 51.0% $170.00 $86.70 1 2 5 2 32.0% $181.00 $57.92 3 4 3 20.0% $203.00 $40.60 2 2 7 4 22.0% $249.00 $54.78 5 8 5 21.0% $476.00 $99.96 5 9 6 21.0% $476.00 $99.96 5 4 10 7 22.0% $635.00 $139.70 3 11 8 34.0% $856.00 $291.04 3 3 9 26.0% $1,062.00 $276.12 4 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 4 2 17 14 20.0% $2,307.00 $461.40 7 3 18 15 5.0% $2,534.00 $126.70 4 5 19 16 29.0% $2,683.00 $778.07 7 2 20 17 10.0% $2,780.00 $278.00 2 3 21 18 37.0% $3,272.00 $1,210.64 5 3 22 19 60.0% $3,864.00 $2,318.40 7 23 20 24.0% $3,988.00 $957.12 6 3 24 21 9.0% $4,072.00 $366.48 7 3 25 22 50.0% $4,190.00 $2,095.00 5 3 26 23 17.0% $4,219.00 $717.23 3 4 27 24 32.0% $4,711.00 $1,507.52 7 28 25 15.0% $4,824.00 $723.60 6 3 29 26 10.0% $4,878.00 $487.80 7 4 30 27 13.0% $5,157.00 $670.41 7 2 31 28 22.0% $5,552.00 $1,221.44 2 3 32 29 17.0% $5,876.00 $998.92 3 33 30 19.0% $5,888.00 $1,118.72 6 4 34 31 6.0% $7,632.00 $457.92 5 4 35 32 23.0% $8,058.00 $1,853.34 3 3 36 33 23.0% $12,056.00 $2,772.88 7 2 37 34 14.0% $12,981.00 $1,817.34 2 4 38 35 22.0% $13,406.00 $2,949.32 3 39 36 14.0% $15,882.00 $2,223.48 7 3 40 37 28.0% $16,343.00 $4,576.04 3 3 1 1 1 WYNN 41 47 1 45 1 A B E F G H 40 37 28.0% $16,343.00 $4,576.04 3 3 38 27.0% $19,985.00 $5,395.95 5 3 42 39 3.0% $20,160.00 $604.80 5 5 43 40 46.0% $26,616.00 $12,243.36 5 2 44 41 26.0% $28,018.00 $7,284.68 5 3 45 42 11.0% $28,950.00 $3,184.50 4 4 46 43 18.0% $29,646.00 $5,336.28 4 3 44 37.0% $31,019.00 $11,477.03 6 48 20.0% $31,305.00 $6,261.00 2 3 49 46 21.0% $34,769.00 $7,301.49 7 50 47 10.0% $34,817.00 $3,481.70 4 3 51 48 14.0% $38,609.00 $5,405.26 1 3 52 49 9.0% $38,923.00 $3,503.07 2 5 53 50 16.0% $40,536.00 $6,485.76 4 3 54 51 22.0% $54,851.00 $12,067.22 6 2 55 52 21.0% $54,861.00 $11,520.81 7 2 56 53 17.0% $58,063.00 $9,870.71 5 4 57 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,988.64 4 3 60 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 64 65 "Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to 5 = very competitive 1