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: 81% (11 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
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
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?
-
In triangle ABC, angle B is twice as large as angle A. Angle C measures 20o more than angle A. Find the measures of the angles.
-
Evaluate the following in terms of elliptic integrals, and compute the values to four decimal places. a. \(\int_{0}^{\pi / 4} \frac{d \theta}{\sqrt{1-\frac{1}{2} \sin ^{2} \theta}}\). b....
-
On January 1, Zabel Corporation purchased a 25% equity in Helbert Corporation for $180,000. At December 31, Helbert declared and paid a $60,000 cash dividend and reported net income of $200,000....
-
Colby Limited is a manufacturing company whose total factory overhead costs fluctuate somewhat from year to year, according to the number of machine-hours worked in its production facility. These...
-
Suppose Y1, Y2, . . . , Yn is a random sample from the uniform pdf over [0, 1]. The geometric mean of the numbers is the random variable nY1Y2 Yn. Compare the expected value of the geometric...
-
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.
-
For the following exercises, parameterize (write parametric equations for) each Cartesian equation by using x(t) = a cos t and y(t) = b sin t. Identify the curve. Parameterize the line from (1,0) to...
-
What is a political theory and what are its uses? (b) Discuss in detail the political theories of Thomas Hobbes and John Locke? What are the similarities and differences in their theories of the...
-
How has CRISPR-Cas9 technology revolutionized functional genomics, and what are some notable applications in biomedical research and therapeutics ?
-
Why should we treat political theory as political philosophy? Why is political theory the same as political philosophy? What makes it different from political philosophy? What makes it trustworthy...
-
An 10-kg block starts sliding with a velocity of 10 m/s down a inclined plane with an angle of inclination of 30 degrees, as shown in the figure below. The highest point of the incline is at a...
-
Ms. Mattingly, a well-to-do farmer, has a legal right to apply pesticides to her fruit trees. One year, she decided to hire a crop-dusting airplane to spread a pesticide on her orchard. An unexpected...
-
Kimberly Austin deposits $5000 in an IRA at 6% interest compounded continuously for her retirement in 10 years. She intends to make continuous deposits at the rate of $3000 a year until she retires....
-
What are the typical record-at-a-time operations for accessing a file? Which of these depend on the current file record?
-
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...
-
What tool(s) are used the check the suction line superheat? High pressure gauge and a thermocouple High pressure gauge only Compound pressure gauge and an amp probe Compound pressure gauge and a...
-
Problem 4 - Forces in Deep Drawing (Found in Chapter 19) For the drawing operation of Problem 3 (Cup Drawing), the tensile strength of the sheet metal (low-carbon steel) = 300 MPa and yield strength...
-
The QRS Inc. is engaged in games and amusement business. It has the following data for the year: Collections: Cockpit P700,000 Professional boxing 950,000 Amateur boxing 72,000 Palozebo games 50,000...
Study smarter with the SolutionInn App