Page 1 of 1

Finding average value for each month

Posted: Tue Mar 10, 2020 6:44 pm
by Econ_undergrad
Hey guys,

I’ve got monthly data about yields for different government bonds with different maturities. I want to find the mean yield for each month across all the bonds, not the mean yield for each bond. Is there a way of doing this?

Re: Finding average value for each month

Posted: Tue Mar 10, 2020 6:56 pm
by EViews Gareth
@rmean

Re: Finding average value for each month

Posted: Wed Mar 11, 2020 2:32 am
by Econ_undergrad
Would that work if the bonds are different series and would I use the command? Just type @rmean?

Re: Finding average value for each month

Posted: Tue Sep 22, 2020 2:47 am
by uuwipo
You should create a group of the series you want to calulate the mean for. After you have done that, you can use the @rmean to fill a new series with the mean. Like this for example:
group bonds bond1 bond2 bond3 ....
genr bonds_mean = @rmean(bonds)