Mean, @mean, Average

[Vladimir_Yorrick]

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]

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


[Vladimir_Yorrick]

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.