April 2024
Intermediate to advanced
824 pages
36h 45m
English
Content preview from Business Statistics
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 16 | Time Series and Index Numbers 581
FigUre 16.13
MS Excel worksheet showing
moving averages, fits and
residuals for Example 16.1
FigUre 16.11
Minitab Moving Average-
Storage dialog box
FigUre 16.12
Minitab sheet showing
moving averages, fits, and
residuals for Example 16.1
Note: MS Excel and SPSS can be used to calculate moving averages using the general computing
tools available with the software programs Figure 16.13 is the MS Excel worksheet showing moving
averages, fits, and residuals for Example 16.1.
16.10.3 Weighted Moving Averages Method
We have already noticed that in the moving averages method, equal weights are assigned to