# Calculating Process Capability from Data of attached spreadsheet

P

#### PravinPoojari

Can someone help me in calculating the process capability from the attached spreadsheet. -PP

#### Attachments

• 42 KB Views: 422

#### Stijloor

Staff member
Super Moderator
A Quick Bump!

Can someone help with this?

Thank you very much!

Stijloor.

#### Jim Wynne

Staff member
Can someone help me in calculating the process capability from the attached spreadsheet. -PP
There's a lot of information in that spreadsheet, and no way to tell what information you're interested in. Before anyone can get close to a capability calculation, we need to know for starters what the process is and what the specifications are.

#### Bev D

##### Heretical Statistician
Staff member
Super Moderator
The data also looks like production quantities vs some production target for different areas/processes. So it's simple count data. each area listed has a different target wchih would imply that the capability of each area is different. The number of results for each unique area is too low to calculate any meaningful capability. One could calculate the overall capability but since each area is different we woudl have to use a simple categorical approach and 'back calculate' a "Cpk" number (Which I can only assuem you mean when you ask for a capability calculation). That said 'capability studies' really were not meant for this high level of a measure of a ny process...

M

Dear PP,
Do you want the Capability analysis like number of hr and number of parameters inspected (use .U chart ), or Number of hrs and number of record cleared .so 1st focus of the parameters for which you want to do the analysis and then you can decide the which chart is suitable for you(u can take expert comment to use u chart mentioned above)

Product Development - When to start calculating Process Capability Capability, Accuracy and Stability - Processes, Machines, etc. 3
K Calculating Capability of a process when data is skewed in the upper range Capability, Accuracy and Stability - Processes, Machines, etc. 4
D Calculating Upper-CL/Lower-CL and Process Capability Statistical Analysis Tools, Techniques and SPC 8
S Process Capability questions - Calculating Cpu using Minitab Six Sigma 6
S Is a Stable Process (within Control Limits) required for Calculating Pp, Ppk? Capability, Accuracy and Stability - Processes, Machines, etc. 6
V Subsets vs. Subgroups - Calculating the control limits of a process Statistical Analysis Tools, Techniques and SPC 6
D Calculating Cpk for Tubing Wall Thickness - Extrusion Process - How to approach? Statistical Analysis Tools, Techniques and SPC 16
C Calculating Process Average Targets for LSL (Lower Specification Limit) Only Statistical Analysis Tools, Techniques and SPC 15
True position, calculating theoretical distances General Measurement Device and Calibration Topics 0
Lean: Conducting Capacity Study, calculating Cycle times on laser cutting machines Lean in Manufacturing and Service Industries 2
Calculating Carbon Footprint in the Organization Miscellaneous Environmental Standards and EMS Related Discussions 2
Calculating your KPIs ISO 13485:2016 - Medical Device Quality Management Systems 7
Calculating Heat Dissipation Manufacturing and Related Processes 1
Calculating Defect Rates ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
Formula for Calculating NoGo Major Diameter for UN gages Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
Calculating a weight for a machine for the CE label CE Marking (Conformité Européene) / CB Scheme 0
Remote Support - Calculating Number of Employees IATF 16949 - Automotive Quality Systems Standard 2
Calculating Tolerance of a Panel Meter with a 2 degrees of an Arc General Measurement Device and Calibration Topics 0
Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
Calculating Reliability for Subsystems in Series Reliability Analysis - Predictions, Testing and Standards 15
Calculating (3rd Party) Audit Days for Company with Seasonal Employees General Auditing Discussions 3
T Formulas for Calculating Coefficients for RTD / PRTD Calibration According to ITS-90 General Measurement Device and Calibration Topics 5
J Calculating part variation from historic data for GRR study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
P Purpose of calculating Ta, Tb & R Square in Linearity Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
P Purpose of calculating Uncertainty value in calibration study Measurement Uncertainty (MU) 5
M Calculating MTBF for plug-in PCI cards Reliability Analysis - Predictions, Testing and Standards 2
J Calculating impact force, expressed in lbs, of a 5 lb weight dropped 48 inches Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
M Calculating Cpk when sample size equals to 1 Capability, Accuracy and Stability - Processes, Machines, etc. 12
D Calculating Cpk on Non-Normal Data Distribution Capability, Accuracy and Stability - Processes, Machines, etc. 10
A Calculating Accuracy for a Multimeter General Measurement Device and Calibration Topics 1
M Calculating Coefficients for an RTD (Resistance Temperature Detector) Probe General Measurement Device and Calibration Topics 3
T Calculating Plating/Coating Weight for IMDS RoHS, REACH, ELV, IMDS and Restricted Substances 3
D Calculating Lower and Upper 3 Sigma Control Limits Statistical Analysis Tools, Techniques and SPC 2
M Calculating Adequate Receiving Inspection Sample Size Statistical Analysis Tools, Techniques and SPC 2
M Calculating Capability of Delivery Performance Capability, Accuracy and Stability - Processes, Machines, etc. 5
K Advice on Calculating Control Chart Control Limits Statistical Analysis Tools, Techniques and SPC 13
B Calculating Combined DPMO and Sigma Level for Two or More Different Work Areas Six Sigma 3
G Calculating the Fraction Defective Confidence Interval for a Lot Statistical Analysis Tools, Techniques and SPC 2
A Calculating Combined Measurement Uncertainty - VDA 5 Measurement Uncertainty (MU) 1
B Calculating Precision to Tolerance Ratio Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
D DPPM - Calculating the Defect Rate of a Software Test Statistical Analysis Tools, Techniques and SPC 9
L FMEA - Calculating RPN = S*O*D FMEA and Control Plans 3
I Shewhart Constants vs Central Limit Theorem in calculating Control Limits Statistical Analysis Tools, Techniques and SPC 18
B Please share a template for calculating Cp Cpk Document Control Systems, Procedures, Forms and Templates 3
Calculating the IATF TS 16949 Recertification Audit Man Days - Clarification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
IEC60825 - Laser Safety - Calculating Maximum Permissible Exposure Correctly Other ISO and International Standards and European Regulations 1
I AQL Formula in Excel - Calculating Sample Size based on an AQL Chart AQL - Acceptable Quality Level 8
D Formula for Calculating Warp Measurement of Corrugated Boxes General Measurement Device and Calibration Topics 1
S Need Help Calculating and Implementing Cs - Wright's Index Statistical Analysis Tools, Techniques and SPC 11
S Calculating an Uncertainty Budget for an Optical Comparator General Measurement Device and Calibration Topics 4