Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Accounting questions

Question

Differentiate between classical and operant conditioning.

Answered: 1 week ago