0% found this document useful (0 votes)
267 views1 page

Cp-Cpk-Template

The document contains data from 5 subgroups measuring some characteristic over 20 samples. It reports the mean, maximum, minimum and range for each subgroup and overall. It also calculates the average mean, standard deviation, upper and lower control limits based on the data. The document provides process information that the characteristic being measured is scratch hardness from a core shop process.

Uploaded by

AMIT SHARMA
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
0% found this document useful (0 votes)
267 views1 page

Cp-Cpk-Template

The document contains data from 5 subgroups measuring some characteristic over 20 samples. It reports the mean, maximum, minimum and range for each subgroup and overall. It also calculates the average mean, standard deviation, upper and lower control limits based on the data. The document provides process information that the characteristic being measured is scratch hardness from a core shop process.

Uploaded by

AMIT SHARMA
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
You are on page 1/ 1

Sl.No.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Subgroup1 72.00 71.00 72.00 71.00 72.00 71.00 73.00 71.00 72.00 73.00 71.00 72.00 71.00 71.00 72.00 73.00 71.00 72.00 73.00 71.00
Subgroup2 71.00 72.00 72.00 72.00 72.00 73.00 72.00 73.00 73.00 71.00 72.00 73.00 73.00 72.00 71.00 72.00 71.00 73.00 71.00 70.00
Subgroup3 72.00 72.00 71.00 71.00 71.00 73.00 72.00 72.00 71.00 73.00 72.00 71.00 73.00 72.00 72.00 72.00 71.00 71.00 71.00 70.00
Subgroup4 70.00 70.00 70.00 70.00 71.00 70.00 71.00 70.00 71.00 70.00 71.00 70.00 71.00 70.00 70.00 71.00 70.00 71.00 71.00 70.00
Subgroup5 72.00 72.00 72.00 72.00 72.00 72.00 72.00 71.00 72.00 71.00 70.00 70.00 71.00 71.00 72.00 71.00 72.00 71.00 71.00 72.00
Mean 71.40 71.40 71.40 71.20 71.60 71.80 72.00 71.40 71.80 71.60 71.20 71.20 71.80 71.20 71.40 71.80 71.00 71.60 71.40 70.60
Max 72.00 72.00 72.00 72.00 72.00 73.00 73.00 73.00 73.00 73.00 72.00 73.00 73.00 72.00 72.00 73.00 72.00 73.00 73.00 72.00
Min 70.00 70.00 70.00 70.00 71.00 70.00 71.00 70.00 71.00 70.00 70.00 70.00 71.00 70.00 70.00 71.00 70.00 71.00 71.00 70.00
Range 2.00 2.00 2.00 2.00 1.00 3.00 2.00 3.00 2.00 3.00 2.00 3.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00
Average of
Range 2.15

Averge of Mean 71.44


To download the others template/format , keep visaiting https://www.techiequality.com
Std.Dev. 0.92433361995
USL 80 Tol. 20
LSL 60
Cp 3.61
Cpk 3.1

8.56 11.44 8.56


Characteristics Scratch Hardness
Process: Core Shop

Only Yellow colour box are changeable others will calculate automatically

You might also like