Process Capability, Cpk, Ppk and SPC for Excel

Click here to view a video on how a process capability (Cpk) analysis is made using SPC for Excel

Cpk Example

 

 

Process Capability (Cpk) Features

  • Generates histogram with normal distribution
  • Plots LSL and USL
  • Handles one-sided specifcations
  • Option to plot nominal
  • Prints statistics:
    • Within Process Capability (based on estimated sigma)
      • Cp
      • Cpk
      • Cpu
      • Cpl
      • Estimated Sigma (from range or standard deviation chart)
      • Part per million > upper specification limit (PPM > USL)
      • Part per million < lower specification limit (PPM < LSL)
      • Total part per million out of specification (Total PPM)
      • Sigma level
    • Overall Process Capability (based on calculated sigma)
      • Pp
      • Ppk
      • Ppu
      • Ppl
      • Calculated Sigma
      • Part per million > upper specification limit (PPM > USL)
      • Part per million < lower specification limit (PPM < LSL)
      • Total part per million out of specification (Total PPM)
      • Sigma level
    • Average
    • Count
    • Actual number out of specifications
  • Add +/- 3 sigma limits option
    • Base on estimated sigma or calculated sigma
  • Add average option
  • Shade histogram option
  • Remove outliers option
  • Generate multiple process capability charts at once
    • Set specification limits based on data option
  • Add dates of data collection option
  • Develop the process capability analysis based on an existing chart
  • Change the specification limits easily to see the impact on process capability
  • Update an existing process capability analysis with new data

Need to teach process capability to others?  We also offer a complete teaching guide for process capability that is easily customizable. It expalins Cpk and Ppk in detail.  For more information on process capability, please see our October, November, and December 2004 newsletters on our website. 

 

SPC for Excel

Our SPC software, SPC for Excel, provides an easy way to perform statistical analysis in Microsoft Excel. This SPC software is very cost effective and user-friendly.

At the same time, it is a very powerful statistical package that meets the needs of most professionals - green belts, black belts, quality professionals, quality assurance, front-line personnel, supervisors, quality control, controllers, engineers, and laboratory personnel - anyone who wants to improve their data analysis.

 

 Buy SPC for Excel Now

 

Watch our SPC for Excel Introductory Video

 

Overview of SPC for Excel

At only $219 for a single user, SPC for Excel is an attractive alternative for many organizations. It is the perfect tool to use for statistical analysis, process improvement, problem solving and statistical training. Our SPC software is used internationally in over 60 countries. You also receive regular revisions to your version with no maintenance fees!  And we have great discounts for multiple users!

The software includes control charts, Pareto diagrams, histograms, scatter diagrams, fishbone diagrams, process capability analysis, measurement systems analysis, regression, experimental design, hyptoheses testing, nonparametric analysis and much more.    The software works with Excel 2000 through Excel 2010.

The links below provide more details on the SPC for Excel software.

Statistical Tools in SPC for Excel

Demo

User Support, Upgrades, Systems Requirements

Customer Feedback

Software Videos ("How to")

Ordering Information

 

Download Free SPC for Excel Demo

 

 Buy SPC for Excel Now

 

Watch our SPC for Excel Introductory Video