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

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 Administrative Costs Credit Hours
July $ 129,351 300
August 82,653 141
September 225,610 1,418
October 216,414 1,026
November 258,273 1,335
December 184,499 1,138
January 219,177 1,365
February 245,030 1,399
March 209,482 1,090
April 191,935 1,149
May 250,028 1,386
June 170,458 446
July 128,197 341
Total $ 2,511,107 12,534
Average $ 193,162 964

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.9321989
R Square 0.868994839
Adjusted R Square 0.857085279
Standard Error 20,062.49314
Observations 13

ANOVA
df SS MS F Significance F
Regression 1 29,369,143,334 29,369,143,334 -72.9661575 3.48374E-06
Residual 11 4,427,539,941 402,503,631.0
Total 12 33,796,683,275

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 93,173.64480 12,960.70790 7.18893177 1.77759E-05 64,647.31905 121,699.9705 64,647.31905 121,699.9705
X Variable 1 103.7058894 12.14067077 8.542023033 3.48374E-06 76.98445319 130.427326 76.98445319 130.427326

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)

Multiple Choice

  • $198,193.

  • $93,602.

  • $196,884.

  • $196,001.

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 Proofing Your Return

Authors: Jr. Wade, Jack Warren

1st Edition

002622240X, 978-0026222402

More Books

Students also viewed these Accounting questions

Question

a. What are the mean and variance of depth?

Answered: 1 week ago

Question

c. What were the reasons for their move? Did they come voluntarily?

Answered: 1 week ago

Question

5. How do economic situations affect intergroup relations?

Answered: 1 week ago