Question: Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry Code, and Competitive Rating. Create four clusters and

Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry Code, and Competitive Rating. Create four clusters and draw conclusions about the groupings.

Step by Step Solution

★★★★★

3.48 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Sales Data Customer Percent Gross Profit Gross Sales Gross Profit Industry Code Competitive Rating Cluster ID 1 510 17000 8670 1 2 1 2 320 18100 5792 3 4 2 3 200 20300 4060 2 2 2 4 220 24900 5478 5 1 ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

607-B-B-C-B-M (868).xlsx

300 KBs Excel File

Students Have Also Explored These Related Business Communication Questions!

Apply cluster analysis to the numerical data in the Excel file Credit Approval Decisions. Analyze the clusters and determine if cluster analysis would be a useful classification method for approving...

Construct frequency distributions and histograms using the Excel Histogram tool for the Gross Sales and Gross Profit data in the Excel file Sales Data. First let Excel automatically determine the...

The Excel file Sales Data provides data on a sample of customers. An industry trade publication stated that the average profit per customer for this industry was at least $ 4,500. Using a test of...

6. Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry Code, and Competitive Rating. Create four clusters and draw conclusions about the...

NEED HELP WITH #7 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,...

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...

Page of 2 ZOOM LECTURE 04: MODELING AND DATA ANALYSIS EXERCISE 4-1 General Manufacturing Corporation (GMC): Segmentation & Profiling the GMC Customers: GMC is a general manufacturer of various...

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...

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...

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. 1 1 1 1 1 Sales Data 2...

Mr. Cabinet, your boss at FinCorp Inc., prefers to have his information presented visually. At his request, graph the payoffs (intrinsic values) and profits at expiration for the following option...

iCompany manufactures two models of tablets. The 8-inch Model is a smaller unit with less features. The larger 12-inch Model provides not only a larger screen but also increased memory to hold more...

When a share of a company s stock is selling for $ 5 5 . 0 0 , a put option on the stock with a strike price of $ 5 6 . 0 0 is said to be: Select one: a . Out of the money. b . Carried at basis. c ....

How do cultural, social, and personal factors influence consumer buying behavior? (Page 69)

A local pharmacy orders 15 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The pharmacy purchases the magazines for $2.25 and sells them for $5.00. Any...

Jennifer Bellin has been put in charge planning her companys annual leadership conference. The dates of the conference have been determined by her companys executive team. The table below contains...

A manufacturer is preparing to set the price on a new action game. Demand is thought to depend on the price and is represented by the model: D = 2,000 3.5P The accounting department estimates that...

The file called Bank Loans will be used to review multiple Excel functions that were discussed in the prior tutorial. Rename the file called Bank Loans (your name also goes here) so that the new name...

Lavage Rapide owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the companys costs: Fixed Cost per Month Cost per Car Washed...

Requirement: Without making journal entries, determine the total paid-in capital created by these transactions. During the first year of operations, Getaway earned net income of $94,000 and declared...