Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Wells Fargo wants to investigate its loan application processing time. Table below shows the samples that have been taken from 4 branches for 25 random
Wells Fargo wants to investigate its loan application processing time. 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 |
Please show how the answers could be calculated in Excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started