Trying to Create EWMA Charts in Excel?

QI Macros can create them for you!

Create an EWMA Chart using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Special> EWMA .
  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.

Use the EWMA Chart when you have one sample and want to detect small shifts in performance.

The EWMA (exponentially weighted moving average) Chart's performance is similar to the Cusum chart.

Example of an EWMA Chart created in QI Macros for Excel

EWMA chart in Excel

To create an EWMA control chart using QI Macros:

  1. Highlight your data and select "EWMA" from the "Control Charts (SPC)" drop-down menu.
  2. Next you will be prompted to either accept the default alpha parameter of 0.2 or enter in your own:
  3. ewma chart prompt


EWMA Chart Formula

ewma-chart-calculation

 

Note: Per Montgomery 4th Edition, “values of λ in the interval 0.05 ≤ λ ≤ 0.2 work well in practice, with λ = 0.05, λ = 0.10, and λ = 0.20 being popular choices. A good rule of thumb is to use smaller values of λ to detect smaller shifts."
The lower the value of the alpha parameter, the closer your UCL and LCL will be to the CL; and vice versa.

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

Download a free 30-day trial. Get EWMA 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

affordable

Affordable

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