Circuit Board Problem (20 points) A circuit board manufacturer is trying to determine the appropriate cost driver for estimating the cost of circuit board assembly support. The list of potential cost drivers has been narrowed to three: direct labor hours, nu ber of circuit boards completed, and average cycle time. In preparation for a simple linear regression analysis, a data collection activity has been completed. The results of the data collection are shown on the following page and are contained in the Excel spreadsheet circuitboard_data.xls on the class D2L web site. Use the data in this spreadsheet to determine a regression line for each of the three possible cost drivers. 0 For each possible driver, (1) plot a graph of the cost driver versus the support cost, (2) determine and clearly state the regression equation and (3) determine and clearly state the associated R2 Which driver to you recommend? What percentage of the data does your driver and regression equation explain? . . Circuit Board Problem (20 points) A circuit board manufacturer is trying to determine the appropriate cost driver for estimating the cost of circuit board assembly support. The list of potential cost drivers has been narrowed to three: direct labor hours, nu ber of circuit boards completed, and average cycle time. In preparation for a simple linear regression analysis, a data collection activity has been completed. The results of the data collection are shown on the following page and are contained in the Excel spreadsheet circuitboard_data.xls on the class D2L web site. Use the data in this spreadsheet to determine a regression line for each of the three possible cost drivers. 0 For each possible driver, (1) plot a graph of the cost driver versus the support cost, (2) determine and clearly state the regression equation and (3) determine and clearly state the associated R2 Which driver to you recommend? What percentage of the data does your driver and regression equation explain