Scribd
Upload
12 views4 pages

Process Capability

This document is a template for Process Capability Analysis, allowing for up to 150 observations with data entry restricted to yellow cells. It includes nominal specifications, upper and lower limits, and calculates process capability indices such as Cp, Cpl, Cpu, and Cpk. Additionally, it provides a frequency distribution and histogram setup for the entered data.

Uploaded by

Mirgank Tirkha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views4 pages

Process Capability

This document is a template for Process Capability Analysis, allowing for up to 150 observations with data entry restricted to yellow cells. It includes nominal specifications, upper and lower limits, and calculates process capability indices such as Cp, Cpl, Cpu, and Cpk. Additionally, it provides a frequency distribution and histogram setup for the entered data.

Uploaded by

Mirgank Tirkha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

A B C D E F G H

1 Process Capability Analysis


2 This template is designed to handle up to 150 observations. Enter data only in yellow cells.
3
4 Nominal specification 10.7
5 Upper specification limit 10.9
6 Lower specification limit 10.5
7
8 DATA 1 2 3 4 5 6 7
9 1 10.650 10.800 10.500 10.800 10.700 10.800 10.750
10 2 10.750 10.850 10.800 10.800 10.700 10.700 10.850
11 3 10.750 10.700 10.650 10.800 10.650 10.650 10.750
12 4 10.600 10.650 10.650 10.700 10.600 10.750 10.800
13 5 10.700 10.750 10.700 10.750 10.550 10.700 10.850
14 6 10.600 10.900 10.850 10.750 10.650 10.650 10.600
15 7 10.600 10.750 10.800 10.700 10.600 10.850 10.850
16 8 10.750 10.750 10.700 10.700 10.700 10.600 10.650
17 9 10.650 10.650 10.750 10.800 10.650 10.900 10.650
18 10 10.600 10.600 10.750 10.800 10.750 10.850 10.750
19
20 Process Capability Index Calculations Cp 0.767662
21 Average 10.7171 Cpl 0.833233
22 Standard deviation 0.0868 Cpu 0.702091
23 Cpk 0.702091
24
25
26
27
I J K L M N O P Q
1 ©Cengage Learning
nly in yellow cells.
2 Not for commercial use.
3
4
5
6
7
8 8 9 10 11 12 13 14 15
9 10.650 10.850 10.650 10.800 10.650
10 10.700 10.800 10.550 10.700 10.850
11 10.650 10.500 10.800 10.750 10.800
12 10.850 10.650 10.650 10.700 10.600
13 10.700 10.750 10.600 10.750 10.700
14 10.750 10.750 10.600 10.650 10.650
15 10.850 10.800 10.850 10.850 10.800
16 10.850 10.750 10.650 10.700 10.650
17 10.750 10.700 10.750 10.700 10.700
18 10.750 10.700 10.650 10.600 10.650
19
20
21
22
23
24
25
26
27
R S T U V
1 Frequency Distribution and Histogram
2 Enter smallest and largest limits for the fre
3 Data Minimum 10.500 The lower limit should be slightly less than
4 Data Maximum 10.900 The upper limit should be slightly larger th
5 Lower limit 10.450
6 Enter number of cells (10 or less) Upper limit 10.950
7 Number of Cells 8 Cell width 0.063
8
9 Cell From To (inclusive) Frequency
10 -Infinity 10.45 0
11 1 10.45 10.51 2
50
12 2 10.51 10.58 2
13 3 10.58 10.64 13 45
14 4 10.64 10.70 47 40
15 5 10.70 10.76 24 35
16 6 10.76 10.83 16
30
17 7 10.83 10.89 14

Frequency
18 8 10.89 10.95 2 25
19 9 10.95 11.01 0 20
20 10 11.01 11.08 0 15
21
10
22
23 5
24 0
25 10.45 10.
26
27
W X Y Z AA AB AC AD
1
mallest and largest
2 limits for the frequency distribution.
er limit should3 be slightly less than the data minimum.
er limit should4 be slightly larger than the data maximum.
5
6
7
8
9
10 Histogram
11
50
12
13 45
14 40
15 35
16
30
17
Frequency

18 25
19 20
20 15
21
10
22
23 5
24 0
25 10.45 10.51 10.58 10.64 10.70 10.76 10.83 10.89 10.95 11.01
26 Cell Upper Limit
27

You might also like