p Chart Formulas
The p chart is used to evaluate process stability when counting the number or fraction defective.
The p chart is used when the sample size varies. Examples include the number of defective products, meals in a restaurant, incorrect prescriptions, bills, invoices, paychecks, etc.
Here is the formula used to calculate a p chart.

Conforms with ANSI/ASQC B1, B2, B3 1996
Other Resources
- Create a p chart in Excel using the QI Macros
- p chart video
- p chart format options in the QI Macros
- p chart template in Excel
- Other control chart formulas
The p chart is just one of the tools included in the QI Macros for Excel SPC Software for Excel.
To create a p Control Chart in Excel, purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!








