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 transcribedimage text in transcribedimage 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 Administrative Costs 129, 301 82,613 225,580 216,394 258,263 184,449 219,137 245, eee 209,462 191,925 249,978 178,418 128, 167 $ 2,510,687 $ 193, 130 Credit Hours 250 115 1,392 1, eee 1,309 1,112 1,339 1,373 1,064 1,123 1,360 420 315 12,172 936 April May June July Total Average The controller's office has analyzed the data and has given you the results from the regression analysis: 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.9317157 R Square 0.868894147 Adjusted R Square 0.856102705 Standard Error 20, 134.92395 Observations 13 ANOVA F 72.3928117 Significance F 3.61909E-86 Regression Residual df 1 11 12 SS M S T 29, 349, 143,514 29,349, 143,514 4,459,566,787405,415,162.4 33,808,710, 301 Total Intercept X Variable 1 Coefficients 96,647.22398 1 03.8607697 Standard Error 1 2,641.66539 12.11283103 t Stat 7.64511883 8.588396541 P-value Lower 95% Upper 95% Lower 95.ex Upper 95.ex 1.60291E-5 68,822.98688 124,471.1419 68,822.92688 124,471.1419 3.61909E-86 76.40050833 129.720931 76.408688331 129.720931 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) Multiple Choice o $198,808. o $201,000. o $199707. o $96,409

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_2

Step: 3

blur-text-image_3

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

Cost Accounting

Authors: Srivastava Lal, Jawahar Lal

5th Edition

1259026523, 978-1259026522

More Books

Students also viewed these Accounting questions

Question

With reference to Exercise 3.74 on page 100, find cov( X, Y).

Answered: 1 week ago