Cost be 31A Using regression analysis output to predict overhead for a hospital laboratory (Learning Objective 5) using the data provided in E6-29A, the laboratory manager performed a regression analysis predict total laboratory overhead costs. The output generated by Excel is as follows: A B C D SUMMARY OUTPUT G Regression Statistics Multiple R 0.878214 R Square 0.77126 Adjusted R Square 0.725512 5 Standard Error 3156.338706 6 Observations 7 8 ANOVA df SS MS F 9 Significance F 10 Regression 1 167956201.28 167956201.28 16.858885 0.009301 11 Residual 5 49812370.15 9962474.03 12 Total 6 217768571.43 13 Standard 14 Coefficients Error Lower Upper 15 t Stat P-value 16 Intercept 3187.94 95% 5092.169 95% 0.626 0.559 6.84 -9901.898 16277.778 17 X Variable 1 1.666 4.106 0.009 2.558 11.123 18 Requirements 1. Determine the lab's cost equation (use the output from the Excel regression). 2. Determine the R-square (use the output from the Excel regression). 3. Predict the total laboratory overhead for the month if 3,100 tests are performed