The Business School at Eastern 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 Costs Hours July $ 129,685 227 August 83,198 214 September 225,561 1,399 October 216,347 953 November 258,171 1,272 December 184,687 1,254 January 218,933 1,370 February 244,930 1,315 March 210,117 1,106 April 192,480 1,072 May 250,691 1,362 June 170,121 627 July 128,421 281 Total $ 2,513,342 12,452 Average 193,334 958 The controller's office has analyzed the data and has given you the results from the regression analysis Regression Statistics Multiple R 0 9128329 R Square 0 833263830 Adjusted R Square 0 818105996 Standard Error 22,591 28975 Observations 13 Anova df SS MS F Significance F Regression 1 28,056,109,284 28,056,109,284 54 9724880 1 33561E 05 Residual 11 5,614,030,098 510,366,372 6 Total 12 33,670,139,382 Coefficients Standard Error t Stat P value Lower 95 Upper 95 Lower 95 0 Upper Intercept 92,503 10785 14,973 43063 6 17781657 6 92947E 05 59,546 80927 125,459 4064 59,546 80927 125,459 4064 X Variable 1 105 2683583 14 19793402 7 414343395 1 33561E 05 74 01891627 136 517800 74 01891627 136 517800 Based on the results of the regression analysis, the estimate of administrative costs in a month with 1,000 credit hours would be (rounded to the nearest whole dollar)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 30, 2024

The Business School at Eastern College is accumulating data as a first step in the preparation of next year's budget development. One cost that is

The Business School at Eastern 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	Costs	Hours
July	$ 129,685	227
August	83,198	214
September	225,561	1,399
October	216,347	953
November	258,171	1,272
December	184,687	1,254
January	218,933	1,370
February	244,930	1,315
March	210,117	1,106
April	192,480	1,072
May	250,691	1,362
June	170,121	627
July	128,421	281

Total	$ 2,513,342	12,452
Average	193,334	958

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

Regression Statistics
Multiple R	0.9128329
R Square	0.833263830
Adjusted R Square	0.818105996
Standard Error	22,591.28975
Observations	13

Anova

	df	SS	MS	F	Significance F
Regression	1	28,056,109,284	28,056,109,284	54.9724880	1.33561E-05
Residual	11	5,614,030,098	510,366,372.6
Total	12	33,670,139,382

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper
Intercept	92,503.10785	14,973.43063	6.17781657	6.92947E-05	59,546.80927	125,459.4064	59,546.80927	125,459.4064
X Variable 1	105.2683583	14.19793402	7.414343395	1.33561E-05	74.01891627	136.517800	74.01891627	136.517800

Based on the results of the regression analysis, the estimate of administrative costs in a month with 1,000 credit hours would be: (rounded to the nearest whole dollar)