Subset the data set to include only sales professionals in one of the two product groups Cluster the sales professionals based on numerical variables of your choice (e g , age, salary) Determine the appropriate number of clusters Describe each cluster and compare the average net promoter scores of the clusters Sales Rep Business Age Female Years College Personality Certficates Feedback Salary Sales Rep Sales Rep 1 Hardware 59 1 2 Yes Diplomat 1 2 01 70200 1 1 2 Hardware 52 0 10 Yes Diplomat 4 3 64 133000 2 2 3 Software 47 1 1 Yes Explorer 1 3 88 52600 3 3 4 Hardware 61 0 2 Yes Diplomat 3 2 70 96000 4 4 5 Software 39 0 1 No Diplomat 5 3 44 122000 5 5 6 Hardware 28 0 6 Yes Explorer 1 2 43 60000 6 6 7 Software 25 1 1 Yes Explorer 5 3 3 68000 7 7 8 Hardware 51 1 10 No Explorer 0 2 15 43800 8 8 9 Hardware 34 0 4 Yes Diplomat 2 2 91 92000 9 9 10 Hardware 38 1 1 Yes Explorer 5 1 23 73400 10 10 11 Software 53 1 11 Yes Explorer 2 3 93 93400 11 11 12 Hardware 41 1 1 Yes Sentinel 1 2 26 51800 12 12 13 Hardware 40 0 1 No Diplomat 4 3 60 116000 13 13 14 Software 41 0 2 Yes Explorer 3 2 17 89000 14 14 15 Hardware 46 1 2 Yes Analyst 1 4 00 61800 15 15 16 Hardware 38 1 4 Yes Diplomat 1 2 37 57400 16 16 17 Software 39 0 2 No Sentinel 2 3 00 57000 17 17 18 Hardware 52 1 1 No Sentinel 0 2 72 50600 18 18 19 Software 54 1 2 Yes Explorer 5 2 04 90200 19 19 20 Hardware 24 0 1 Yes Analyst 1 2 66 39000 20 20 21 Software 53 0 1 Yes Explorer 2 2 42 75000 21 21 22 Hardware 37 1 1 Yes Diplomat 2 3 71 96600 22 22 23 Software 32 1 1 Yes Explorer 3 3 42 61600 23 23 24 Hardware 33 0 2 Yes Explorer 1 1 16 60000 24 24 25 Software 55 1 1 Yes Analyst 1 1 99 53000 25 25 26 Software 27 1 2 Yes Diplomat 6 2 93 73600 26 26 27 Hardware 58 1 2 Yes Explorer 4 3 54 73400 27 27 28 Software 52 1 7 Yes Sentinel 1 3 37 46600 28 28 29 Software 26 0 1 Yes Explorer 2 3 29 77000 29 29 30 Software 28 1 8 Yes Diplomat 3 2 50 66400 30 30

Question: Subset the data set to include only sales professionals in one of the two product groups. Cluster the sales professionals based on numerical variables of

Subset the data set to include only sales professionals in one of the two product groups. Cluster the sales professionals based on numerical variables of your choice (e.g., age, salary). Determine the appropriate number of clusters. Describe each cluster and compare the average net promoter scores of the clusters.

