Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

d3 The College of Business at Northeast College is accumulating data as a first

ID: 2597430 • Letter: D

Question

d3

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:



The controller's office has analyzed the data and has given you the results from the regression analysis:

  
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:

a. $198,808.

b. $20,612.

c. $117,121.

d. $40,242.

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

Explanation / Answer

Solution:

Option C is correct.

The regression equation is

Administrative costs = 96,647.02398 + 103.06 Credit hours

When Credit hours = 200, the administrative costs would be

Administrative costs = 96,647.02 + 103.06 (200)

Administrative costs = $117,121