Finding average value for each month

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

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

Econ_undergrad
Posts: 2
Joined: Tue Mar 10, 2020 4:14 pm

Finding average value for each month

Postby Econ_undergrad » Tue Mar 10, 2020 6:44 pm

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?

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

Re: Finding average value for each month

Postby EViews Gareth » Tue Mar 10, 2020 6:56 pm

@rmean
Follow us on Twitter @IHSEViews

Econ_undergrad
Posts: 2
Joined: Tue Mar 10, 2020 4:14 pm

Re: Finding average value for each month

Postby Econ_undergrad » Wed Mar 11, 2020 2:32 am

Would that work if the bonds are different series and would I use the command? Just type @rmean?

uuwipo
Posts: 5
Joined: Tue Jul 28, 2020 7:43 am

Re: Finding average value for each month

Postby uuwipo » Tue Sep 22, 2020 2:47 am

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)


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 18 guests