Moving Average Chart Template in Excel
Use a Moving Average and Range chart when you have one sample and want a moving average.
QI Macros Moving Average Template Has Two Options:
1. Moving Average Chart
- Input your data in column B
- Indicate the # of data points you want included in the moving average in cell K2 (Moving Average Period).
- Target (centerline) and standard deviation are calculated from your data but can be over written.
2. Wheeler Moving Average and Range
- Input your data in column B
- Indicate the # of data points you want included in the moving average in cell AA2 (Moving Average Period).
- This template uses different calculations for the Moving Average chart and includes a Range chart, Histogram with Cp Cpk, Capability Plot and Probability Plot.
Learn More...
To create a Moving Average Chart Template using QI Macros...
