The manager of the main laboratory facilty at Metrofis Center is imlerested in being able to predict the overthead costs each month for the lab. The manager believes that total cverthead varies with the number of lab tests performed but that some costs remain the same each month regardless of the number of lab tests performed. The lab manager collected the foliowing data for the first seven months of the year. (Click the icon to view the data) The laboratory manager pecforned a tegression analysis to predict total laboratory everfead cests. The output generated by Encel is as follows (Click the icon to view the compleded regression analysis.) Read the teckitements. Requirement 1. Delermine the lab's cost equation (use the output from the Excel regression). (Round the ambunts to twe decimal places) y=x+ Data table Requirements 1. Determine the lab's cost equabon (use the eutput from the Excel regression). 2. Determine the R-squared (use the oufpu trom the Excel regrestion) 3. Predict the bots laboratory overthead for the moneh if 3,100 lests are performed. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & \multicolumn{3}{|c|}{ SUMMARY OUTPUT } & x & & & \\ \hline 2 & \multicolumn{3}{|c|}{ Regression Statistics } & & & & . \\ \hline 3 & Multiple R & & 0.880534 & & & & \\ \hline 4 & R Square & & 0.77534 & & & & \\ \hline 5 & Adjusted R Squ & & 0.730408 & 7 & & +1 & - \\ \hline 6 & Standard Error & & 1868.82221 & a & & & \\ \hline 7 & Observations & & 7 & & & s. & % \\ \hline 8 & ANOVA & & s. & & & , & \\ \hline 9 & & df & ss & MS & F & Significance F & . \\ \hline 10 & Regression & 1 & 60266089.17 & 60266089.17 & 17.255877 & 0.008875 & \\ \hline 11 & Residual & 5 & 17462482.26 & 3492496.451 & & : & \\ \hline 12 & Total & 6 & 77728571,43 & 8. & . & * & s. \\ \hline 13 & & Coefficients & Standard Error & t Stat & P-value & Lower 95% & Upper 95% \\ \hline 14 & Intercept & 14409.92 & 2688.513 & \begin{tabular}{r} 5.360 \\ \end{tabular} & 0.003 & 7498.876 & 21320.960 \\ \hline 15 & 5 Variable 1 & 3.92 & 0.943 & 4.154 & 0.009 & 1.494 & 6.343 \\ \hline \end{tabular}