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 metrics that can be overridden
The EWMA template uses .1 as the default weight but this value can be typed over.
The template calculates the remaining values based on the data, however the formulas can be replaced with different values if you have them:
EWMA Chart Formula