Requirements Number of Lab Tests Performed 3,300 3,200 3,450 3,900 3,850 2,100 2,650 Total Laboratory Use Excel to do the following: 1. Run a regression analysis using data for August through February 21,550 s 22,300 24,500 27,600 s 27,400 s 20,300 $ 22,000 Determine the lab's cost equation (use the output from the regression analysis you performed using Excel). Determine the R-square using the Excel output you obtain. What does the lab's R-square indicate? Predict the lab's total overhead costs for the month if 2,700 tests are performed. 2. 3. 4. September December... Print Done