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 R^2. (Note that the categorical variable department has multiple levels and will require the use of multiple dummy variables, similar to Example 8.17.) Which department, if any, has the highest impact on satisfaction?

1 Job Satisfaction Years of Service 1=Low, 10=High Overall Job satisfaction Years Maintenance Management Production Quality Contro Shipiping/Recei' Satisfaction 16 14 17 1 ww- V60 6 Department 7 Administrative 8 Administrative 9 Administrative 10 Maintenance 11 Maintenance 12 Management 13 Management 14 Management 15 Production 16 Production 17 Production 18 Production 19 Production 20 Production 21 Production 22 Production 23 Production 24 Production 25 Production 26 Production 27 Production 28 Production 29 Production 30 Production 31 Production 32 Quality Control 33 Quality Control 34 Shipping / Receiving 35 Shipping / Receiving 36 Shipping / Receiving 37 Shipping / Receiving 38 Shinning/ Receiving ONNU 17 15 v vo o ovo 1 32 1 Job Satisfaction Years of Service 1=Low, 10=High Overall Job satisfaction Years Maintenance Management Production Quality Contro Shipiping/Recei' Satisfaction 16 14 17 1 ww- V60 6 Department 7 Administrative 8 Administrative 9 Administrative 10 Maintenance 11 Maintenance 12 Management 13 Management 14 Management 15 Production 16 Production 17 Production 18 Production 19 Production 20 Production 21 Production 22 Production 23 Production 24 Production 25 Production 26 Production 27 Production 28 Production 29 Production 30 Production 31 Production 32 Quality Control 33 Quality Control 34 Shipping / Receiving 35 Shipping / Receiving 36 Shipping / Receiving 37 Shipping / Receiving 38 Shinning/ Receiving ONNU 17 15 v vo o ovo 1 32