For the Excel file Job Satisfaction, develop a regression model for overall satisfaction as a function of years of service and department that has the largest (Note that the categorical variable department has multiple levels and will require the use of multiple dummy variables) Which department, if any, has the highest impact on satisfaction? Job Satisfaction                 Department Years of Service Maintenance Management Production Quality Control  Shipiping/Receiving Job Satisfaction Administrative 16 No No No No No 3 Administrative 2 No No No No No 9 Administrative 14 No No No No No 6 Maintenance 17 Yes No No No No 8 Maintenance 15 Yes No No No No 9 Management 1 No Yes No No No 9 Management 3 No Yes No No No 8 Management 3 No Yes No No No 3 Production 16 No No Yes No No 5 Production 15 No No Yes No No 4 Production 13 No No Yes No No 8 Production 3 No No Yes No No 10 Production 6 No No Yes No No 4 Production 1 No No Yes No No 9 Production 3 No No Yes No No 7 Production 2 No No Yes No No 8 Production 3 No No Yes No No 6 Production 2 No No Yes No No 6 Production 2 No No Yes No No 8 Production 15 No No Yes No No 7 Production 5 No No Yes No No 7 Production 8 No No Yes No No 8 Production 17 No No Yes No No 6 Production 15 No No Yes No No 9 Production 5 No No Yes No No 3 Quality Control 1 No No No Yes No 10 Quality Control 11 No No No Yes No 7 Shipping / Receiving 21 No No No No Yes 5 Shipping / Receiving 8 No No No No Yes 4 Shipping / Receiving 32 No No No No Yes 5 Shipping / Receiving 2 No No No No Yes 10 Shipping / Receiving 18 No No No No Yes 8

Subject:MathPrice: Bought3

Share With

For the Excel file Job Satisfaction, develop a regression model for overall satisfaction as a function of years of service and department that has the largest (Note that the categorical variable department has multiple levels and will require the use of multiple dummy variables) Which department, if any, has the highest impact on satisfaction?

Job Satisfaction
Department	Years of Service	Maintenance	Management	Production	Quality Control	Shipiping/Receiving	Job Satisfaction
Administrative	16	No	No	No	No	No	3
Administrative	2	No	No	No	No	No	9
Administrative	14	No	No	No	No	No	6
Maintenance	17	Yes	No	No	No	No	8
Maintenance	15	Yes	No	No	No	No	9
Management	1	No	Yes	No	No	No	9
Management	3	No	Yes	No	No	No	8
Management	3	No	Yes	No	No	No	3
Production	16	No	No	Yes	No	No	5
Production	15	No	No	Yes	No	No	4
Production	13	No	No	Yes	No	No	8
Production	3	No	No	Yes	No	No	10
Production	6	No	No	Yes	No	No	4
Production	1	No	No	Yes	No	No	9
Production	3	No	No	Yes	No	No	7
Production	2	No	No	Yes	No	No	8
Production	3	No	No	Yes	No	No	6
Production	2	No	No	Yes	No	No	6
Production	2	No	No	Yes	No	No	8
Production	15	No	No	Yes	No	No	7
Production	5	No	No	Yes	No	No	7
Production	8	No	No	Yes	No	No	8
Production	17	No	No	Yes	No	No	6
Production	15	No	No	Yes	No	No	9
Production	5	No	No	Yes	No	No	3
Quality Control	1	No	No	No	Yes	No	10
Quality Control	11	No	No	No	Yes	No	7
Shipping / Receiving	21	No	No	No	No	Yes	5
Shipping / Receiving	8	No	No	No	No	Yes	4
Shipping / Receiving	32	No	No	No	No	Yes	5
Shipping / Receiving	2	No	No	No	No	Yes	10
Shipping / Receiving	18	No	No	No	No	Yes	8