Question: Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20

Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees

Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20 corporations. (c) Perform a k-Means cluster analysis with k = 3 (hint: use Euclidean distance to calculate the distance between data points (30 marks) 1 2 3 4 5 5 7 3 9 1 2 4 5 5 7 3 9 D 1 2 B 4 D excel 1 CUSTER Sales Corporations 1 Company 1 2 Company 2 3 Company 3 4 Company 4 5 Company 5 6 Company 6 7 Company 7 8 Company 8 9 Company 9 10 Company 10 11 Company 11 12 Company 12 13 Company 13 14 Company 14 15 Company 15 16 Company 16 17 Company 17 18 Company 18 19 Company 19 20 Company 20 1200000 1300000 1250000 1125000 1005231 1143450 1500000 1624520 1524545 1600242 1652454 1453453 1424524 1343452 1742520 1564444 1436563 1556567 1564774 1854546 Number of employees 10000 11000 10500 9800 11432 12043 8020 7452 8344 9222 8213 7334 9454 8533 13223 10034 11344 12434 12331 10444 Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20 corporations. (c) Perform a k-Means cluster analysis with k = 3 (hint: use Euclidean distance to calculate the distance between data points (30 marks) 1 2 3 4 5 5 7 3 9 1 2 4 5 5 7 3 9 D 1 2 B 4 D excel 1 CUSTER Sales Corporations 1 Company 1 2 Company 2 3 Company 3 4 Company 4 5 Company 5 6 Company 6 7 Company 7 8 Company 8 9 Company 9 10 Company 10 11 Company 11 12 Company 12 13 Company 13 14 Company 14 15 Company 15 16 Company 16 17 Company 17 18 Company 18 19 Company 19 20 Company 20 1200000 1300000 1250000 1125000 1005231 1143450 1500000 1624520 1524545 1600242 1652454 1453453 1424524 1343452 1742520 1564444 1436563 1556567 1564774 1854546 Number of employees 10000 11000 10500 9800 11432 12043 8020 7452 8344 9222 8213 7334 9454 8533 13223 10034 11344 12434 12331 10444

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Plot the distribution of active pressure on the wall surface shown in the figure below. Calculate the total thrust on the wall (active + hydrostatic) and determine its point of application. Assume...

Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20 corporations. (a) Present a scatter plot of sales and number...

Question 2 Refer to the file 'Excel 1 cluster' file. The data in this file contains information about sales and number of employees for 20 corporations. (b) Select a random sample of 6 corporations...

Please kindly help me with the solution to this problem Thanks This case includes this document and an Excel document with the On the Go exhibits, which is included in this week's folder REQUIRED...

Please help me to answer the following file ............................................................................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1...

Please help me to answer the attached files ................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1 Submission deadline without penalties is 12 October 2017....

help me answer q1, 2, 3, 4, 5 the audit of Alpine Cupcakes, Inc. tasks Audit Case Assignments ng standards ble Introduction: Data Analytics Module e accounts In the Data Analytics Module, instead of...

S&P Enterprises has provided data from the fest three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments...

Part I you are asked to use the introductory sentence about the tax payer and complete paragraph items 14 and 16. You will also use item 18 for needed Social Security numbers. Do not do additional...

Hi I am in desperate need of help for my assignment. I have finished everything on the assignment except for Part B (1) on page 6. They are only looking for concise answers. The headings for the...

Assessment 1 - Context This assessment requires that you play the role of the project manager of a team assigned to develop a new product. You will be preparing for 2 separate meetings with the...

In return for ceding their lands to the United States, the tribes were given annuity (yearly) payments as compensation. With regard to land still under Native American control, the government sought...

SQL allows relations with duplicates. a. Define versions of the basic relational-algebra operations , , , , , , and that work on relationswith duplicates, in a way consistent with SQL. b. Check...

where does 3 6 6 0 0 0 0 come! 4 5 During its tirst year of operatiom, Anchor Holdings Corporation ertered inte the following unncactions nolating to sharehoidern' equity. The 6 articles of...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

3. Compare the news coverage for a political controversy on the Web sites of Fox News, CNN, MSNBC, NPR, and the wire services (AP and Reuters). What are the similarities? What are the differences?...

1. Define mass and mediated communication

2. Describe how the business of media and the principle of free speech shape the kinds of media content you encounter