Complete the following questions and attached excel workbook.

Use the date in table above and answer the following questions in the space provided below:

1. What was the average effect of the process change? Did the process average increase or decrease and by how much?
2. 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.
3. How does this model measure the effect of the process change?
4. 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.)

Complete the following questions and attached excel workbook.

Use the date in table above and answer the following questions in the space provided below:

1. What was the average effect of the process change? Did the process average increase or decrease and by how much?
2. 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.
3. How does this model measure the effect of the process change?
4. 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.)