u Chart in Excel | u Control Chart | u Chart

u Chart in Excel
home · products · services · search · view cart · contact

NAVIGATION

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

We help people think!

The purpose of a u chart is to determine stability of "counted" data (e.g., errors per bill, dents in a car door, etc.) when there can be more than one defect per unit and the sample size varies.

Here is an example of a u chart created using the QI Macros SPC Software. The stair step or skyline control limits are the result of the varying sample sizes.

u Chart in Excel

u chart data looks like this

u Chart data

The u chart will help evaluate process stability when there can be more than one defect per unit. Examples might include: the number of defective elements on a circuit board, the number of defects in a dining experience--order wrong, food too cold, check wrong, or the number of defects in bank statement, invoice, or bill.

The u chart is especially useful when you want to know how many defects there are not just how many defective items there are. It's one thing to know how many defective circuit boards, meals, statements, invoices, or bills there are; it is another thing to know how many defects were found in these defective items.

Other Resources

Video showing how to create a u chart in Excel
u chart template
u chart formula
u chart format options in the QI Macros

u 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

Try QI Macros
FREE
For 30-Days