tion list estion 11 K Leigh Preston is the Chief Operating Officer at Unity Hospital in Charleston, South Carolina. She is analyzing the hospital's overhead costs but is not sure whether nursing hours or the number of patient days would be the best cost driver to use for predicting the hospital's overhead Overhead Cost per Overhead Cost per Nursing Hour Patient Day Requirements She has gathered the following information for the last six months of the most recent year (Click the icon to view the information) 1. Are the hospitals overhead costs fixed, variable, or mixed? Explain 2. Graph the hospitals overhead costs against nursing hours 3. Graph the hospitals overhead costs against the number of patient days 4. Do the data appear to be sound, or do you see any potential data problema? Explain 5. Use the high-low method to determine the hospital's cost equation using nursing hours as the cost driver Predict total overhead costs if 24,000 nursing hours are predicted for the month Preston runs a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs The Excel output from the regression analysis follows. If 24.000 nursing hours are predicted for the month, what is the total predicted hospital overhead? bestion 2 Data table uestion 3 Hospital Number of Month Overhead Nursing Costs Patient Hours Days Question 4 July August 481,000 23.500 3,700 $ 20 47 $ 130.00 5 530,000 27,000 4,350 $ 1963 S 121 September 5 Question 5 October November December 415.000 18.500 $ 400,000 22.000 $ 4,100 $ 22435 9905 3.440 $ 20.91 S 133.72 5.700 565.000 30.500 $ 440.000 19.500 $ 16.52 $ 99.12 3.240 $ 22.56 $ 135 60 2 Mule R 0005023 0901863 5 Add R Square 0989820 Print Done Standard Emor 5692.915797 7 Observations D 1 SUMMARY OUTPUT-Nursing hours as cost driver Regression Statistic + Help me solve this Video Get more help ANOVA . 55 10 Regression Significance MS " 115.801.196.172/15.801.196,172) 7.551441 0.000025 Print Done