np Chart Template for 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 purpose of the np chart is to evaluate process stability when counting the fraction defective and the sample size is constant.

Here is an example of the np chart template in the QI Macros for Excel. Just type data into the yellow input area and the chart will be drawn to the right. You can also cut and paste data from another spreadsheet into the template.

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 defective units. What are the most common types of errors? Why do they occur? What are the root causes of these errors?

The np chart template is actually made up of several templates depending on your needs:

Just click on the appropriate worksheet tab to access any of these options:

• Center Line Based on Average (far left tab)
• Templates to Handle Rolling Data
• Short Run (DNOM) Control Charts
• Templates for Horizontal Data
• Control Chart with Fixed or Historical Control Limits

Other Resources

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

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

Order the template for Excel Mobile. Click Here.

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!