Sales_Rep	Business	Age	Female	Years	College	Personality	Certficates	Feedback	Salary	Sales_Rep	Sales_Rep
1	Hardware	59	1	2	Yes	Diplomat	1	2.01	70200	1	1
2	Hardware	52	0	10	Yes	Diplomat	4	3.64	133000	2	2
3	Software	47	1	1	Yes	Explorer	1	3.88	52600	3	3
4	Hardware	61	0	2	Yes	Diplomat	3	2.70	96000	4	4
5	Software	39	0	1	No	Diplomat	5	3.44	122000	5	5
6	Hardware	28	0	6	Yes	Explorer	1	2.43	60000	6	6
7	Software	25	1	1	Yes	Explorer	5	3.3	68000	7	7
8	Hardware	51	1	10	No	Explorer	0	2.15	43800	8	8
9	Hardware	34	0	4	Yes	Diplomat	2	2.91	92000	9	9
10	Hardware	38	1	1	Yes	Explorer	5	1.23	73400	10	10
11	Software	53	1	11	Yes	Explorer	2	3.93	93400	11	11
12	Hardware	41	1	1	Yes	Sentinel	1	2.26	51800	12	12
13	Hardware	40	0	1	No	Diplomat	4	3.60	116000	13	13
14	Software	41	0	2	Yes	Explorer	3	2.17	89000	14	14
15	Hardware	46	1	2	Yes	Analyst	1	4.00	61800	15	15
16	Hardware	38	1	4	Yes	Diplomat	1	2.37	57400	16	16
17	Software	39	0	2	No	Sentinel	2	3.00	57000	17	17
18	Hardware	52	1	1	No	Sentinel	0	2.72	50600	18	18
19	Software	54	1	2	Yes	Explorer	5	2.04	90200	19	19
20	Hardware	24	0	1	Yes	Analyst	1	2.66	39000	20	20
21	Software	53	0	1	Yes	Explorer	2	2.42	75000	21	21
22	Hardware	37	1	1	Yes	Diplomat	2	3.71	96600	22	22
23	Software	32	1	1	Yes	Explorer	3	3.42	61600	23	23
24	Hardware	33	0	2	Yes	Explorer	1	1.16	60000	24	24
25	Software	55	1	1	Yes	Analyst	1	1.99	53000	25	25
26	Software	27	1	2	Yes	Diplomat	6	2.93	73600	26	26
27	Hardware	58	1	2	Yes	Explorer	4	3.54	73400	27	27
28	Software	52	1	7	Yes	Sentinel	1	3.37	46600	28	28
29	Software	26	0	1	Yes	Explorer	2	3.29	77000	29	29
30	Software	28	1	8	Yes	Diplomat	3	2.50	66400	30	30

Step by Step Solution

★★★★★

3.52 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To determine the appropriate number of clusters for the subset of sales professionals in the hardwar... 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

Students Have Also Explored These Related Business Analytics Data Questions!

Subset the data set to include only those individuals who lived in an urban area. Cluster the individuals using a combination of numerical and categorical variables. Determine the appropriate number...

Subset the data set to include only college-educated sales professionals in the software product group. Predict whether the sales professional will receive a high (9 or 10) net promoter score (NPS)...

The accompanying data set contains four variables, x 1 , x 2 , x 3 , and x 4 . a. Subset the data set to include only observations that have a date on or after May 1, 1975, for x 3 . How many...

Required information Skip to question [ The following information applies to the questions displayed below. ] The TechSales _ Rep data contain records of 2 1 , 9 9 0 sales representatives from the...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Business Research Methodology- Question Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

10. An experimenter has some degree of control over the: a. independent variable. b. correlative variable. c. history effect. d. All of the above, if the experiment is conducted properly. 11. If a...

Why must business managers understand the importance of business research and how it is used in their organizations?

Consider the following annualized information about risk and return measures of two portfolios. The S&P500 Index portfolio may be viewed as the market portfolio for purposes of applying the...

57. What is the purpose of testing whether b1 = 0? If we reject b1 = 0, does it imply a good fit?

D. Was the tone appropriate?

The accompanying data file contains 20 observations on the binary response variable y along with the predictor variables x 1 and x 2 . a. Estimate and interpret the linear probability model and the...

More and more parole boards are using risk assessment tools when trying to determine an individuals likelihood of returning to crime (Prison Legal News, February 2, 2016). Most of these models are...

The accompanying data file contains 20 observations on the binary response variable y along with the predictor variables x 1 and x 2 . a. Estimate the linear probability model to compute y for x 1 =...

Exercise 15-4 Analysis of cost flows L.O. C2, P1, P2, P3 As of the end of June, the job cost sheets at Racing Wheels, Inc., show the following total costs accumulated on three custom jobs. Job 102...

Holland, Flowers, and Tulip have been partners while sharing net income and loss in a 5:3:2 ratio. On January 31, the date Tulip retires from the partnership, the equities of the partners are...

sales budget for next month of $600,000. COGS is expected to be 30 % of sales. All goods are purchased in the month used and paid for in the month following purchase. The beginning inventory of...