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: 90% (10 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?
-
Paris Products Ltd. issued $3 million of 5%, 5-year bonds on January 1, 2024. The bonds were dated January 1 and pay interest annually. There is no collateral secured against the bonds and Paris...
-
Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the texts Web site (or create the set of relational tables in Table 4-5 in any relational DBMS product to which you have...
-
The unadjusted trial balance of Arlington Air Purification System at December 31, 2014, and the data needed for the adjustments follow. Adjustment data at December 31 follow: a. On December 15,...
-
Identify a person in your life whom you would consider a mentor. What have you learned from this mentor with regard to leadership skills. Use all of the information gained thus far to justify your...
-
The income statement of Fezzik's Shoe Repair is as follows: On April 1, the Owner's Capital account had a balance of $12,900. During April, Fezzik withdrew $3,000 cash for personal use. Prepare...
-
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.
-
In radiofrequency (RF) ablation, a small needle is inserted into a cancerous tumor. When radiofrequency oscillating currents are sent into the needle, ions in the neighboring tissue respond by...
-
An auditor issued an audit report that was dual dated for a subsequent event occurring after the completion of fieldwork but before issuance of the auditor's report. The auditor's responsibility for...
-
When unaudited financial statements of a nonpublic entity are presented in comparative form with audited financial statements in the subsequent year, the unaudited financial statements should be...
-
For each of the following systems (a) Inertial measurement unit (b) Nuclear monitoring system (c) Airline reservations system (d) Pasta sauce bottling system what design approach would you use?
-
Name four ratio tests that may be applied in the audit of revenue and expense.
-
Should a sport management course focus on teaching students about sports or about management? Explain your answer.
-
In their article Reversible, metal-free hydrogen activation (Science 2006, 314, 1124), Douglas Stephan and co-workers describe how H 2 is heterolytically cleaved at a molecule containing only main...
-
What is the order p of a B + -tree? Describe the structure of both internal and leaf nodes of a B + -tree.
-
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...
-
Salma & Co. decided to invest into a new product line. The firm requires an investment of $36,000 and borrows $12,000 at 9%. If the return on equity is 20%, calculate the firm's pretax weighted...
-
Error Degrees of Freedom are calculated as n - p - 1 for multiple regression models. The p represents the number of coefficients (not including the intercept) in the estimated model. Report the Error...
-
Assume that 63 fatal shark attacks were recorded in a large body of water over a 9 year span, with 1 being reported in Region A, 2 in Region B, 4 in Region C, 16 in Region D, 14 in Region E, 7 in...
Study smarter with the SolutionInn App