Analyze the data using the regression model y= b0 + b1 x, where y = time to approve and mail a claim (weekly average), x = 0 for the old process, and x = 1 for the new process.

Use the data in the table and submit the answers to the following questions in a Word document:

In Excel, calculate the average effect of each process. Did the process change? Did the process average increase or decrease, and by how much? Copy-paste your Excel calculations into your Word Document.
In Excel, create the Linear Regression Model. Analyze the data using the regression model y= b0 + b1 x, where y = time to approve and mail a claim (weekly average), x = 0 for the old process, and x = 1 for the new process. Copy-paste the Regression Model into your Word Document.
How does this model measure the effect of the process change?

Related Posts