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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started