Methods of Estimating Costs: Scattergraph: For the following dataset:

2. Methods of Estimating Costs: Scattergraph: For the following dataset: Month Labor-Hours Machine-Hours Overhead Costs NE 6 60 VOU AWN- 3,625 6,775 $513,435 3,575 7,035 518,960 3,400 7,600 549,575 3,700 7,265 541,400 3,900 7,955 581,145 3,775 7,895 572,320 3,700 6,950 535, 110 3,625 6,530 510,470 3,550 7,270 532,195 3,975 7,725 565,335 3,375 6,490 503,775 3,550 8,020 564,210 a. Prepare a Scatter Graph based on the overhead and machine-hour data below (Use Excel)? b. Add a title, x-axis and y-axis label to the graph, show the correlation coefficient, show the simple regression equation on the plot and identify the intercept and the slope from the equation (Use Excel)? c. Calculate the correlation coefficient between the overhead and machine-hour data? d. Find the simple regression equation manually using the regression equation (prepare a well-designed table)