Question: A 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
A 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 | Administrative Costs | Credit Hours | ||||
| July | $ | 130,051 | 1,000 | |||
| August | 83,213 | 505 | ||||
| September | 226,030 | 1,782 | ||||
| October | 216,694 | 1,390 | ||||
| November | 258,413 | 1,699 | ||||
| December | 185,199 | 1,502 | ||||
| January | 219,737 | 1,729 | ||||
| February | 245,450 | 1,763 | ||||
| March | 209,762 | 1,454 | ||||
| April | 192,075 | 1,513 | ||||
| May | 250,728 | 1,750 | ||||
| June | 171,018 | 810 | ||||
| July | 128,617 | 705 | ||||
| Total | $ | 2,510,987 | 17,602 | |||
| Average | $ | 193,614 | 1,354 | |||
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.9215426 |
| R Square | 0.849240681 |
| Adjusted R Square | 0.835535288 |
| Standard Error | 21,494.88332 |
| Observations | 13 |
| ANOVA | |||||
| df | SS | MS | F | SignificanceF | |
| Regression | 1 | 28,629,218,422 | 28,629,218,422 | -61.9639804 | 7.61493E-06 |
| Residual | 11 | 5,082,330,099 | 462,030,009.0 | ||
| Total | 12 | 33,711,548,521 |
| Coefficients | Standard Error | t-Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 45,381.11 | 19,752.25 | 2.29 | 0.042 | 1,906.68 | 88,855.53 | 1,906.68 | 88,855.53 |
| X Variable | 109.48 | 13.907 | 7.87 | 0.001 | 78.86 | 140.08 | 78.86 | 140.08 |
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:
Group of answer choices
$153,978.
$21,896.
$118,407.
$42,814.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
