# Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk

A

#### Arizona1

Fantastic Website for sharing Quality Analysis Info- Sometimes it helps just to bounce an idea off others when you are not surrounded by statistical geniuses.

Here is a simple 125 piece part Capabilty excel sheet to calculate Cpk

#### Attachments

• 16.2 KB Views: 1,272

#### Stijloor

Staff member
Super Moderator
A Quick Bump!

Can someone help?

Thank you very much!!

S

#### supreecha

I have just simulated 125 supgroup And 3 Key Process Parameters , after that Calibration sheet by Minitab .

#### Attachments

• 581.5 KB Views: 899
D

#### Darius

First, The formulas for average and stdev just take the first 75 data, not 125 as it should

for example
good C11=AVERAGE(C13:C75,E13:E75); D11=STDEV(C13:C75,E13:E75)

The same for H11,I11; M11,N11

Second, The formula for Cpk (really ppk)

good E11=MIN(B11-C11,C11-C7)/(3*D11)

The same for J11,O11

That's the reason, why it didn't work for J11 (you were taking in account only the upper limit, it must be the least of the difference of upper and lower with the average)

Simple statistics questions on labor data Statistical Analysis Tools, Techniques and SPC 2
Can someone help me explain P-Value with a simple word please? Capability, Accuracy and Stability - Processes, Machines, etc. 11
Nice and simple invitation email to an audit kickoff meeting Internal Auditing 1
Rework, Reprocess, or Correction - A simple blurred letter on the legible etching ISO 13485:2016 - Medical Device Quality Management Systems 4
Looking for simple Software Validation IQ templates. Qualification and Validation (including 21 CFR Part 11) 4
Micrometer and Vernier Caliper simple calibration process General Measurement Device and Calibration Topics 8
Tracking Protoype Changes; 8D or simple document revision? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Simple and effective way to maintain Training Matrix ISO 13485:2016 - Medical Device Quality Management Systems 16
Simple supplier evaluation qualification process form that includes Risk Assessment Document Control Systems, Procedures, Forms and Templates 2
Simple Example for PFMEA / Control Plan Training Training - Internal, External, Online and Distance Learning 1
K Simple ISO 9001:2015 Overview Presentation wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 20
Acceptance Criteria Gage R&R - Simple vs Complex Techniques Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
Making a choice of Simple vs Comprehensiveness of Procedure/System of any Process Document Control Systems, Procedures, Forms and Templates 4
K Simple ISO 9001 Compliant Document Control Quality Manager and Management Related Issues 24
R Determining the feasibility/scope for FDA IQ/OQ against a very simple application US Food and Drug Administration (FDA) 2
Root Cause for "Simple" External Audit Findings ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
What Airlines Really Charge (In 1 Simple Table) Travel - Hotels, Motels, Planes and Trains 6
E Simple Calibration Procedures for Surftest SJ-400 General Measurement Device and Calibration Topics 6
K Too Simple an Internal Audit Check Sheet? Internal Auditing 10
S Can you help with a simple SPC sheet to judge if inspection is Good / No Good ? Capability, Accuracy and Stability - Processes, Machines, etc. 8
T Microsoft Access Database to create a Simple Calibration Certificate General Measurement Device and Calibration Topics 6
S Destructive Attribute MSA for Simple Water Leak Check in Trailers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
Best CAPA for slip in simple-yet-persistent oversight-review mechanism Nonconformance and Corrective Action 7
A simple electronic (software) document control question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
A QSM documents for Simple Designs Quality Manager and Management Related Issues 12
M Looking for a simple procedure on section 7.5.2 for Validation of Processes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
Making a simple Sampling Plan by Variables Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
W Simple SPC Software recommendations Quality Assurance and Compliance Software Tools and Solutions 8
Z IEC 60601-1-2 for very simple Medical Device Accessory IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
P Monitoring Production Defects - Three simple questions Six Sigma 3
C Simple explanation of Uncertainty in Calibration Measurement Uncertainty (MU) 2
V External power supply with reinforced insulation as a simple secondary circuit? IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
M Conducting Limited Internal Audits of QMS Elements - Simple question I hope ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
K How to set up a simple Complaint and CAPA workflow Nonconformance and Corrective Action 9
Simple Representation for Scope of DFMEA and PFMEA FMEA and Control Plans 4
Simple Navigation Guide for the MSA 4th Edition Manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
S Simple Cartoons needed Coffee Break and Water Cooler Discussions 4
X FDA Approval Process - Simple Explanation requested US Food and Drug Administration (FDA) 4
K Definition Box Plot - Simple Explaination of what a Box Plot is Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 3
M Simple Field Pipeline Demagnetization Procedure needed Document Control Systems, Procedures, Forms and Templates 5
Simple Flow Diagram with CCPs for Processing of Raw Fish Food Safety - ISO 22000, HACCP (21 CFR 120) 1
V Can Anyone Give a Simple Explanation on ndc (number of distinct categories)? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Export "Simple Notification" required by the FDA under Section 802 of the Act Other US Medical Device Regulations 3
EAC, Simple Code and NACE Code ISO 13485:2016 - Medical Device Quality Management Systems 5
1 Simple Dock Audit Form Document Control Systems, Procedures, Forms and Templates 1
Simple Home Remedies Funny Stuff - Jokes and Humour 6
J Simple Corrective Action Flow Chart example needed Problem Solving, Root Cause Fault and Failure Analysis 4
B Overall Process Capability - Simple question if you know how to answer it! Statistical Analysis Tools, Techniques and SPC 3
Simple Preventive Action Procedure - Service Company (Please Review) Preventive Action and Continuous Improvement 20
A Control of records - what's simple and works! Document Control Systems, Procedures, Forms and Templates 6