Using the data provided in E6- 30A, 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 2,800 tests areperformed.

UMMARY OUTPUT Regression Statistics 0.92398 0.853738 0.824486 3 Mutiple R 4 RSquare 5 Adjusted R Square 6 Standard Error 7 Observations 8 ANOVA MS SignificanceF 10 Regression 11 Residual 12 Total 13 14 1 138303137.57 13830313757 29.185259 0.002937 5 2369400529 4738801058 Standad LowerUpper 95% Coericiens Eror t Sot Pydue 95% 6 Intercept X Variable1 18 10637 34 2932412 0.914 3.628 5.402 00153099.339 18175.349 2.589 4.94 0.003 7.289