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 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 July August September October November December January February March Administrative Costs 129, 301 82,613 225,580 216,394 258,263 184,449 219,137 245, eee 209,462 191,925 249,978 178,418 128, 167 $ 2,510,687 $ 193, 130 Credit Hours 250 115 1,392 1, eee 1,309 1,112 1,339 1,373 1,064 1,123 1,360 420 315 12,172 936 April May June July Total Average The controller's office has analyzed the data and has given you the results from the regression analysis: 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.868894147 Adjusted R Square 0.856102705 Standard Error 20, 134.92395 Observations 13 ANOVA F 72.3928117 Significance F 3.61909E-86 Regression Residual df 1 11 12 SS M S T 29, 349, 143,514 29,349, 143,514 4,459,566,787405,415,162.4 33,808,710, 301 Total Intercept X Variable 1 Coefficients 96,647.22398 1 03.8607697 Standard Error 1 2,641.66539 12.11283103 t Stat 7.64511883 8.588396541 P-value Lower 95% Upper 95% Lower 95.ex Upper 95.ex 1.60291E-5 68,822.98688 124,471.1419 68,822.92688 124,471.1419 3.61909E-86 76.40050833 129.720931 76.408688331 129.720931 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) Multiple Choice o $198,808. o $201,000. o $199707. o $96,409
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