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: 88% (9 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?
-
Rolen Riders issued preferred stock with a stated dividend of 6% of par. Preferred stock of this type currently yields 7%, and the par value is $25. Assume dividends are paid annually. a. What is the...
-
How do you classify the pumps?
-
Investment Turnover Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements...
-
Assume that Crane Manufacturing has $8,100 of under-applied Manufacturing Overhead at December 31, 2022 and has the following account balances at year end: Work in Process Inventory $15,360 Finished...
-
Toms, Inc., produces various Mexican food products and sells them to Western Foods, a chain of grocery stores located in Texas and New Mexico. Toms, Inc., makes two salsa products: Western Foods...
-
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.
-
Show that the inequality U EM c |P EM | is a general property of electric and magnetic fields. Under what conditions are the two quantities equal?
-
Some consumer advocates worry that the above forms of weaving brands and products in the content of entertainment amounts to covert advertising, a form of advertising that works under the guise of...
-
Extreme sports. YouTube. Pinterest. Veganism. Can you predict what will be hot in the near future? Identify a lifestyle trend that is just surfacing in your universe. Describe this trend in detail,...
-
Imagine that you are in the market for a new vehicle and income is not your primary issue (have enough money to purchase whatever you like), what type of vehicle would you consider purchasing? What...
-
Develop the appropriate primary research question to be associated with this design. Develop a hypothetical research scenario that would necessitate the use of a Regression-Discontinuity...
-
Research shows that taking photos of experiences with the intention to share them reduces ones enjoyment of the experience. This happens because the goal of sharing involves the possibility of...
-
A high level of LDL cholesterol (bad cholesterol) in the blood increases a persons risk of heart disease. The table shows how LDL levels affect risk.If x represents the LDL cholesterol number, write...
-
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...
-
A soft tennis ball is dropped onto a hard floor from a height of 1.55 m and rebounds to a height of 1.12m. (Assume that the positive direction is upward.) (a) Calculate its velocity (in m/s) just...
-
A 200 mm reinforced concrete wall carries a dead load of 140 kN/m including self-weight and a live load of 60 kN/m. It is to be carried by 500 mm thick footing with its bottom 1.5 m below NGL. Soil...
-
Using www.land.vic.gov.au look up your current place of abode to gather planning information that might be useful in assessing its future development potential. 2. Write one-page report in WORD...
Study smarter with the SolutionInn App