A Solver Equation for Moving Averages:
01O=8^L;I01XL#I91F:/<)#TI91F:I#I;:H0LnameI;TTD"
0;<L<I91F:T"
N= the number of values averaged in each calculation.
LAST = the item number of the most recent value to be averaged.
name = the name of the SUM list whose data will be averaged. When you create and name the SUM list, make sure its name matches the name in the Solver equation.
The following example assumes that you have entered the equation MAVG into the Solver, using VOL for the SUM list’s name. For instructions on entering Solver equations, see “Solving Your Own Equations,” on page 30.
Example: A Moving Average in Manufacturing. Calculate a three- month moving average for the number of units manufactured during the first half of the year. Manufacturing volumes are:
January | February | March | April | May | June |
4400 | 5360 | 2900 | 3670 | 4040 | 3200 |
Keys: | Display: | Description: | ||||
|
|
|
| Displays SUM menu | ||
$ | ! " | |||||
|
|
|
|
|
| and |
|
|
|
|
|
| current list. |
|
|
| Clears current list or | |||
@c | W | " | ||||
or | " | gets | ||||
|
|
| ;:H0L#T8U" | a new one. | ||
p |
| s |
| |||
4400 I | " | Enters data. | ||||
5360 I | " |
| ||||
2900 I | " |
| ||||
3670 I | " |
| ||||
218 14: Additional Examples
File name : | Print data : 2003/7/11 |