Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry
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 draw conclusions about the groupings.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 75% (12 reviews)
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 the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these 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...
-
When considering banning a toxic chemical, why should replacement substances or processes be part of the decision?
-
Distinguish between a primary and a secondary endosymbiosis. Which groups of protists are derived from which form of endosymbiosis?
-
Telephone calls come into an airline reservations office randomly at the mean rate of 15 calls per hour. The time between calls follows an exponential distribution with a mean of 4 minutes. When the...
-
Indicate the effects of the transactions listed in the following table on total current assets, current ratio, and net income. Use (+) to indicate an increase, () to indicate a decrease, and (0) to...
-
The Durn Company began operations at the beginning of 2007. At the end of 2007 the company reported taxable income of $9,800 and pretax financial income of $11,200, because of a single temporary...
-
Item 3 Item 3 Crocetti Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per...
-
Suppose the daily demand curve for flounder at Cape May is given by QD = 1,600 - 600P, where QD is demand in pounds per day and P is price per pound. a. If fishing boats land 1,000 pounds one day,...
-
Use XL Miner to generate a simple random sample of 10 records from the Excel file Banking Data.
-
Cluster the records in the Excel file Ten Year Survey. Create up to five clusters and analyze the results to draw conclusions about the survey.
-
Aykroyd Inc. has sponsored a non-contributory, defined benefit pension plan for its employees since 1989. Prior to 2019, cumulative net pension expense recognized equaled cumulative contributions to...
-
What are the different types of drones?
-
What are the applications of drones?
-
What are the various protocols in telecom domain?
-
What are the various types of routing protocols?
-
For all the benefits they bring to business, social media and other communication technologies have created a major new challenge: responding to online rumors and attacks on a company's reputation....
-
Pithead Products Ltd plans to sell its single product for 35 a unit. Credit plans for the next six months are as follows: 70 per cent of sales are made on credit and 30 per cent for cash. Of the...
-
(a) Water flows through the nozzle of a garden hose. Find an expression for m in terms of line pressure P 1 , ambient pressure P 2 , inside hose diameter D 1 , and nozzle outlet diameter D 2 . Assume...
-
What are two limitations of the usefulness of financial statements?
-
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...
-
1. (A nice inharitage) Suppose $1 were invested in 1776 at 3.3% interest compounded yearly a) Approximatelly how much would that investment be worth today: $1,000, $10,000, $100,000, or $1,000,000?...
-
Why Should not the government subsidize home buyers who make less than $120K per year. please explain this statement
-
Entries for equity investments: 20%50% ownership On January 6, 20Y8, Bulldog Co. purchased 25% of the outstanding common stock of $159,000. Gator Co. paid total dividends of $20,700 to all...
Study smarter with the SolutionInn App