Average of several series which contain the smallest values

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

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

svilen
Posts: 34
Joined: Wed Mar 18, 2009 5:59 am
Location: Sofia, Bulgaria
Contact:

Average of several series which contain the smallest values

Postby svilen » Mon Nov 16, 2009 8:08 am

I would like to make an average of n series which contain the smallest (but above zero) values among N available time series. And this averaging should be made for every period separately, because different series could have the smallest values in different time periods.
I could do this in Excel with function like: =AVERAGE(SMALL(RANGE,{1,2,3,...n})) where RANGE is N, but I would like to perform this computation in EViews. Any help will be appreciated.
EViews 6 & 7.1 user

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests