Hi,
Is there a function to calculate the average of multiple series, eg.
smpl 1990 2007
series z = (w+x+y)/3
show z
@mean(w,x,y,"1990 2007") would return an error since @mean essentially works on just one series (?).
Mean, @mean, Average
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Mean, @mean, Average
I believe, and its not 100% clear to me what you want, that the @rmean function will do what you want:
Code: Select all
group g w x y
series z = @rmean(g)
show z
Follow us on Twitter @IHSEViews
-
- Posts: 16
- Joined: Tue Oct 14, 2008 12:40 am
Re: Mean, @mean, Average
Thanks Gareth ... that worked.
Sorry I wasn't clear. I have 3 time series W, X, Y. I'd like to generate a new series Z which, at each obervation, we have the average of W, X and Y. Kinda like the average(b2:d10) type function in Excel.
Sorry I wasn't clear. I have 3 time series W, X, Y. I'd like to generate a new series Z which, at each obervation, we have the average of W, X and Y. Kinda like the average(b2:d10) type function in Excel.
Who is online
Users browsing this forum: No registered users and 21 guests