Zoho Sheet

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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

Control Chart for Mean and Range
[Title or Process]									© 2009 Vertex42 LLC
[Date]									HELP

	Quality Characteristic	Average Thickness (mm), X-bar
	Sample Size, n	5
	k	3
































Statistics from Data Table					Process Capability
	R-bar	4.360				Upper Spec Limit, USL	40
	Process Mean, m-hat	34.840				Lower Spec Limit, LSL	30
	Process St.Dev., s-hat	1.874				Cp	0.889
	sX-bar	0.838				CPU	0.918
						CPL	0.861
						Cpk	0.861
						Percent Yield	#NAME?

Control Limits for X-bar Chart					Control Limits for R Chart
	CLX-bar	34.840				CLR	4.360
	UCLX-bar	37.355	CL+ksX-bar			UCLR	9.219
	LCLX-bar	32.325	CL-ksX-bar			LCLR	0.000
	a	#NAME?
	ARL	#NAME?	samples

Data Table			X-bar Chart			R Chart
Sample	X-bar	Range	CL	UCL	LCL	CL	UCL	LCL
1	35.6	4	34.840	37.355	32.325	4.360	9.219	0.000
2	33.8	5	34.840	37.355	32.325	4.360	9.219	0.000
3	34.4	6	34.840	37.355	32.325	4.360	9.219	0.000
4	35	3	34.840	37.355	32.325	4.360	9.219	0.000
5	35.6	6	34.840	37.355	32.325	4.360	9.219	0.000
6	33.4	5	34.840	37.355	32.325	4.360	9.219	0.000
7	33	3	34.840	37.355	32.325	4.360	9.219	0.000
8	34.4	6	34.840	37.355	32.325	4.360	9.219	0.000
9	36	5	34.840	37.355	32.325	4.360	9.219	0.000
10	34	3	34.840	37.355	32.325	4.360	9.219	0.000
11	35	4	34.840	37.355	32.325	4.360	9.219	0.000
12	35.6	4	34.840	37.355	32.325	4.360	9.219	0.000
13	33.4	5	34.840	37.355	32.325	4.360	9.219	0.000
14	35.2	3	34.840	37.355	32.325	4.360	9.219	0.000
15	36.8	5	34.840	37.355	32.325	4.360	9.219	0.000
16	35.2	5	34.840	37.355	32.325	4.360	9.219	0.000
17	33.2	3	34.840	37.355	32.325	4.360	9.219	0.000
18	36.4	5	34.840	37.355	32.325	4.360	9.219	0.000
19	34.2	5	34.840	37.355	32.325	4.360	9.219	0.000
20	36	4	34.840	37.355	32.325	4.360	9.219	0.000
21	35.8	4	34.840	37.355	32.325	4.360	9.219	0.000
22	32.6	5	34.840	37.355	32.325	4.360	9.219	0.000
23	37	4	34.840	37.355	32.325	4.360	9.219	0.000
24	34.8	3	34.840	37.355	32.325	4.360	9.219	0.000
25	34.6	4	34.840	37.355	32.325	4.360	9.219	0.000

Insert rows above the gray line

XbarR

XbarS

TermsOfUse