Page 1 of 1

Weighted Average of a Time Series

Posted: Mon Mar 26, 2012 7:40 am
by RobertGarrisonII
I currently have quarterly time series data that I would like to have weighted and annualized. I would like the weights to be as follows: Q1=.1, Q2=.2, Q3=.3 and Q4=.4. How would I go about assigning these weights to each quarter and thus finding the average?

Re: Weighted Average of a Time Series

Posted: Mon Mar 26, 2012 8:32 am
by EViews Gareth
You'll probably have to create a new series that is the weighted series, then find the average of it.

In your case, you could create the weighted series as:

Code: Select all

series wgt_x = x*@quarter/10
where X is the name of your base series.