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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!