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

The percent of the total variance that can be explained by the regression is:

93.3%. 86.8%. 85.9%. 96.6%.

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

The Cyber Attack Survival Manual

Authors: Heather Vescent ,Nick Selby

1st Edition

1681886545, 978-1681886541

More Books

Students also viewed these Finance questions

Question

Determine the amplitude and period of each function.

Answered: 1 week ago