np Chart in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

The np chart is useful when it's easy to count the number of defective items and the sample size is always the same. Examples might include: the number of defective circuit boards per 100 or errors per each sample of 50 invoices.

Here is an example of an np chart created using the QI Macros SPC Software for Excel

np chart data has a constant sample size and looks like this:

A fully capable process delivers zero defects. Although this may be difficult to achieve, it should still be our goal. Once we resolve the out-of-control point, we could use the quality problem solving process to begin to eliminate the common causes of defects. What are the most common types of defects? Why do they occur? What are the root causes of these defects?

• np chart video
• np chart template
• np chart formula
• Control charts in Excel
• Types of control charts

np charts are just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!