ine college of Business at Northeast college is accumulating data as a first step in the preparation of next years Duaget 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 Administrative Costs $ 129,801 83,013 225,880 216,594 258, 363 184,949 219,537 245, 380 209,662 192,825 258,478 170,818 128,467 $ 2,514,887 $ 193,453 Credit Hours 750 375 1,652 1,260 1,569 1,372 1,599 1,633 1,324 1,383 1,620 680 575 15,792 1,215 June July Total Average SUMMARY OUTPUT Regression Statistics Multiple R 0 .9294251 R Square 0.863831106 Adjusted R Square 0.851452116 Standard Error 20,437.46479 Observations 13 ANOVA I F -69.7820323 Significance F 4 .3198E-6 Regression Residual Total df SS MS 1 29,147,254,770 29, 147, 254,770 114 ,594,589,636 417,689,966.9 12 33,741,844,406 Intercept X Variable 1 Coefficients Coefficients 61,941.91529 61,941.91529 108.2680115 108.2600115 Standard Error Standard 16,732.45219 16 1 2.95973920 12.95973920 t Stat 3.70199302 8.39 8.353564849 P-value Lower 95% Upper 95% Low 0.00349801925, 114.03632 98,769.7943 25,1 4.3198E-06 79.73581782 136.784205 79. The percent of the total variance that can be explained by the regression is: Significance F 4.3198E-6 -69.7820323 54,770 ,966.9 t Stat 3.70190302 .3535640491 P-value Lower 95% Upper 95% Lower 95.0% 0.00349001925, 114.03632 98,769.794325, 114.03632 4.3198E-06 79.73581782 136.784205 79.73581782 Upper 95.0% 98,769.7943 136.784205 accinnie