Question: Given the data below and using Excel, construct the histogram labeling the USL, LSL, and X bar . Then make a chart similar to the
Given the data below and using Excel, construct the histogram labeling the USL, LSL, and Xbar. Then make a chart similar to the one below with the correct answers for each. An example of how to calculate the zones appears at the bottom of this page if you are unaware of how to do it. Use formulas that you have learned in previous assignments and lessons to obtain answers. All answers should be automated using cell references and should not be typed in answers. Identify any out of control points in the data, if any.
Specifications 6.000.05
Subgroup
Measurement 1
Measurement 2
Measurement 3
1
6.01
6.01
5.97
2
5.99
6.03
5.99
3
6.00
5.96
6.00
4
6.01
5.99
5.99
5
6.04
6.02
6.01
6
6.05
6.00
6.00
7
6.00
5.94
5.99
8
6.01
5.98
5.99
9
6.00
6.00
6.01
10
5.98
5.99
6.03
11
6.00
5.98
5.96
12
5.98
5.99
5.99
13
5.97
6.01
6.00
14
6.01
6.03
5.99
15
6.00
5.98
6.01
16
6.00
5.98
6.02
17
5.97
6.01
5.97
18
6.02
5.99
6.02
19
5.99
5.98
6.01
20
6.01
5.98
5.99
21
5.97
5.95
5.99
22
6.02
6.00
5.98
23
5.98
5.99
6.00
24
6.02
6.00
5.98
25
5.97
5.99
6.02
26
6.00
6.02
5.99
27
5.99
5.96
6.01
28
5.99
6.02
5.98
29
5.99
5.98
5.96
30
5.97
6.01
5.98
Keep answers to 4 decimal places
Answers
USL
LSL
Xbarbar
UCLxbar
LCLxbar
Rbar
UCLR
LCLR
3
6
Cp
Cpk
Upper Limit of Zone A
Upper Limit of Zone B
Upper Limit of Zone C
Lower Limit of Zone D
Lower Limit of Zone E
Lower Limit of Zone F
% Out of spec. above USL
% Out of spec. below LSL
Total % out of spec
This may be of help to you. (AS AN EXAMPLE)
If UCLXbar= 6.47, LCLXbar= 6.35, Xbarbar= 6.41, Rbar= 0.0876 and UCLR= 0.2.
The limits for the "Zones" are calculated as follows:
Determine the value for sigma which is different from the regular calculation, which is calculated by taking your UCLxbar- LCLxbarand dividing it by 6, the answer would be 0.02 in this case.
Therefore, the limits for Zone A are 6.45 to 6.47. Any two out of three points in a row in this zone is an out of control condition. Similarly the limits for the other zones can be determined.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help