Filter
Top Products
218 14: Additional Examples
File name : 17BII-Plus-Manual-E-PRINT-030709 Print data : 2003/7/11
A Solver Equation for Moving Averages:
01O=8^L;I01XL#I91F:/<)#TI91F:I#I;:H0L
name
I;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.
@c
W
or
p
s
"
"
;:H0L#T8U"
Clears current list or
gets
a new one.
4400
I
5360
I
2900
I
3670
I
"
"
"
"
Enters data.