Using the data provided in E6- 49B, the laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as follows:

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,000 tests areperformed.

Transcribed Image Text:

SUMMARY OUTPUT Regression Statistics 2 3 Multiple R 4 R Square 5 Adjusted R Square 6 Standard Error 7 Observations 8 ANOVA 0.838886 0.70373 0.644476 5S MS 10 Regrossion 11 Residual 1144650657.06 14465065706 11.876487 0.018312 60897914.37 12179582.873 6 20554857143 12 Tota 14 15 16 17 X Variable 1 Standard Lower Upper Emor 5975.992 P.value ents ntercept5627.61 6.21 0.942 3.446 0.390 0018 9734 165 2089.389 1.801 1577