X bar S Chart in Excel | X and S Chart | X and Standard Deviation Chart

X bar S Chart 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!

Use an X bar S chart (X and S chart) to evaluate stability of processes using variable data--time, cost, length, weight. Use an X bar S chart when your sample size is 6 or more.

Here is an example of an X and Standard Deviation chart created using the QI Macros for Excel.

X chart

X bar S Chart in Excel Average

Standard Deviation Chart
X bar S chart in Excel Std Dev

The X bar S chart can help you evaluate the cycle time for almost any process: making a widget, answering a customer call, seating a customer, delivering a pizza, or servicing an appliance. This chart is especially useful when you do this many times a day. Collecting the data could be expensive if you measured every time you did it. Using a small sample (typically 6 or more), however, you can effectively measure and evaluate the process.

Calculate, plot, and evaluate the standard deviation (S) chart first. If it is "out of control," so is the process. If the S chart looks okay, then calculate, plot, and evaluate the X chart.

Other Resources

The X bar S chart is 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

X bar S Chart Excel

Use an X bar S chart (X and S chart) to evaluate stability of processes using variable data--time, cost, length, weight. Use an X bar S chart when your sample size is 6 or more.