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,301 250
August 82,613 115
September 225,580 1,392
October 216,394 1,000
November 258,263 1,309
December 184,449 1,112
January 219,137 1,339
February 245,000 1,373
March 209,462 1,064
April 191,925 1,123
May 249,978 1,360
June 170,418 420
July 128,167 315
Total $ 2,510,687 12,172
Average $ 193,130 936

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.868094147
Adjusted R Square 0.856102705
Standard Error 20,134.92395
Observations 13

ANOVA
df SS MS F Significance F
Regression 1 29,349,143,514 29,349,143,514 72.3928117 3.61909E-06
Residual 11 4,459,566,787 405,415,162.4
Total 12 33,808,710,301

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 96,647.02398 12,641.66539 7.64511803 1.00291E-05 68,822.90608 124,471.1419 68,822.90608 124,471.1419
X Variable 1 103.0607697 12.11283103 8.508396541 3.61909E-06 76.40060833 129.720931 76.40060833 129.720931

If the controller uses regression analysis to estimate costs, the cost equation for administrative salaries is:

Cost = $19,943.58 + $13.00 Credit-hours.

Cost = $12,521.26 + $11.99 Credit-hours.

Cost = $69,474.40 + $114 30 Credit-hours.

Cost = $96,647.02 + $103.06 Credit-hours.

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

Knowledge Based System For Information System Audit

Authors: Amol B. Devale, R. V. Kulkarni

1st Edition

6200652376, 978-6200652379

More Books

Students also viewed these Accounting questions