Paste Calibri (Body]14 -A A Aa A E. A 21 BIU ab *, * A-D-A- Font Paragraph AaBbced Aabbcc AaBbc AaBbcel Aab T Normal 1 No Spax.... Heading 1 Heading 2 Title Orind - Replace Select Dictate Semily Editor Clipboard Styles Editing Vice Sentity Editor Multiple Repression Graded Problems 2) Use the data from hosplabdx (Module , Bowermane Data File links, Chapter 15, data description an pages 549-650 of text) to do the towing m. Based on the matrix plot below Which predictor has the weakest relationship with labor hours? De any of the predictors appear to be correlated? XRay .. BedDays Length aborHour . b. Obtain the correlation matrix for the three predictors. Does multicollinearity appear to be an issue? Why or why not? Give the regression equation with id, 2, and x3 as predictors, d. Is the normality assumption reasonable? Why? e is the constant variance assumption reasonable? Why? t is the equation valid? Answer formally with a hypothesis test Give and interpret each slope. Be specific h. Give and interpret the coefficient of determination Use the regression equation to give a point estimate of the monthly labor hours required at a Nuvy hospitant the number of monthly X-ray expesures is 52,000, monthly accupied bed-day is 15.000, and the average length of patient stay 6.2 days ] Predict, with 95% confidence, the mean monthly labor hours required across all Navy hospitals where the number of monthly X-ray exposures is 52,000, monthly occupied bed days is 15.000, and the average length of patient stay s6 7 days. Inter the interval * Predict, with 95% confidence, the monthly labor hours required at a Navy hospital if the number of monthly X-ray exposures is 52,000, monthly occupied bed-days is 15,000, and the weageength of patient stays 2 der Interpret the interval Focus BA 461 words O HH Type here to search 11 492 10 18 OD CA Editing Paragraph Styles 1) Use the data from hosplab.xlsx (Module 0, Bowermanse Data File links, Chapter 15, data description on pages 649-650 of text) to do the following a. Based on the matrix plot below i. Which predictor has the weakest relationship with labor hours? it. Do any of the predictors appear to be correlated? . XRay LA BedDays . Length 19 .. abor Hours om b. Obtain the correlation matrix for the three predictors. Does multicollinearity appear to be an issue? Why or why not? Give the regression equation with x1, x2, and x3 as predictors. d is the normality assumption reasonable? Why? e is the constant variance assumption reasonable? Why? F. Is the equation valid? Answer formally with a hypothesis test. E Give and interpret each slope Be specific h. Give and interpret the coefficient of determination Use the regression equation to give a point estimate of the monthly Tabor hours required at a Navy hospital if the number of monthly X- rav exsosures is 52.000 monthlv occupied bed-davs is 15.000 and D Foco BE 9 16 22 18 f10 69 611 O/ EX 412 3) pause brook prt sc sys deler A & C 7 8 9 o boch { T Y P [ G H J AutoSave - Hosplab. Read-Only Fe Home insert Page Layout Formulas Data Review View Help Aral -12 7 1 Wrap Text IU- A Merge Center - $% 18 To Clipboard Font Alignment Number PRIVACY SETTINGS APPLIED Your account privacy settings are being applied to this device to adjust your settings go to privacy settings F4 LaborHours ! 4 B C 4 Hospital XRay (x1) 5 1 2463 6 2 2048 3 3940 8 4 6505 9 5 5723 10 6 11520 7 5779 12 8 5969 13 9 8461 14 10 20106 15 11 13313 16 12 10771 17 13 15543 18 14 34703 19 15 39204 20 16 86533 Sheett Sheet Sheets Station and Etiootste Type here to search D BedDays (x2) 472.92 1339.75 620.25 568.33 1497.60 130583 1687.00 1639.92 2872 33 3655.08 2912 00 3921 00 3065.67 12446 33 14098.40 1552400 Length (x3) 143 6.92 4.28 3.90 5.50 4.60 502 5.15 6.18 6.15 5.88 488 5.50 10.78 7.05 6,35 LaborHours (y) JC6.52 606 82 1033 15 1603.62 181137 1813:27 1854.17 2100.55 2305.58 3503.93 357189 3741 40 4026 52 11732 17 15414 94 18851.15 o OD 7 2 3 4 5 9 W E R T U A S D F G H J Z X V B N M alt Paste Calibri (Body]14 -A A Aa A E. A 21 BIU ab *, * A-D-A- Font Paragraph AaBbced Aabbcc AaBbc AaBbcel Aab T Normal 1 No Spax.... Heading 1 Heading 2 Title Orind - Replace Select Dictate Semily Editor Clipboard Styles Editing Vice Sentity Editor Multiple Repression Graded Problems 2) Use the data from hosplabdx (Module , Bowermane Data File links, Chapter 15, data description an pages 549-650 of text) to do the towing m. Based on the matrix plot below Which predictor has the weakest relationship with labor hours? De any of the predictors appear to be correlated? XRay .. BedDays Length aborHour . b. Obtain the correlation matrix for the three predictors. Does multicollinearity appear to be an issue? Why or why not? Give the regression equation with id, 2, and x3 as predictors, d. Is the normality assumption reasonable? Why? e is the constant variance assumption reasonable? Why? t is the equation valid? Answer formally with a hypothesis test Give and interpret each slope. Be specific h. Give and interpret the coefficient of determination Use the regression equation to give a point estimate of the monthly labor hours required at a Nuvy hospitant the number of monthly X-ray expesures is 52,000, monthly accupied bed-day is 15.000, and the average length of patient stay 6.2 days ] Predict, with 95% confidence, the mean monthly labor hours required across all Navy hospitals where the number of monthly X-ray exposures is 52,000, monthly occupied bed days is 15.000, and the average length of patient stay s6 7 days. Inter the interval * Predict, with 95% confidence, the monthly labor hours required at a Navy hospital if the number of monthly X-ray exposures is 52,000, monthly occupied bed-days is 15,000, and the weageength of patient stays 2 der Interpret the interval Focus BA 461 words O HH Type here to search 11 492 10 18 OD CA Editing Paragraph Styles 1) Use the data from hosplab.xlsx (Module 0, Bowermanse Data File links, Chapter 15, data description on pages 649-650 of text) to do the following a. Based on the matrix plot below i. Which predictor has the weakest relationship with labor hours? it. Do any of the predictors appear to be correlated? . XRay LA BedDays . Length 19 .. abor Hours om b. Obtain the correlation matrix for the three predictors. Does multicollinearity appear to be an issue? Why or why not? Give the regression equation with x1, x2, and x3 as predictors. d is the normality assumption reasonable? Why? e is the constant variance assumption reasonable? Why? F. Is the equation valid? Answer formally with a hypothesis test. E Give and interpret each slope Be specific h. Give and interpret the coefficient of determination Use the regression equation to give a point estimate of the monthly Tabor hours required at a Navy hospital if the number of monthly X- rav exsosures is 52.000 monthlv occupied bed-davs is 15.000 and D Foco BE 9 16 22 18 f10 69 611 O/ EX 412 3) pause brook prt sc sys deler A & C 7 8 9 o boch { T Y P [ G H J AutoSave - Hosplab. Read-Only Fe Home insert Page Layout Formulas Data Review View Help Aral -12 7 1 Wrap Text IU- A Merge Center - $% 18 To Clipboard Font Alignment Number PRIVACY SETTINGS APPLIED Your account privacy settings are being applied to this device to adjust your settings go to privacy settings F4 LaborHours ! 4 B C 4 Hospital XRay (x1) 5 1 2463 6 2 2048 3 3940 8 4 6505 9 5 5723 10 6 11520 7 5779 12 8 5969 13 9 8461 14 10 20106 15 11 13313 16 12 10771 17 13 15543 18 14 34703 19 15 39204 20 16 86533 Sheett Sheet Sheets Station and Etiootste Type here to search D BedDays (x2) 472.92 1339.75 620.25 568.33 1497.60 130583 1687.00 1639.92 2872 33 3655.08 2912 00 3921 00 3065.67 12446 33 14098.40 1552400 Length (x3) 143 6.92 4.28 3.90 5.50 4.60 502 5.15 6.18 6.15 5.88 488 5.50 10.78 7.05 6,35 LaborHours (y) JC6.52 606 82 1033 15 1603.62 181137 1813:27 1854.17 2100.55 2305.58 3503.93 357189 3741 40 4026 52 11732 17 15414 94 18851.15 o OD 7 2 3 4 5 9 W E R T U A S D F G H J Z X V B N M alt