For the provided data, develop a regression model for overall satisfaction as a function of years...

Transcribed Image Text:

For the provided data, develop a regression model for overall satisfaction as a function of years of service and department that has the largest appropriate R value. 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? Click the icon to view the job satisfaction data. Determine the regression model for overall satisfaction as a function of years of service and department that has the largest R. Let "Administrative" be the baseline department, let X represent Maintenance, let X represent Management, let X3 represent Production, let X4 represent Quality Control, and let X5 represent Shipping / Receiving, coding each department variable with a 1 if the person is in that department and 0 otherwise. In addition, let X represent Years. Enter the terms of the equation so that the XK-values are in ascending numerical order by base. Select the correct choice below and fill in any answer boxes within your choice. (Type integers or decimals rounded to three decimal places as needed.) O A. __X__+(\ -1.865)X+ 0.049)X3 + ([1.486 )X4 + (0.582 )X5 + (0.117)X OB. O D. 7.717 +(2.658 )X + + X O 1)X A29 1 A Department 2 Management 3 Administrative 4 Production 5 Production 6 Quality Control 7 Maintenance 8 Maintenance 9 Production 10 Quality Control 11 Production 12 Production 13 Production 14 Production 15 Production 16 Production 17 Shipping / Receiving 18 Production 19 Production 20 Production 21 Management 22 Production 23 Shipping/Receiving 24 Management 25 Administrative 26 Production 27 Shinning / Beceiving B Years fx 1 16 16 15 1 1 17 15 13 11 3 6 1 3 2 3 21 2 2 15 3 5 8 3 2 8 32 Shipping / Receiving Ideas 5 2 2 2 5 5 5 3 3 5 2 5 3 4 3 3 4 4 5 3 4 3 2 4 5 2 D E F G Communication Recognition Training Work Conditions Tools and Information Work/Life Balance Satisfaction 4 3 3 3 5 4 5 3 4 5 2 4 4 4 4 2 3 5 4 4 5 2 2 4 5 3 4 2 2 1 5 3 5 3 4 5 1 4 3 4 3 2 4 4 3 3 3 2 2 3 3 2 3 2 4 4 5 5 5 4 4 5 3 3 4 4 3 3 3 4 4 3 2 2 2 4 5 4 5 4 4 4 5 5 5 4 5 5 3 4 5 5 2 2 3 4 3 4 3 2 3 4 3 2 H 3 5 4 4 5 5 5 4 5 5 4 5 5 5 4 4 4 4 5 5 5 4 5 5 5 5 5 2 2 2 5 3 5 3 2 5 2 5 4 5 4 3 4 4 3 5 4 2 3 3 3 3 9 3 5 4 10 8 9 8 7 10 4 9 7 9 6 6 6 7 7 8 7 4 3 9 8 5 K File M31 Home A Department 10 Quality Control 1 11 Production insert 12 Production 13 Production 14 Production 15 Production 16 Production 17 Shipping/ Receiving 18 Production 19 Production 20 Production 21 Management 22 Production 23 Shipping/ Receiving 24 Management 25 Administrative 26 Production 27 Shipping/ Receiving 28 Production 29 Shipping/ Receiving 30 Production 31 Production 32 Administrative 33 Shipping/ Receiving 34 35 Page Layout B Years 11 3 6 1 3 2 3 21 2 2 15 3 5 8 3 2 8 32 17 2 15 5 14 18 3 5 2 5 3 4 3 3 4 4 5 3 4 3 2 4 Formulas D E F G Ideas Communication Recognition Training Work Conditions Tools and Information Work/Life Balance Satisfaction 5 2 4 5 5 2 4 4 Data 4 5 2 4 4 4 4 2 3 5 4 4 5 2 2 4 5 3 Review 3 5 3 4 3 4 4 5 1 view 4 3 4 3 2 4 4 3 3 3 2 2 3 3 2 4 5 4 2 2 4 Automate 4 5 3 3 4 4 3 3 3 4 4 3 2 2 2 4 5 41 3 5 5 2 2 5 Heip 5 5 3 4 5 5 2 2 3 4 3 JIVIP 4 3 2 3 4 3 2 3 5 5 2 5 5 H 5 5 4 5 5 5 4 4 4 4 5 5 5 4 5 5 5 5 5 5 5 5 5 5 I 2 5 2 5 4 5 4 3 4 4 3 5 4 2 3 3 3 3 2 5 5 3 5 5 7 10 4 9 7 9 6 6 6 7 7 8 7 4 3 9 8 5 6 9 9 3 6 8 K L For the provided data, develop a regression model for overall satisfaction as a function of years of service and department that has the largest appropriate R value. 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? Click the icon to view the job satisfaction data. Determine the regression model for overall satisfaction as a function of years of service and department that has the largest R. Let "Administrative" be the baseline department, let X represent Maintenance, let X represent Management, let X3 represent Production, let X4 represent Quality Control, and let X5 represent Shipping / Receiving, coding each department variable with a 1 if the person is in that department and 0 otherwise. In addition, let X represent Years. Enter the terms of the equation so that the XK-values are in ascending numerical order by base. Select the correct choice below and fill in any answer boxes within your choice. (Type integers or decimals rounded to three decimal places as needed.) O A. __X__+(\ -1.865)X+ 0.049)X3 + ([1.486 )X4 + (0.582 )X5 + (0.117)X OB. O D. 7.717 +(2.658 )X + + X O 1)X A29 1 A Department 2 Management 3 Administrative 4 Production 5 Production 6 Quality Control 7 Maintenance 8 Maintenance 9 Production 10 Quality Control 11 Production 12 Production 13 Production 14 Production 15 Production 16 Production 17 Shipping / Receiving 18 Production 19 Production 20 Production 21 Management 22 Production 23 Shipping/Receiving 24 Management 25 Administrative 26 Production 27 Shinning / Beceiving B Years fx 1 16 16 15 1 1 17 15 13 11 3 6 1 3 2 3 21 2 2 15 3 5 8 3 2 8 32 Shipping / Receiving Ideas 5 2 2 2 5 5 5 3 3 5 2 5 3 4 3 3 4 4 5 3 4 3 2 4 5 2 D E F G Communication Recognition Training Work Conditions Tools and Information Work/Life Balance Satisfaction 4 3 3 3 5 4 5 3 4 5 2 4 4 4 4 2 3 5 4 4 5 2 2 4 5 3 4 2 2 1 5 3 5 3 4 5 1 4 3 4 3 2 4 4 3 3 3 2 2 3 3 2 3 2 4 4 5 5 5 4 4 5 3 3 4 4 3 3 3 4 4 3 2 2 2 4 5 4 5 4 4 4 5 5 5 4 5 5 3 4 5 5 2 2 3 4 3 4 3 2 3 4 3 2 H 3 5 4 4 5 5 5 4 5 5 4 5 5 5 4 4 4 4 5 5 5 4 5 5 5 5 5 2 2 2 5 3 5 3 2 5 2 5 4 5 4 3 4 4 3 5 4 2 3 3 3 3 9 3 5 4 10 8 9 8 7 10 4 9 7 9 6 6 6 7 7 8 7 4 3 9 8 5 K File M31 Home A Department 10 Quality Control 1 11 Production insert 12 Production 13 Production 14 Production 15 Production 16 Production 17 Shipping/ Receiving 18 Production 19 Production 20 Production 21 Management 22 Production 23 Shipping/ Receiving 24 Management 25 Administrative 26 Production 27 Shipping/ Receiving 28 Production 29 Shipping/ Receiving 30 Production 31 Production 32 Administrative 33 Shipping/ Receiving 34 35 Page Layout B Years 11 3 6 1 3 2 3 21 2 2 15 3 5 8 3 2 8 32 17 2 15 5 14 18 3 5 2 5 3 4 3 3 4 4 5 3 4 3 2 4 Formulas D E F G Ideas Communication Recognition Training Work Conditions Tools and Information Work/Life Balance Satisfaction 5 2 4 5 5 2 4 4 Data 4 5 2 4 4 4 4 2 3 5 4 4 5 2 2 4 5 3 Review 3 5 3 4 3 4 4 5 1 view 4 3 4 3 2 4 4 3 3 3 2 2 3 3 2 4 5 4 2 2 4 Automate 4 5 3 3 4 4 3 3 3 4 4 3 2 2 2 4 5 41 3 5 5 2 2 5 Heip 5 5 3 4 5 5 2 2 3 4 3 JIVIP 4 3 2 3 4 3 2 3 5 5 2 5 5 H 5 5 4 5 5 5 4 4 4 4 5 5 5 4 5 5 5 5 5 5 5 5 5 5 I 2 5 2 5 4 5 4 3 4 4 3 5 4 2 3 3 3 3 2 5 5 3 5 5 7 10 4 9 7 9 6 6 6 7 7 8 7 4 3 9 8 5 6 9 9 3 6 8 K L

Answer rating: 100% (QA)

Answer Modify the data as follows Department Satisfaction X1 X2 X3 X4 X5 X6 Management 9 0 1 0 0 0 1 Administrative 3 0 0 0 0 0 16 Production 5 0 0 1 0 0 16 Production 4 0 0 1 0 0 15 Quality Control 1... View the full answer