Weighted Average of a Time Series

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

RobertGarrisonII
Posts: 1
Joined: Mon Mar 19, 2012 3:01 pm

Weighted Average of a Time Series

Postby RobertGarrisonII » Mon Mar 26, 2012 7:40 am

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?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13605
Joined: Tue Sep 16, 2008 5:38 pm

Re: Weighted Average of a Time Series

Postby EViews Gareth » Mon Mar 26, 2012 8:32 am

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests