Mean, @mean, Average

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

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

Vladimir_Yorrick
Posts: 16
Joined: Tue Oct 14, 2008 12:40 am

Mean, @mean, Average

Postby Vladimir_Yorrick » Tue Oct 14, 2008 11:47 pm

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 (?).

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

Re: Mean, @mean, Average

Postby EViews Gareth » Tue Oct 14, 2008 11:51 pm

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

Vladimir_Yorrick
Posts: 16
Joined: Tue Oct 14, 2008 12:40 am

Re: Mean, @mean, Average

Postby Vladimir_Yorrick » Wed Oct 15, 2008 12:12 am

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 4 guests