Question
The Business School at Eastern College is accumulating data as a first step in the preparation of next year's budget development. One cost that is
The Business School at Eastern 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:
| Administrative | Credit |
Month | Costs | Hours |
July | $ 129,605 | 281 |
August | 82,159 | 52 |
September | 226,012 | 1,424 |
October | 216,192 | 960 |
November | 258,364 | 1,361 |
December | 184,829 | 1,119 |
January | 218,798 | 1,374 |
February | 244,962 | 1,365 |
March | 209,739 | 1,092 |
April | 192,109 | 1,076 |
May | 250,123 | 1,420 |
June | 170,073 | 355 |
July | 128,483 | 269 |
|
|
|
Total | $ 2,511,448 | 12,148 |
Average | 193,188 | 934
|
The controller's office has analyzed the data and has given you the results from the regression analysis:
Regression Statistics | |
| |
Multiple R | 0.9337190 |
R Square | 0.871831217 |
Adjusted R Square | 0.860179510 |
Standard Error | 19,865.27215 |
Observations | 13 |
Anova |
| df | SS | MS | F | Significance F |
Regression | 1 | 29,527,853,657 | 29,527,853,657 | 74.8243308 | 3.08442E-06 |
Residual | 11 | 4,340,919,414 | 394,629,037.6 |
|
|
Total | 12 | 33,868,773,071 |
|
|
|
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper |
Intercept | 101,985.17690 | 11,896.35558 | 8.57280838 | 3.36461E-06 | 75,801.47477 | 128,168.8789 | 75,801.47477 | 128,168.8789 |
X Variable 1 | 97.5996626 | 11.28305995 | 8.650105826 | 3.08442E-06 | 72.76581509 | 122.433510 | 72.76581509 | 122.433510 |
If the controller uses regression analysis to estimate costs, the estimate of the variable portion of administrative salaries is: |
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