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