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, number 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 . 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 Assembly Cost Direct Labor Hours Number of boards Average Week completed cycle time $349,206 22,857 $320,829 $331,011 $300,288 22,977 $342,723 22,938 $332,538 23,295 $279,357 $340,236 23,886 $327,849 23,379 $330,210 23,196 $310,035 23,313 4,845 4,598 3,920 3,608 4,388 4,315 4,053 3,458 3,455 3,455 3,798 727.12 542.65 589.41 539.37 618.66 579.97 412.82 678.68 605.67 632.58 557.58 23,034 23,448 2 3 4 5 6 23,055 8 10 14393291482 77891026110 16023104 93745801 65735765454 7 38503558550550 5788 972283 243555 44333443333344 6002 582 3333332332 257781769 027015 676709 90 329 10842197196469 1083028045 2816709174 955 2 33222233 2345678901 45