$5.$ Refer to the eight weeks of actual data included on the $$Regression Analysis$$ tab of the Excel workbook.

Working in Excel, use least$-$squares regression to estimate the fixed electrical cost per week and the variable electrical cost per machine$-$hour. $($You can refer to Appendix $5$A of the text for a brief illustration of the method being used to perform the regression computations.$)$

What is the R$2$R$-$squared for the regression line in requirement $5$a$?$

What does the R$2$R$-$squared tell us$?$

If the company continues to use direct labor$-$hours to allocate electrical costs to jobs, what impact will it have on the perceived profitability of Job Q$400?$