MAT510 week 7 Homework

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.)