Select a cell to the right of the provided data on the Data and Solution tab, label the cell "MH analysis" and highlight it green, complete the "high/low" method near this cell and write out the cost formula using Machine-hours as the cost driverNear the cell you labeled "MH Analysis" complete the regression analysis using Machine-hours as the cost driver independent variable and Support Overhead Costs as the dependent variableOn the regression output, highlight the cells containing R-square value, the intercept, and slope variable 1 in greenInclude the scatterplot with trend line for the analysis you completed in step 11, change the color of the trend line to green, extend the trend line to the left 1000 units and to the right 1000 unitsSelect a cell to the right of the provided data and below the Machine-hours section your created, name the cell "Batches analysis", complete the "high/low" method and write out the cost formula using Number of batches as the cost driverNear the cell you labeled "Batches Analysis" Complete the regression analysis using Number of batches as the cost driver independent variable and Support Overhead Costs as the dependent variableOn the regression output, highlight the cells containing R-square value, the intercept, and slope variable 1 in blueInclude the scatterplot with trend line for the analysis you completed in step 15, change the color of the trend line to blue, extend the trend line to the left 1000 units and to the right 1000 units