HospitalNursingNumber ofOverhead CostOverhead CostMonthOverhead CostsHoursPatient Daysper Nursing Hourper Patient DayJuly . . . . . . . .$485,00025,0003,800$19.40$127.63August . . . . . .$540,00026,7004,360$20.22$123.85September . .$420,00020,0004,210$21.00$99.76October . . . . .$462,00021,9003,450$21.10$133.91November . . .$579,00032,0005,600$18.09$103.39December . . .$455,00020,4003,270$22.30$139.14Regression StatisticsMultiple R0.967848R Square0.93673Adjusted R Square0.920913Standard Error16,568.3268Observations6Save Accounting Table+ Copy to Clipboard+ AnovadfSSMSFSignificance FRegression116,256,795,52116,256,795,52159.2212590.001534Residual41,098,037,812274,509,453Total517,354,833,333Save Accounting Table+ Copy to Clipboard+ CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept187,378.9839,923.0614.6940.00976,534.789298,223.164X Variable 112.441.6177.6960.0027.95416.933If 25,500 nursing hours are predicted for the? month, what is the total predicted
hospital? overhead?If 3,640 patient days are predicted for the? month, what is the total
predicted hospital? overhead?Which
regression analysis? (using nursing hours
or using number of patient days as the cost? driver) produces the
best cost? equation? Explain your answer