EWMA Chart Template in Excel

Use EWMA Charts when you want to detect small shifts in performance.

Example of the EWMA Chart template in QI Macros for Excel

The template contains up to 10 columns to input data observations:

ewma chart template

Find the EWMA Chart template by clicking on the QI Macros menu > Control Chart Templates > Special (CUSUM, EWMA) > EWMA Chart:

control-chart-ewma-menu


EWMA metrics that can be customized

The EWMA template uses .1 as the default weight but this value can be customized.

The template calculates the remaining values based on the data, however the formulas can be replaced with different values if you have them:

ewma metrics


EWMA Chart Formula

ewma-chart-formula


Learn More...


To create an Ewma Chart Template using QI Macros...
Try It Now!