You have learned a lot about your process though the use of the tools and techniques

You have learned a lot about your process though the use of the tools and techniques of
Six Sigma. Now you want to be determine whether or not your new process
is behaving predictably. So in this deliverable, you need to create an XmR (Individual
and Moving Range) chart to answer the question, "Is there any assignable-cause variation
in the process?" You are given total deposit cycle time (in hours) by period.

Instructions
We want to make sure you can calculate control limits. You will need to
actually construct a control chart by hand.

Control Charts in Excel 2003
Control Charts in Excel 2007

1.
2.
3.
4.

What is the upper control limit for the range?
What is the upper control limit for the individuals?
What is the lower control limit for the individuals?
What would you do with the process?
a. What would you recommend?
b. Is the measurement system discriminate?

"I'm lost"
"Do I actually need to do this by hand?"
"I have no idea about this one"

c. Is deposit cycle time in statistical control?

"How can I do this without software?"
Optional help using Excel 2003
Optional help using Excel 2007

Data:
Data:
Period
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

Hours
Cycle Time
45
33
44
30
51
47
39
34
69
43
29
38
45
49
73
38
50
40
57
36
31
46
40
51
48
37
42
50

1a. Calculate R-bar
"How do I do that?"
Check
1b. Calculate the
upper control limit
for the range
"How do I do that?"
Check
2 & 3. Calculate the
control limits for the
individuals
"How do I do that?"
Check

You do not need to submit an actual control chart for this deliverable.
Project:
Finance 2013 LAJ
Deliverable:
Control Chart
Student last name:
Calculated R-Bar:
Upper control limit for the range:::

13.07

Upper control limit for the individuals:
Lower control limit for the individuals:::

78.88

Work Check
Thru

42.75
9.33

ROUND YOUR FINAL
ANSWERS OUT TO 2
DECIMAL PLACES.

12 and 15
40 and 45
75 and 80
9 and 12

Is the Moving Range chart stable? Justify your answer using ALL of the tests for stability covered in the online
textbook and virtual class on SPC. NOTE: IF YOU SAY THE CHART IS UNSTABLE, SPECIFY WHICH TEST(S) IT FAILS
AND WHERE ON THE CHART IT FAILS BY REFERENCING THE SPECIFIC DATA POINTS THAT FAIL BY NUMBER (NOT
VALUE).
Must pass all Control Charts to be stable
Type your answer here. If you say the chart is unstable, specify which test(s) it fails
and where on the chart by referencing the specific data point numbers.

Is the Individuals chart stable? Justify your answer using ALL of the tests for stability covered in the online
textbook and virtual class on SPC. NOTE: IF YOU SAY THE CHART IS UNSTABLE, SPECIFY WHICH
TEST(S) IT FAILS AND WHERE ON THE CHART IT FAILS BY REFERENCING THE SPECIFIC DATA POINTS
THAT FAIL BY NUMBER (NOT VALUE).
Must pass all Control Charts to be stable
Type your answer here. If you say the chart is unstable, specify which test(s) it fails
and where on the chart by referencing the specific data point numbers.

Based upon what the control chart is telling you, what would you do next?
Step Six in Control Charting
Type your answer here.

Is there adequate discrimination? Explain your answer: Which chart did you use and exactly how
many strata are there on that chart? How many strata should there be?
Type your answer here and be sure to explain why you answered
the way you did. HINT: Which chart did you use and exactly how
many strata are there on that chart?

Note

Tests for Stability
*Control Chart Must Pass all of These to be Considered Stable
Set 1
I and mR Interpretation: Test for Presence of Special or Assignable Causes
X-bar and R Chart Interpretation: Tests for a Natural Pattern (test 1)
X-bar and R Chart Interpretation: Tests for a Natural Pattern (test 2)
X-bar and R Chart Interpretation: Tests for Outliers
X-bar and R Chart Interpretation: Tests for Runs (Test 1)
X-bar and R Chart Interpretation: Tests for Runs (Test 2)
X-bar and R Chart Interpretation: Tests for Runs (Test 3)
X-bar and R Chart Interpretation: Tests for Trends
X-bar and R Chart Interpretation: Tests for Cycles
Set - 2
Shewhart's Test for a Natural/Normal Pattern #1
Shewhart's Test for a Natural/Normal Pattern #2
Shewharts Test for Outliers
Shewharts Test for Runs #1
Shewharts Test for Runs #2
Shewharts Test for Runs #3
Shewharts Test for Sudden and Drastic Shift in Level
Shewharts Test for a Stable Mixture
Shewharts Test for an Unstable Mixture
Shewharts Test for a Repeating Pattern/Cycle
Shewharts Test for a Trend/Gradual Change in Level