MAT510 week 7

Complete the following questions and attached excel workbook.Use the date in table above and answer the following questions in the space provided below:What was the average effect of the process change? Did the process average increase or decrease and by how much?Analyze the data using the regression model y = b0 + b1x, where y = time to approve and mail a claim (weekly average), x = 0 for the old process, and x = 1 for the new process.How does this model measure the effect of the process change?How much did the process performance change on the average? (Hint: Compare the values of b1 and the average of new process performance minus the average of the performance of the old process.)