EViews.com

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

Posted: **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

Posted: **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.

EViews.com

Mean, @mean, Average

Mean, @mean, Average

Re: Mean, @mean, Average

Re: Mean, @mean, Average