HP 12c Platinum Reference Manual page 80

80 Forecasting
Example: Econo-Wise Home Appliance Company had quarterly sales for the years 2000
thru 2002 as follows:
Find the centered 4-quarter moving average and seasonal variation factor for each quarter.
12c platinum / 12C
RPN Keystrokes
fCLEARH
397?1
376?2
460?3
501?4
455?5
g(000t
t
390t
t
530t
t
560t
t
513t
t
434t
t
562t
t
593t
t
Now, what is the average of each quarter's seasonal variation for the two years?
12c platinum / 12C
RPN Keystrokes
fCLEAR²
98.86_
99.95_
gÖ
Sales (IN $K)
Quarterly 1st
2000 397
2001 455
2002 513
12c platinum
ALG Keystrokes
fCLEARH
397?1
376?2
460?3
501?4
455?5
g(000t
t
390t
t
530t
t
560t
t
513t
t
434t
t
562t
t
593t
t
12c platinum
ALG Keystrokes
fCLEAR²
98.86_
99.95_
gÖ
2nd 3rd 4th
376 460 501
390 530 560
434 562 593
Display
0.00
397.00
376.00
460.00
501.00
455.00
Centered 4-element average for
440.75
3rd quarter, 2000.
Seasonal variation factor.
104.37
4th quarter, 2000.
449.75
111.40
1st quarter, 2001.
460.25
98.86
2nd quarter, 2001.
476.38
81.87
3rd quarter, 2001.
491.00
107.94
4th quarter, 2001.
503.75
111.17
1st quarter, 2002.
513.25
99.95
2nd quarter, 2002.
521.38
83.24
Display
0.00
1.00
2.00
1st quarter average seasonal
99.41
variation, %.
Comments
Comments