Share
Explore BrainMass

Time series analysis

I need help understanding the formula to use for this problem. Also, can this be calculated using a function in Excel?

An analyst want to use the ratio-to-moving average method to forecast a cmpany's sales for the next few quarters. Beginning in Quarter 3 of 2002, the analyst collects the following sales data (in millions of dollars). Estimate the seasonal index associated with Quarter 1. Round your answers to at least three decimal places.

Time Period Quarter Sales Moving Average
1 3 131.0
2 4 207.3
141.275
3 1 144.8
138.075
4 2 82.0
129.425
5 3 118.2
139.275
6 4 172.7
140.025
7 1 184.2
152.725
8 2 85.0
169.825
9 3 169.0
172.900
10 4 241.1
176.675
11 1 196.5

12 2 100.1

Solution Preview

In order to center the moving average we take the average of ...

Solution Summary

To determine seasonal indices using ratio to moving average.

$2.19