Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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,685 227
August 83,198 214
September 225,561 1,399
October 216,347 953
November 258,171 1,272
December 184,687 1,254
January 218,933 1,370
February 244,930 1,315
March 210,117 1,106
April 192,480 1,072
May 250,691 1,362
June 170,121 627
July 128,421 281
Total $ 2,513,342 12,452
Average 193,334 958

The controller's office has analyzed the data and has given you the results from the regression analysis:

Regression Statistics
Multiple R 0.9128329
R Square 0.833263830
Adjusted R Square 0.818105996
Standard Error 22,591.28975
Observations 13

Anova
df SS MS F Significance F
Regression 1 28,056,109,284 28,056,109,284 54.9724880 1.33561E-05
Residual 11 5,614,030,098 510,366,372.6
Total 12 33,670,139,382

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper
Intercept 92,503.10785 14,973.43063 6.17781657 6.92947E-05 59,546.80927 125,459.4064 59,546.80927 125,459.4064
X Variable 1 105.2683583 14.19793402 7.414343395 1.33561E-05 74.01891627 136.517800 74.01891627 136.517800

Based on the results of the regression analysis, the estimate of administrative costs in a month with 1,000 credit hours would be: (rounded to the nearest whole dollar)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions