Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: Donald Waters

5th Edition

273739476, 978-0273739470

More Books

Students also viewed these General Management questions

Question

What method is used for fitting a logistic regression model?

Answered: 1 week ago