Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Regulation In Europe

Authors: McLeay Stuart

1st Edition

0333694600, 9780333694602

More Books

Students also viewed these Accounting questions

Question

What are the assumptions required of a multiple regression model?

Answered: 1 week ago