The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty Use data on employees in the hardware product group with a college degree to develop a regression model that analyzes the effect of cognitive and noncognitive factors on NPS Use model selection criteria to find the appropriate model for the analysis Interpret your results with reference to well formatted figures and tables Sales Rep Business Age Female Years College Personality Certficates Feedback Salary NPS 1 Hardware 59 1 2 Yes Diplomat 1 2 01 70200 5 2 Hardware 52 0 10 Yes Diplomat 4 3 64 133000 10 3 Software 47 1 1 Yes Explorer 1 3 88 52600 8 4 Hardware 61 0 2 Yes Diplomat 3 2 70 96000 6 5 Software 39 0 1 No Diplomat 5 3 44 122000 7 6 Hardware 28 0 6 Yes Explorer 1 2 43 60000 6 7 Software 25 1 1 Yes Explorer 5 3 3 68000 6 8 Hardware 51 1 10 No Explorer 0 2 15 43800 5 9 Hardware 34 0 4 Yes Diplomat 2 2 91 92000 7 10 Hardware 38 1 1 Yes Explorer 5 1 23 73400 6 11 Software 53 1 11 Yes Explorer 2 3 93 93400 8 12 Hardware 41 1 1 Yes Sentinel 1 2 26 51800 5 13 Hardware 40 0 1 No Diplomat 4 3 60 116000 9 14 Software 41 0 2 Yes Explorer 3 2 17 89000 6 15 Hardware 46 1 2 Yes Analyst 1 4 00 61800 5 16 Hardware 38 1 4 Yes Diplomat 1 2 37 57400 4 17 Software 39 0 2 No Sentinel 2 3 00 57000 3 18 Hardware 52 1 1 No Sentinel 0 2 72 50600 4 19 Software 54 1 2 Yes Explorer 5 2 04 90200 9 20 Hardware 24 0 1 Yes Analyst 1 2 66 39000 3 21 Software 53 0 1 Yes Explorer 2 2 42 75000 6 22 Hardware 37 1 1 Yes Diplomat 2 3 71 96600 9 23 Software 32 1 1 Yes Explorer 3 3 42 61600 5 24 Hardware 33 0 2 Yes Explorer 1 1 16 60000 4 25 Software 55 1 1 Yes Analyst 1 1 99 53000 4 26 Software 27 1 2 Yes Diplomat 6 2 93 73600 9 27 Hardware 58 1 2 Yes Explorer 4 3 54 73400 7 28 Software 52 1 7 Yes Sentinel 1 3 37 46600 3 29 Software 26 0 1 Yes Explorer 2 3 29 77000 10

Question: The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty. Use data on employees in the hardware product group with a

The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty. Use data on employees in the hardware product group with a college degree to develop a regression model that analyzes the effect of cognitive and noncognitive factors on NPS. Use model selection criteria to find the appropriate model for the analysis. Interpret your results with reference to well-formatted figures and tables.

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

Step by Step Solution

★★★★★

3.32 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

First subset the TechSalesReps data to include only hardware product You should obtain 9860 observat... 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!

The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty. Use data on employees in the software product group with a college degree to develop the logistic regression...

Cassius Weatherby is a human resources manager at a major technology firm that produces software and hardware products. He would like to analyze the net promoter score (NPS) of sales professionals at...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Case Study Cassius Weatherby is a human resources manager at a major technology firm that produces software and hardware products. He would like to analyze the net promoter score (NPS) of sales...

CASE STUDY Use data on employees in the software product group with a college degree for variables representing sex (female or male), personality type, salary, and net promoter score to construct...

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...

The net promoter scores ( NPS ) is a key indicator of customer satisfaction and loyalty. Use the data on employees in hardware product group

The question at the end of this topic, take your time and solve this case study please. Case Study Cassius Weatherby is a human resources manager at a major technology firm that produces software and...

Please i need 8 slide power point presentation on this article please . Required: Question: Make 8 slide presentation of powerpoint Leading With Next-Generation Key Performance Indicators 4 Executive...

. Requred: Question: make 8 slide of power point presentation on the above case study Rapid advances in machine learning (ML) that is a or click-through conversions are giving way to more machine's...

Gino has a debit card. The account pays no interest. He keeps track of his purchases and deposits in this debit card register. Find the missing entries a-f. YMENT 8/4 Baseball Bat 92 1 9219 a. 51.00...

An electric eel delivers a current of 0.75 A to a small pencil-thin prey 15 cm long. If the eels bio-battery was charged to 500 V, and it was constant for 20 ms before dropping to zero, estimate (a)...

2 . 3 For each of the plane grid structures shown in figure P 2 . 3 , calculate the reactive forces and sketch the shear force, and bending and torsional moment diagrams for the element 1 - 2 ....

A. Karen May suggests you shouldnt hold a feedback conversation unless you have some guidance or solutions. In what ways do you agree and disagree?

According to a 2018 paper released by the Economic Policy Institute, a nonprofit, nonpartisan think tank in Washington, D.C., income inequality continues to grow in the United States. Over the years,...

Suppose that the typical college student graduates with $28,650 in debt. Let debt among recent college graduates be normally distributed with a standard deviation of $7,000. a. What is the...

A 2019 Pew Research study finds that the number of undocumented immigrants living in the United States has dropped to the level it was in 2004. While its share has declined, California still accounts...

In 2020, the following transaction occurred between Senators Wholesale Corp. (consignor) and Canadiens Stores (consignee): On March 2, 2020 Senators shipped merchandise costing $ 52,000 to Canadiens....

Corporation reported stockholders' equity on Dec 31 of the prior year as follows: Common stock, $5 par value, 1,000,000 shares $2,500,000 authorized, 500,000 shares issued ----- 2,5000,000 Paid-in...

Exercise 8-2 Recording costs of assets LO C1 Cala Manufacturing purchases a large lot on which an old building is located as part of its plans to build a new plant. The negotiated purchase price is...