| The time that it takes for an insurance claim form to be completed is very important for an institution. |
| They want to know if there is a change in this process. |
| 20 random samples have been evaluated as shown below. |
| In each sample, the completion times for four forms have been measured: |
| Last 5 digits of Student No: | | 53909 |
| | Sample | Time it took to complete the forms in this sample in hours |
| | | First form | Second form | Third | Fourth |
| | | | | form | form | | Construct a control -chart using the Excel templates available to you. |
| | 1 | 12.7 | 13.5 | 5.5 | 7.6 |
| | 2 | 5.9 | 13 | 12.2 | 11.3 | | Answer the following questions in your excel file and load it to Moodle. |
| | 3 | 9.8 | 12.2 | 8 | 15.7 |
| | 4 | 6.4 | 11.2 | 15.9 | 12.9 | | 1-What are the chart types you will use? |
| | 5 | 8.7 | 9.9 | 11.1 | 15.7 | | Explain Why? |
| | 6 | 11.3 | 8.4 | 5.5 | 3.8 |
| | 7 | 14.1 | 6.6 | 9.9 | 6.1 | | 2-Is the average completion time for forms in this process in control? Why? |
| | 8 | 17.3 | 4.5 | 6.7 | 8.8 | | Explain all reasons. |
| | 9 | 2.8 | 20.2 | 3.1 | 11.8 |
| | 10 | 5.6 | 18.7 | 18 | 15.1 | | 3-Is the variation in completion times in control? Why? Mention all your reasons. |
| | 11 | 8.7 | 10.5 | 14.6 | 18.7 | | Explain all reasons. |
| | 12 | 12.1 | 19.9 | 10.7 | 22.6 |
| | 13 | 15.8 | 8.1 | 6.5 | 4.8 | | 4- Summarize the problems of this process and explain how we can fix these problems. |
| | 14 | 19.9 | 18.3 | 1.8 | 8.4 |
| | 15 | 24.2 | 5.3 | 20.8 | 12.2 |
| | 16 | 3.9 | 16.1 | 16.3 | 16.4 |
| | 17 | 18.4 | 1.9 | 11.4 | 5.1 |
| | 18 | 20.9 | 13.5 | 6.1 | 7.1 |
| | 19 | 23.6 | 26 | 0.4 | 9.3 |
| | 20 | 26.4 | 10.4 | 23.4 | 11.6 |
ThamJam
spc_home_case_2015_summer-3.xlsm
