Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that

image text in transcribed
image text in transcribed
image text in transcribed
The College of Business at Northeast 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 July August September October November December January February March April May June July Total Average Administrative Costo $ 129,601 82,853 225, 760 216,514 258,323 184, 749 219,377 245,180 209,582 191,985 250, 278 170,658 128, 347 $2,513,207 $ 193, 324 Credit Hours 550 271 1,548 1,156 1,465 1,268 1,495 1,5294 1,220 1,279 1,516 576 471 14,344 1,103 The controller's office has analyzed the data and has given you the results from the regression analysis SUMUARY OUTPUT Regression Statistics Multiple R 0.9323308 R Square 0.869240766 Adjusted R Square 0.857353563 Standard Error 20.034.60265 Observations 13 ANOVA Significance F 3.44752E-06 -73.1240781 Regression Residual Total df 1 11 12 SS MS 29,350,930,283 350,930,283 4,415,238,338 401,385,303.5 33,766,168,621 Intercept X Variable 1 Coefficients Standard Error t Stat P-value Lower 951 Upper 951 Lower 95.01 Upper 95.0 75, 742.91080 14,830.40938 5.10727040 0.00034016243,101.39984 108,384.4218 43, 101.39984 108,384.421 106.5636614 12.46174706 8.551261785 3.44752E-06 79.13554108 133.991782 79.13554108 133.9917 Based on the results of the regression analysis, the estimate of administrative costs in a month with 1000 credit hours would be: rounded to the nearest whole dollar) Based on the results of the regression analysis, the estimate of administrative costs in a month with 1000 credit hours would be (rounded to the nearest whole dolan Multiple Choice $182 303 579,021 $183.632 S181420

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Audit Effectiveness Meeting The IT Challenge

Authors: Kamil Omoteso

1st Edition

1409434680, 9781409434689

More Books

Students also viewed these Accounting questions