Question
Problem 5-50 Interpretation of Regression Results: Multiple Choice (LO 5-5) The Business School at Eastern College is collecting data as a first step in the
Problem 5-50 Interpretation of Regression Results: Multiple Choice (LO 5-5)
The Business School at Eastern College is collecting data as a first step in the preparation of next year's budget. One cost that is being looked at closely is administrative staff as a function of student credit hours. Data on administrative costs and credit hours for the most recent 13 months follow: |
Month | Administrative Costs | Credit Hours | ||||
July | $ | 129,301 | 340 | |||
August | 82,613 | 319 | ||||
September | 228,580 | 1,532 | ||||
October | 216,394 | 1,778 | ||||
November | 258,263 | 1,905 | ||||
December | 184,449 | 1,780 | ||||
January | 219,137 | 2,119 | ||||
February | 245,000 | 3,367 | ||||
March | 209,642 | 2,786 | ||||
April | 191,925 | 1,731 | ||||
May | 249,978 | 2,144 | ||||
June | 170,418 | 858 | ||||
July | 128,167 | 571 | ||||
Total | $ | 2,513,867 | 21,230 | |||
Average | $ | 193,374 | 1,633 | |||
The controller's office has analyzed the data and given you the results from the regression analysis: |
SUMMARY OUTPUT |
Regression Statistics | |
Multiple R | .82101981 |
R Square | .674073540 |
Adjusted R Square | .644443860 |
Standard Error | 31745.13900 |
Observations | 13 |
ANOVA |
df | SS | MS | F | Significance F | |
Regression | 1 | 22926343964.00 | 22926343964.00 | 22.7500000 | .0005810 |
Residual | 11 | 11085292337 | 1007753849 | ||
Total | 12 | 34011636301.00 | |||
Coefficients | Standard Error | T Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 115556.081 | 18539.26329 | 6.23304600 | .0000641 | 74751.4168 | 156360.7449 |
Credit Hours | 47.6513400 | 9.9904477 | 4.76969017 | .0005810 | 25.6625018 | 69.6401782 |
Required: | |||||||||||
(a) | In the standard regression equation y = a + bx, the letter b is best described as the | ||||||||||
|
(b) | In the standard regression equation y = a + bx, the letter y is best described as the | ||||||||||
|
(c) | In the standard regression equation y = a + bx, the letter x is best described as the | ||||||||||
|
(d) | If the controller uses the high-low method to estimate costs, the cost equation for administrative costs is (Round variable cost per hour to four decimal places for intermediate computations. Round final answers to whole dollar value.) | ||
|
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