P Chart with SigmaXL

What is a P Chart?

The P chart plots the percentage of defectives in one subgroup as a data point. It considers the situation when the subgroup size of inspected units is not constant. The underlying distribution of the P-chart is binomial distribution.

Use SigmaXL to Plot a P Chart

Data File: “P” tab in “Sample Data.xlsx”

Steps to plot a P chart in SigmaXL:

  1. Select the entire range of the data
  2. Click SigmaXL -> Control Chart -> Attribute Charts -> P
  3. A new window named “P-Chart” appears with the selected range automatically populated into the box below “Please select your data”.
  4. Click “Next>>”
  5. A new window also named “P-Chart” pops up.
  6. Select “Fail” as the “Numeric Data Variables (Y)”
    Select “N” as the “Subgroup Column or Size”
  7. Check the checkbox of “Test for Special Causes”
  8. Click “OK”
  9. A new window named “Tests for Special Causes” pops up. Click “OK” to proceed.
  10. The P chart appears in the newly generated tab “P-Chart (1)”.

P Chart Diagnosis

Model summary: Since the sample sizes are not constant over time, the control limits are adjusted to different values accordingly. All the data points fall within the control limits and spread randomly around the mean. We conclude that the process is in control.


Join Our Community

Instant access to hundreds of "How to" articles, Tools, Templates, Roadmaps, Data-Files.. Everything Lean Six Sigma! Come on in! Welcome to our community of Lean Six Sigma certified professionals.


My Interest in This Content is More Closely Related to*
This field is for validation purposes and should be left unchanged.

About Lean Sigma Corporation

Lean Sigma Corporation is a trusted leader in Lean Six Sigma training and certification, boasting a rich history of providing high-quality educational resources. With a mission to honor and maintain the traditional Lean Six Sigma curriculum and certification standards, Lean Sigma Corporation has empowered thousands of professionals and organizations worldwide with over 5,300 certifications, solidifying its position and reputation as a go-to source for excellence through Lean Six Sigma methodologies.