X Median Chart in Excel| X Median R Chart

X Median R Charts 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 work with companies
that want to fire up their profits using
Lean Six Sigma

Use an X Median R Chart to evaluate stability of processes using variable data--time, cost, length, weight.

The XMedianR chart works just like the X bar R chart except that it uses the median instead of the average as a measure of central tendency.

Here is an example of an X Median R Chart created using the QI Macros for Excel.

Median Chart

X Median R Chart in Excel Median

Range Chart
X Median R chart in Excel Range

The X Median R 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 five), however, you can effectively measure and evaluate the process.

Calculate, plot, and evaluate the range chart first. If it is "out of control," so is the process. If the range chart looks okay, then calculate, plot, and evaluate the X chart.

Other Resources

The XmedianR 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

Download
QI Macros
30-Day Trial Now!

X Median R Charts in Excel

Use an X Median R Chart to evaluate stability of processes using variable data--time, cost, length, weight.