Trying to Create XMedianR Charts in Excel?

QI Macros can create them for you!

Create an XMedianR Chart using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Special> XMedianR.
  3. QI Macros will do the math and draw the chart for you.
  4. QI Macros will also turn any unstable points or conditions red.

Go Deeper: Use an XMedianR Chart to Evaluate Stability of Processes Using Variable Data

The XMedianR Chart works just like the XbarR Chart except that it uses the median instead of the average as a measure of central tendency.

Here is an example of an XMedianR Chart created using QI Macros for Excel.

X Median R chart created in Excel by QI Macros

The XMedianR 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.

Stop Struggling with XMedianR Charts!
Start creating your XMedianR Charts in just minutes.

Download a free 30-day trial. Get XMedianR Charts now!

Learn More...

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support