Use a multiple regression model to predict the income (Y) by using work (X1), educ (X2), gender (X3), age (X4), and hours (X5). Call this model as M5. Display the summary calculations for M5. Using the regression summary calculations, answer the following questions:

1. What % of the total variation in employee income is explained by this regression (R2)?

2. is the percentage explained by this model significantly higher that the R2 of the previous model (M3)? If not, what does that imply?

3. Which variables are NOT significant in this regression at significance level of 0.05?

data set:

homework.RMD | ciccup3 7 Filter List - occup income work cduc gender age hours Environment History Connections Tutorial Import Dataset-120 MIB - R Global Environment Data o occup3 62 obs. of 9 variables 1 3 65.2 21.7 13 M 40 2 2 3 64.5 20.9 12 M 20 3 3 3 61.0 20.0 10 M 38 4 3 61,5 19.9 16 M 44 3 51 - 5 6 63.5 63.9 19.9 19. 19.7 192 19.2 12 M 12 18 M 3 3 38 ra 54 1 7 60.6 14 M 0 8 19.1 48 3 . 3 65.0 20 70.7 12 M . 16 F 9 19.0 36 10 3 60.1 18.7 12 M 51 11 3 60.2 18.5 12 M 53 12 3 62.7 18.4 13 M 37 Help Viewer 13 3 62.8 18.3 16 M 51 Rename More - Files Plots Packages - New Folder Delete O Home > Documents A Name 14 3 73.4 18.3 20 M 40 Size Modified 15 3 64.5 18.2 14 F 40 16 62.0 18.1 14 M 10 satisfaction important 60 moderately satisfied work enjoyment 60 moderately satisfied high income 30 moderately satisfied work enjoyment 40 moderately satisfied advancement opportunity 60 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 50 very satisfied work enjoyment ............... 40 moderately satisfied advancement opportunity och 40 moderately satisfied work enjoyment 67 very satisfied advancement opportunity 40 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 60 very satisfied high income 50 very satisfied work enjoyment 10 moderately satisfied work en loyment 40 very satisfied work 60 very satisfied high incorre 40 moderately satisfied work enjoyment 50 moderately satisfied work enjoyment 42 moderately satisfied advancement opportunity 40 moderately satisfied high income 40 moderately satisfied work enjoyment 40 very satisfied work enjoyment 45 moderately satisfied work enjoyment moderately satisfied advancement opportunity 40 very satisfied work enjoyment 34 moderately satisfied advancement opportunity 60 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 46 moderately satisfied advancement opportunity 40 moderately satisfied high income 3 3 3 17 ? 17.9 14 M 36 em 18 66.5 17.6 13 M 36 19 3 17.5 Ano 14 M 41 DO Adobe O grunge-antique-photo-texture-PNG-for-photoshop-th... 996.3 KB --- letterforms part 3.indd 924 KB Occupational Group Assignments 343_105.xlsx 20.3 KB Oold meets new (second photo choice).jpg ( 1.2 MB occup3.csv 3.6 KB Feb 1, 2022, 10:30 AM Feb 6, 2022, 11:05 PM Feb 20, 2022, 10:05 AM Jan 25, 2022, 10-07 AM Feb 20, 2022, 10:06 AM 63.3 60.7 61.9 20 3 17.4 27. 12 M 36 21 3 17.1 12 M 36 22 3 62.5 16.9 12 F 50 23 3 16.4 14 M 42 64.4 60.9 24 3 16.1 10 F 10 25 3 65.4 15.5 12 M 42 26 3 68.6 15.5 14 M 96 12 M 12 M 53 15.3 ** 44 11 M 12 M 34 27 3 64.4 15.4 28 3 66.5 10. 29 3 68.8 15.2 30 3 64.5 14 14.9 31 3 61.9 14.7 32 3 60.4 14.6 Showing 1 to 32 of 62 entries, 9 total columns 11 M 33 14 F 33 12 F 33 Console occup3 x Environm and homework 4.RMD* X Y Filter occup income work educ gender age hours satisfaction important R 33 3 68.6 14.6 14 M 43 Data occup3 34 3 56.0 14.6 12 F 48 35 3 59.8 14.5 13 M 49 36 3 69.5 14.5 12 M. M 38 37 3 57.8 14.4 11 F 52 40 moderately satisfied work enjoyment 40 very satisfied high income 55 moderately satisfied high income 40 very satisfied high income 50 very satisfied work enjoyment 40 moderately satisfied advancement opportunity 38 moderately satisfied high income 44 moderately satisfied high income 42 moderately satisfied work enjoyment 38 3 64.2 14.4 16 M 33 39 3 68.2 14.4 14 F 34 40 3 56.8 14.4 12 M 33 41 3 63.2 14.3 12 F 57 42 3 59.7 14.3 14 M 47 72 very satisfied high income 43 3 59.8 14.2 13 M 40 Files PL 44 3 62.4 14.2 13 M 56 New FC 45 3 61.7 14.1 16 F 40 O Ho 46 3 61.1 13.9 18 M 42 47 3 59.2 13.7 12 M 52 48 3 56.5 13.7 12 F F 32 49 3 55.7 13.5 12 M 32 a 50 3 3 59.7 13.2 12 M 34 le 51 3 57.2 13.1 12 M 50 c 52 3 62.6 13.1 12 M 44 40 very satisfied high income 40 very satisfied work enjoyment 40 moderately satisfied work enjoyment 50 very satisfied work enjoyment 40 very satisfied work enjoyment 72 very satisfied high income 70 very satisfied high income 52 moderately satisfied work enjoyment 68 very satisfied high income 40 very satisfied advancement opportunity 50 moderately satisfied work enjoyment 44 moderately satisfied work enjoyment 40 dissatisfied work enjoyment 40 moderately satisfied work enjoyment 75 moderately satisfied advancement opportunity 46 very satisfied work enjoyment 50 very satisfied advancement opportunity 40 moderately satisfied high income 40 moderately satisfied high income 40 very satisfied work enjoyment C 53 3 57.4 12.9 12 F 34 54 3 59.7 12.6 12 M. 55 55 3 54.1 12.5 13 M 49 56 3 55.5 12.0 13 F 31 57 3 66.0 11.5 14 M 30 58 3 56.5 11.3 15 M. 40 59 3 57.3 10.7 12 M 29 60 3 53.2 10.0 12 M 47 61 3 50.1 8.7 12 F 34 62 3 53.1 8.5 12 M 35 Showing 32 to 62 of 62 entries, 9 total columns homework.RMD | ciccup3 7 Filter List - occup income work cduc gender age hours Environment History Connections Tutorial Import Dataset-120 MIB - R Global Environment Data o occup3 62 obs. of 9 variables 1 3 65.2 21.7 13 M 40 2 2 3 64.5 20.9 12 M 20 3 3 3 61.0 20.0 10 M 38 4 3 61,5 19.9 16 M 44 3 51 - 5 6 63.5 63.9 19.9 19. 19.7 192 19.2 12 M 12 18 M 3 3 38 ra 54 1 7 60.6 14 M 0 8 19.1 48 3 . 3 65.0 20 70.7 12 M . 16 F 9 19.0 36 10 3 60.1 18.7 12 M 51 11 3 60.2 18.5 12 M 53 12 3 62.7 18.4 13 M 37 Help Viewer 13 3 62.8 18.3 16 M 51 Rename More - Files Plots Packages - New Folder Delete O Home > Documents A Name 14 3 73.4 18.3 20 M 40 Size Modified 15 3 64.5 18.2 14 F 40 16 62.0 18.1 14 M 10 satisfaction important 60 moderately satisfied work enjoyment 60 moderately satisfied high income 30 moderately satisfied work enjoyment 40 moderately satisfied advancement opportunity 60 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 50 very satisfied work enjoyment ............... 40 moderately satisfied advancement opportunity och 40 moderately satisfied work enjoyment 67 very satisfied advancement opportunity 40 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 60 very satisfied high income 50 very satisfied work enjoyment 10 moderately satisfied work en loyment 40 very satisfied work 60 very satisfied high incorre 40 moderately satisfied work enjoyment 50 moderately satisfied work enjoyment 42 moderately satisfied advancement opportunity 40 moderately satisfied high income 40 moderately satisfied work enjoyment 40 very satisfied work enjoyment 45 moderately satisfied work enjoyment moderately satisfied advancement opportunity 40 very satisfied work enjoyment 34 moderately satisfied advancement opportunity 60 moderately satisfied work enjoyment 40 moderately satisfied work enjoyment 46 moderately satisfied advancement opportunity 40 moderately satisfied high income 3 3 3 17 ? 17.9 14 M 36 em 18 66.5 17.6 13 M 36 19 3 17.5 Ano 14 M 41 DO Adobe O grunge-antique-photo-texture-PNG-for-photoshop-th... 996.3 KB --- letterforms part 3.indd 924 KB Occupational Group Assignments 343_105.xlsx 20.3 KB Oold meets new (second photo choice).jpg ( 1.2 MB occup3.csv 3.6 KB Feb 1, 2022, 10:30 AM Feb 6, 2022, 11:05 PM Feb 20, 2022, 10:05 AM Jan 25, 2022, 10-07 AM Feb 20, 2022, 10:06 AM 63.3 60.7 61.9 20 3 17.4 27. 12 M 36 21 3 17.1 12 M 36 22 3 62.5 16.9 12 F 50 23 3 16.4 14 M 42 64.4 60.9 24 3 16.1 10 F 10 25 3 65.4 15.5 12 M 42 26 3 68.6 15.5 14 M 96 12 M 12 M 53 15.3 ** 44 11 M 12 M 34 27 3 64.4 15.4 28 3 66.5 10. 29 3 68.8 15.2 30 3 64.5 14 14.9 31 3 61.9 14.7 32 3 60.4 14.6 Showing 1 to 32 of 62 entries, 9 total columns 11 M 33 14 F 33 12 F 33 Console occup3 x Environm and homework 4.RMD* X Y Filter occup income work educ gender age hours satisfaction important R 33 3 68.6 14.6 14 M 43 Data occup3 34 3 56.0 14.6 12 F 48 35 3 59.8 14.5 13 M 49 36 3 69.5 14.5 12 M. M 38 37 3 57.8 14.4 11 F 52 40 moderately satisfied work enjoyment 40 very satisfied high income 55 moderately satisfied high income 40 very satisfied high income 50 very satisfied work enjoyment 40 moderately satisfied advancement opportunity 38 moderately satisfied high income 44 moderately satisfied high income 42 moderately satisfied work enjoyment 38 3 64.2 14.4 16 M 33 39 3 68.2 14.4 14 F 34 40 3 56.8 14.4 12 M 33 41 3 63.2 14.3 12 F 57 42 3 59.7 14.3 14 M 47 72 very satisfied high income 43 3 59.8 14.2 13 M 40 Files PL 44 3 62.4 14.2 13 M 56 New FC 45 3 61.7 14.1 16 F 40 O Ho 46 3 61.1 13.9 18 M 42 47 3 59.2 13.7 12 M 52 48 3 56.5 13.7 12 F F 32 49 3 55.7 13.5 12 M 32 a 50 3 3 59.7 13.2 12 M 34 le 51 3 57.2 13.1 12 M 50 c 52 3 62.6 13.1 12 M 44 40 very satisfied high income 40 very satisfied work enjoyment 40 moderately satisfied work enjoyment 50 very satisfied work enjoyment 40 very satisfied work enjoyment 72 very satisfied high income 70 very satisfied high income 52 moderately satisfied work enjoyment 68 very satisfied high income 40 very satisfied advancement opportunity 50 moderately satisfied work enjoyment 44 moderately satisfied work enjoyment 40 dissatisfied work enjoyment 40 moderately satisfied work enjoyment 75 moderately satisfied advancement opportunity 46 very satisfied work enjoyment 50 very satisfied advancement opportunity 40 moderately satisfied high income 40 moderately satisfied high income 40 very satisfied work enjoyment C 53 3 57.4 12.9 12 F 34 54 3 59.7 12.6 12 M. 55 55 3 54.1 12.5 13 M 49 56 3 55.5 12.0 13 F 31 57 3 66.0 11.5 14 M 30 58 3 56.5 11.3 15 M. 40 59 3 57.3 10.7 12 M 29 60 3 53.2 10.0 12 M 47 61 3 50.1 8.7 12 F 34 62 3 53.1 8.5 12 M 35 Showing 32 to 62 of 62 entries, 9 total columns