Suppose you wanted to predict InfctRsk using a combination of predictors from this data set. Find the correlation between each variable below and InfctRsk. Stay 0.5334438 Age 0.001093166 Culture 0.4533916 Xray 0.4533916 Beds 0.2330299 Census 0.2330299 Nurses 0.3939813 Facilities 0.4126007Fit a multiple regression model using the five variables that have the highest correlations with InfctRsk: Stay, Culture, Xray, Facilities, and Nurses. Perform the F-test for overall significance. Use a = .05. . The test statistic is [ Select ] , with a p-value of [ Select ] There [ Select ] sufficient evidence to conclude that the overall model is significant. Use a t-test for individual significance to determine which variables are significant in predicting InfctRsk. Use a = .05. . Stay is significant in predicting InfctRsk . Culture [ Select ] significant in predicting InfctRsk . Xray [Select ] significant in predicting InfctRsk . Facilities [ Select ] significant in predicting InfctRsk . Nurses [ Select ] significant in predicting InfctRskQuiz: Discussion 11 X VA 3500-HW6-Summer - STAT 3 X VA STAT 3500, Summer 1 2024 - X - Google Password Manager + G 9% umsystem.instructure.com/courses/232514/quizzes/537613/take M 2024 Summer Semester Home D Question 3 1 pts Announcements Syllabus Checking for multicollinearity between our predictor variables, identify the pair(s) of variables which have high correlation (greater than +0.7, or smaller than -0.7). Select all that apply. 9 Modules Grades O Stay and Culture Office 365 Stay and Xray 1888 YEP MU Connect Stay and Nurses Zoom Stay and Facilities Support & Policies Culture and Xray Search ? O Culture and Nurses O Culture and Facilities O Xray and Nurses Xray and Facilities O Nurses and Facilities D Question 4 7 pts To remove the multicollinearity from our first multiple regression model, we will eliminate a variable from the model. Fit a new multiple regression model using only the variables Stay, Culture, Xray and Facilities. Perform the F-test for overall significance. Use a = .05. . The test statistic is [ Select ] , with a p-value of 2.728e-16 . ThereQuestion 4 7 pts To remove the multicollinearity from our first multiple regression model, we will eliminate a variable from the model. Fit a new multiple regression model using only the variables Stay, Culture, Xray and Facilities. Perform the F-test for overall significance. Use a = .05. . The test statistic is [ Select ] , with a p-value of 2.728e-16 There is sufficient evidence to conclude that the overall model is significant. Use a t-test for individual significance to determine which variables are significant in predicting InfctRsk. Use a = .05. . Stay is significant in predicting InfctRsk . Culture is significant in predicting InfctRsk . Xray is significant in predicting InfctRsk . Facilities is significant in predicting InfctRsk-\":',\" Quiz: Discussion 11 X W, 3500-HW6-Summer - STAT X W\\ STAT 3500, Summer 12024 X o~ Google Password Manager X + & Cc umsystem.instructure.com/courses/232514/quizzes/537613/take o a % v D .i. 2024 Summer Semester Home Announcements Syllabus L Question 5 6 pts Modules Gratles Compare the values of R? and R2 between the three models we have discussed: Office 365 R? R; @ MU Connect Regression Model (Round your answers | (Round your answers @ Zoom to 4 decimal places) | to 4 decimal places) Support & Policies From Discussion 10: Simple R?- RZ - Q |linear regression using Stay Search |(see the output printed from @ |Discussion 10 above) |From Problem 2: Multiple Erabat R - R} - regression using 5 variables: |Stay, Culture, Xray, Facilities, |and Nurses |From this Problem: New |Multiple regression using 4 R?= R-= variables: |Stay, Culture, Xray, and Facilities L Question 6 3 pts hospital (4) ID Stay Age InfectRsk Culture Xray Beds MedSchool Region Census Nurses Facilities 7.13 55.7 4.1 g 39.6 279 2 A 207 241 8.82 58.2 1. 3.8 51.7 80 2 52 40 IN 51 IN 3 8.34 56.9 2.7 8.1 74 107 3 82 IN 54 20 8.95 53.7 5.6 18.9 1 147 4 53 148 40 N 34.5 88.9 1 134 51 40 UI 11.2 56.5 5.7 180 N N 9.76 50.9 5.1 21. 150 2 147 106 40 9.68 57.8 4. 16.7 79 186 3 151 129 40 8 11.18 45.7 5.4 30.5 85.8 640 2 39 360 60 1.3 90.8 3 9 8.67 48.2 24.4 182 130 118 40 N N 10 8.84 56.3 6.3 29.6 82.6 85 1 5 40 Add a sheet. 11 11.07 53.2 1.9 28.5 122 768 1 91 56 80 12 8.3 57.2 4.3 6.8 83.8 167 2 3 105 40 13 12.78 56.8 7.7 116.9 322 1 252 349 67.1 N - 7.58 56.7 3.7 20.8 88 97 2 59 37.1 14 IN 15 3 38 9 1.2 14.6 76.4 72 61 17.1 16 11.08 50.2 5.5 18.6 63.6 387 3 IN 326 405 57.1 17 8.28 48.1 4.5 26 101.8 108 4 34 73 37.1 N N 18 11.62 53.9 6.4 25.5 99.2 133 1 113 101 37.1 37.1 IN 125 19 9.06 52.8 1.2 6.9 75.9 134 2 0 20 9.35 53.8 15.9 80.9 833 2 3 547 519 77.1 21 7.53 42 1.2 23.1 98.9 95 4 17 19 17.1 22 10.24 10 4. 36.3 112.6 195 2 163 70 37.1 23 9.78 52.3 5 17.6 95.9 270 1 1 240 198 57.1 9.84 62.2 4.8 2 82.3 600 3 468 497 57.1 IN 24 25 9.2 52.2 17.5 71.1 298 244 236 67.1 - 4 26 8.28 49.5 12 113.1 546 IN 413 436 57.1 3. 9.31 47.2 4.5 30.2 1 170 1 No 124 173 37.1 27 28 8.19 52.1 3.2 10.8 59.2 176 1 156 37.1 29 11.65 54.5 4.4 18.6 96.1 248 1 217 189 37.1 9.89 50.5 4. 17.7 103.6 167 2 113 106 37.1 30 31 11.03 49.9 5 19.7 102.1 N NN NN NN 318 1 270 335 57.1 239 54.3 32 9.84 53 5.2 17.7 72.6 210 2 200 33 11.77 54.1 5.3 17.3 56 196 1 164 165 34.3 13.59 54 6.1 24.2 111.7 312 1 258 169 54.3 34 35 3.3 170 54.3 9.74 54.4 11.4 76.1 221 2 172 54.3 36 10.33 55.8 5 21.2 104.3 266 1 81 149 9.97 58.2 2.8 16.5 76.5 90 34.3 NNN NN 2 69 12 37 38 7.84 49.1 4. 7.1 87.9 60 3 50 15 34.3 39 10.47 53.2 4.1 5.7 69.1 196 2 16 153 54.3 8.16 60.9 1.3 73 N 3 2 14.3 40 49 18 34.3 41 8.48 51.1 3.7 12.1 92.8 166 3 145 NNN 42 10.72 53.8 4.7 23.2 94.1 113 3 9 107 34.3 43 11.2 45 3 78.9 130 3 95 34.3 44 10.12 51.7 5.6 14.9 79.1 362 3 313 264 54.3 N - 45 8.37 50.7 5.5 15.1 84.8 115 2 ge 88 34.3 A 46 10.16 5 4.6 8.4 51.5 831 581 629 74.3 47 19.56 59.9 3.5 17.2 113.7 306 1 27 172 51.4 N N 48 10.9 57.2 5.5 10.6 71.9 593 2 446 211 51.4 49 7.67 51.7 1.8 2.5 40.4 106 3 93 35 11.4 8.88 51.5 4.2 10.1 86.9 305 NNN 3 238 197 51.4 50 51 11.48 57.6 5.6 20.3 32 252 1 207 251 51.4 52 9.23 4.3 11.6 42.6 620 2 413 420 71.4\f248 218 48.6 55 3.7 7.4 95.9 304 68 8.58 104 3.9 87.2 487 220 48.6 IN 69 9.61 52.4 4.5 55 28.6 70 8.03 54.2 3.5 24.3 87.3 97 2 6: 2 67 28.6 IN 38 71 7.39 51 4.2 14.6 88.4 72 56.4 87 2 52 57 28.6 72 7.08 52 2 12.3 193 18.6 73 9.53 51.5 5.2 15 65.7 298 2 241 184 1 1 144 151 68.6 74 10.05 52 4.5 36.7 87.5 2 143 124 48.6 75 8.45 38.8 3.4 12.9 35 235 2 76 2 4 79 28.6 76 48.6 4.5 3 30.8 51 86.9 52 2 1 37 35 28.6 77 8.9 2.9 12.7 68.6 78 10.23 53.2 4.9 77.9 752 1 2 59 44 48.6 79 8.88 55.8 4.4 14.1 76.8 237 2 2 165 182 45.7 N 113 73 30 10.3 59.6 5.1 27.8 88.9 175 2 2.6 461 320 65.7 2.9 56.6 1 2 196 81 10.79 44.2 92.3 195 2 2 139 116 45.7 82 7.94 49.5 3.5 6.2 83 7.63 52.1 5.5 11.6 61.1 197 2 4 109 110 45.7 143 2 4 85 37 25.7 84 8.77 54.5 4.7 5.2 47 61 45.7 35 8.09 56.9 1.7 6 56.9 92 2 3 61 20.5 79.8 195 2 3 127 112 45.7 86 9.05 51.2 4.1 65.7 87 7.91 52.8 2.9 11.9 79.5 477 2 3 349 188 223 20 65.7 88 10.39 54.6 4.3 14 88.3 353 2 45.7 89 9.36 54.1 4.8 18.3 30.6 165 2 1 127 158 35 33! 45.7 90 11.41 50.4 5.8 23.8 73 424 1 3 65 8.86 51.3 2.9 9.5 100 2 3 25.7 91 87.5 53 2 6.2 72.5 95 2 3 59 56 25.7 92 8.93 56 56 2 2 40 14 5.7 93 8.92 53.9 1.3 2.2 79.5 2 4 55 71 25.7 94 8.15 54.9 5.3 12.3 gg 5.3 15.7 89.7 154 2 2 123 148 25.7 95 9.77 50.2 2.5 27 32.5 98 2 1 57 75 45.7 96 8.54 56.1 178 177 45.7 8.66 52.8 3.8 6.8 69.5 246 2 96.9 298 2 1 237 115 45.7 98 12.01 52.8 4.8 10.8 2 3 128 42.9 99 7.95 51.8 2.3 1.6 54.9 163 568 1 3 452 371 32.9 100 10.15 51.9 6.2 16.4 59.2 4 47 55 22.9 1 9.76 53.2 2.6 80.1 64 2 11.8 108.7 190 2 1 141 112 12.9 102 9.89 45.2 4.3 50 22.9 103 7.14 57.6 2.7 13.1 92.6 92 2 4 40 15.6 133.5 356 1 308 182 62.9 104 13.95 65.9 6.6 IN 4.5 10.9 58.5 297 2 3 230 263 12.9 105 9.44 52.5 57.4 130 2 3 69 62 22.9 106 10.8 63.9 2.9 1.6 3 90 19 22.9 107 7.14 51.7 1.4 4.1 45.7 115 2 2 2 14 32 22.9 108 8.02 55 2.1 3.8 46.5 91 IN 441 469 62.9 109 11.8 53.8 5.7 9.1 116.9 571 1 2 68 46 22.9 110 9.5 49.3 5.8 12 70.9 98 4 85 136 62.9 111 7.7 56.9 4.4 12.2 67.9 129 N 791 407 $2.9 112 17.94 56.2 5.9 26.4 91.8 835 20.6 91.7 29 2 20 22 22.9 113 9.41 59.5 3.1