Answered step by step
Verified Expert Solution
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
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: Administrative Credit Month July Costs Hours $ 129,401 350 August 82,693 167 September 225,640 1,444 October 216,434 1,052 November 258,283 1,361 December 184,549 1,164 January 219,217 1,391 February 245,060 1,425 March 209,502 1,116 April 191,945 1,175 May 250,078 1,412 June 170,498 472 July 128,227 367 Total $2,511,527 12,896 Average $ 193,194 992 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.9325327 R Square 0.869617326 Adjusted R Square 0.857764356 Standard Error 20,012.96157 Observations 13 ANOVA df SS MS F Significance F Regression Residual 11 Total 1 29,384,865,682 29,384,865,682 4,405,704,939 400,518,630.8 12 33,790,570,621 -73.3670382 3.39266E-06
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started