Chapter 6 Homework ACG2071-21Summer B002 Homework: Chapter 6 Homework Score: 0 of 4 pts E6-33A (similar to) The manager of the main laboratory facility at Capital Health Center is interested in being able to predict the o costs each month for the lab. The manager believes that total overhead varies with the number of lab tests pe that some costs remain the same each month regardless of the number of lab tests performed. The lab mana collected the following data for the first seven months of the year. (Click the icon to view the data.) Requirement 1. Determine the lab's cost equation (use the output from the Excel regression). (Round the amo 3187.5 ya 7.25 x + Enter any number in the edit fields and then click Check Answer B (6 complete) d The laboratory manager performed a regression analysis to predict total labor ed but generated by Excel is as follows: (Click the icon to view the completed regression analysis.) Read the requirements to two decimal places.) Clear All Number of Lab Tests Performed 3,300 Total Laboratory Overhead Costs Month $28,900 January . February ... March ...... 3,150 $28,300 4,100 $32,500 April May 4,250 4,500 1,500 $34,000 $29,900 $17,000 June ...... July 1,700 $15,500 Print Done Clear All 7 of 8 (6 complete) Data Table B A E D F 1 SUMMARY OUTPUT 2 Regression Statistics 4799 0.898685 0.878422 3 Multiple R 4 R Square 5 Adjusted R Square 6 Standard Error 7 Observations 8 ANOVA 2562.300148 7 9 df SS MS F Significance F 0.001152 10 Regression 1 291181661.19 44 351061 11 Residual 5 291181661.19 32826910.24 324008571,43 6565382.048 12 Total 6 13 Coefficients Standard Error 1 Star P-value Lower 95% Upper 95% 15623.652 8047.25 2947.351 2.730 0.041 470.840 14 Intercept 15 X Variable 1 5.77 0.866 6.660 0.001 3.541 7994 Print Done Clear All MacBook Pro % &