The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month July August September October November December January February March April May June July Total Average Administrative Costs $ 130,301 83,413 226,180 216,794 258,463 185,449 219,937 245,600 209,862 192, 125 250,978 171,218 128,767 $2,511,087 $ 193,776 Credit Hours 1,250 635 1,912 1,520 1,829 1,632 1,859 1,893 1,584 1,643 1,880 940 835 19,412 1,493 The controller's office has analyzed the data and has given you the results from the regression analysis: SUMMARY OUTPUT Regression Statistics Multiple R 0.9085201 R Square 0.825408732 Adjusted R Square 0.809536799 Standard Error 23, 121.17056 Observations 13 ANOVA F -52.0042966 Significance F 1.72718E-05 Regression Residual Total df 1 11 12 SS MS 27,800,900,364 27,800,900,364 5,880,473, 811 534,588,528.2 33,681,374, 175 Intercept X Variable 1 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 30, 209.74624 23,570.69478 1.28166550 0.226316412 -21,669.00318 82,088.4957 109.5384452 15. 18962175 7.211400458 1.72718E-05 76.10631318 142.970577 Based on the results of the regression analysis, the estimate of the variable portion of administrative costs in a month with 200 credit hours would be: Lower 95.0% Upper 95.0% |--21,669.00318 82,088.4957 76.10631318 142.970577 $42,838. $138,867. (0) $118,419. O $21,908