Question: Please include excel formulas for UCL & LCL Wells Fargo wants to investigate its loan application processing time. The table below shows the samples that
Please include excel formulas for UCL & LCL
Wells Fargo wants to investigate its loan application processing time. The table below shows the samples that have been taken from 4 branches for 25 random days. Examine the process output by calculating the control limits and developing X-bar and R control charts using the data given. Does the process look to be in statistical control?
| Day | Branch 1 | Branch 2 | Branch 3 | Branch 4 |
| 1 | 8 | 12 | 37 | 6 |
| 2 | 20 | 23 | 33 | 20 |
| 3 | 24 | 19 | 21 | 10 |
| 4 | 21 | 16 | 29 | 8 |
| 5 | 12 | 16 | 24 | 14 |
| 6 | 25 | 12 | 27 | 11 |
| 7 | 14 | 21 | 23 | 10 |
| 8 | 10 | 27 | 39 | 23 |
| 9 | 23 | 15 | 31 | 20 |
| 10 | 23 | 8 | 23 | 8 |
| 11 | 17 | 10 | 26 | 21 |
| 12 | 24 | 24 | 26 | 24 |
| 13 | 13 | 14 | 19 | 19 |
| 14 | 9 | 21 | 24 | 13 |
| 15 | 12 | 9 | 28 | 22 |
| 16 | 26 | 11 | 14 | 24 |
| 17 | 20 | 13 | 18 | 23 |
| 18 | 5 | 20 | 30 | 7 |
| 19 | 8 | 13 | 22 | 7 |
| 20 | 28 | 23 | 35 | 12 |
| 21 | 25 | 14 | 14 | 20 |
| 22 | 12 | 11 | 31 | 17 |
| 23 | 21 | 13 | 17 | 23 |
| 24 | 14 | 15 | 21 | 16 |
| 25 | 16 | 13 | 24 | 21 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
