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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!