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

Control Chart for Mean and Standard Deviation
[Title or Process]										© 2009 Vertex42 LLC
[Date]										HELP
	Quality Characteristic	Average Thickness (mm), X-bar
	Sample Size, n	4
	k	3
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	#NAME?
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
	LCLX-bar	27.741				LCLS	0.000
	a	#NAME?
	ARL	#NAME?	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
Insert rows above the gray line

Terms of Use
© 2009 Vertex42 LLC. All rights reserved.
http://www.vertex42.com/ExcelTemplates/control-chart.html
This TermsOfUse worksheet may not be modified, removed, or deleted.
Limited Use Policy
You may make archival copies and customize this template (the "Software") for personal use or for your
company use. The customized template (with your specific personal or company information) may be
used and shared within your company, but this template or any document including or derived from
this template may NOT be sold, distributed, or placed on a public server such as the internet.
No Warranties
THE SOFTWARE AND ANY RELATED DOCUMENTATION ARE PROVIDED TO YOU "AS IS."
VERTEX42, LLC MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AND EXPRESSLY DISCLAIMS ALL
REPRESENTATIONS, ORAL OR WRITTEN, TERMS, CONDITIONS, AND WARRANTIES, INCLUDING BUT NOT
LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND
NONINFRINGEMENT. WITHOUT LIMITING THE ABOVE YOU ACCEPT THAT THE SOFTWARE MAY NOT MEET
YOUR REQUIREMENTS, OPERATE ERROR FREE, OR IDENTIFY ANY OR ALL ERRORS OR PROBLEMS, OR DO
SO ACCURATELY. This Agreement does not affect any statutory rights you may have as a consumer.
Limitation of Liability
IN NO EVENT SHALL VERTEX42, LLC BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS,
LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES
ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE (EVEN IF WE OR AN AUTHORIZED DEALER
OR DISTRIBUTOR HAS BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), OR ANY MISTAKES AND
NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY. THE
ORGANIZATION, BUSINESS, OR PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY
FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE.
Somes states do not allow the limitation or exclusion of liability for incidental or consequential damages,
so the above limitation may not apply to you.