Weighted Average of a Time Series
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
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
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:
where X is the name of your base series.
In your case, you could create the weighted series as:
Code: Select all
series wgt_x = x*@quarter/10
Who is online
Users browsing this forum: No registered users and 2 guests
