218 14: Additional Examples
File name : English-M02-1-040308(Print).doc Print data : 2004/3/9
A Solver Equation for Moving Averages:
name
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.
@c
or
Clears current list or
gets
a new one.
4400
I
5360
I
2900
I
3670
I
Enters data.