Control Chart for Mean and Range

[Title or Process]
[Date]

Quality Characteristic Average Thickness (mm), X-bar

Sample Size, n 5
A v e r a g e T h ic k n e s s ( m m ) , X - b a r

k 3

38
37.355
37

36

35 34.840
34

33
32.325
32

31

30

29
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
Sample #

10
9.219
Range

4 4.360

0 0.000
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
Sample #

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 99.21%

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

http://www.vertex42.com/ExcelTemplates/control-chart.html 2009 Vertex42 LLC

 LCLX-bar 32.325 CL-ksX-bar LCLR 0.000
a 0.0027
ARL 370.4 samples

http://www.vertex42.com/ExcelTemplates/control-chart.html 2009 Vertex42 LLC

 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

http://www.vertex42.com/ExcelTemplates/control-chart.html 2009 Vertex42 LLC

 Control Chart for Mean and Standard Deviation
[Title or Process]
[Date]

Quality Characteristic Average Thickness (mm), X-bar

Sample Size, n 4
A v e r a g e T h ic k n e s s ( m m ) , X - b a r

k 3

45

41.939
40

35 34.840

30
27.741

25

20
S ta n d a r d D e v ia tio n

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
Sample #

12
10 9.880
8
6
4 4.360

2
0 0.000
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
Sample #

Statistics from Data Table Process Capability

s-bar 4.360 Upper Spec Limit, USL 45
c4 0.9213 Lower Spec Limit, LSL 25
Process St.Dev., s-hat 4.732 Cp 0.704
Process Mean, m-hat 34.840 CPU 0.716
sX-bar 2.366 CPL 0.693
ss 1.840 Cpk 0.693
Percent Yield 96.53%

Control Limits for X-bar Chart Control Limits for S Chart

CLX-bar 34.840 CLS 4.360
UCLX-bar 41.939 UCLS 9.880

http://www.vertex42.com/ExcelTemplates/control-chart.html 2009 Vertex42 LLC

 LCLX-bar 27.741 LCLS 0.000
a 0.0027
ARL 370.4 samples

Data Table X-bar Chart R Chart

Sample X-bar St. Dev., s CL UCL LCL CL UCL LCL
1 35.6 4 34.840 41.939 27.741 4.360 9.880 0.000
2 33.8 5 34.840 41.939 27.741 4.360 9.880 0.000
3 34.4 6 34.840 41.939 27.741 4.360 9.880 0.000
4 35 3 34.840 41.939 27.741 4.360 9.880 0.000
5 35.6 6 34.840 41.939 27.741 4.360 9.880 0.000
6 33.4 5 34.840 41.939 27.741 4.360 9.880 0.000
7 33 3 34.840 41.939 27.741 4.360 9.880 0.000
8 34.4 6 34.840 41.939 27.741 4.360 9.880 0.000
9 36 5 34.840 41.939 27.741 4.360 9.880 0.000
10 34 3 34.840 41.939 27.741 4.360 9.880 0.000
11 35 4 34.840 41.939 27.741 4.360 9.880 0.000
12 35.6 4 34.840 41.939 27.741 4.360 9.880 0.000
13 33.4 5 34.840 41.939 27.741 4.360 9.880 0.000
14 35.2 3 34.840 41.939 27.741 4.360 9.880 0.000
15 36.8 5 34.840 41.939 27.741 4.360 9.880 0.000
16 35.2 5 34.840 41.939 27.741 4.360 9.880 0.000
17 33.2 3 34.840 41.939 27.741 4.360 9.880 0.000
18 36.4 5 34.840 41.939 27.741 4.360 9.880 0.000
19 34.2 5 34.840 41.939 27.741 4.360 9.880 0.000
20 36 4 34.840 41.939 27.741 4.360 9.880 0.000
21 35.8 4 34.840 41.939 27.741 4.360 9.880 0.000
22 32.6 5 34.840 41.939 27.741 4.360 9.880 0.000
23 37 4 34.840 41.939 27.741 4.360 9.880 0.000
24 34.8 3 34.840 41.939 27.741 4.360 9.880 0.000
25 34.6 4 34.840 41.939 27.741 4.360 9.880 0.000

http://www.vertex42.com/ExcelTemplates/control-chart.html 2009 Vertex42 LLC

Control Chart Template
By Vertex42.com
http://www.vertex42.com/ExcelTemplates/control-chart.html

2009-2017 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a

copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or online

template gallery.

Please review the following license agreement to learn how you may or may not
use this template. Thank you.

See License Agreement

http://www.vertex42.com/licensing/EULA_privateuse.html

Do not delete this worksheet. If necessary, you may hide it by right-clicking on

the tab and selecting Hide.