Averaging within series

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

ADNL
Posts: 13
Joined: Thu May 15, 2014 9:51 am

Averaging within series

Postby ADNL » Mon Jun 16, 2014 12:52 am

Hi,

I want calculate the average within a series. The serie consists of 145 countries with data from 1990 to 2010. I want to calculate the average from 1990-1999 and 2000-2010. This is the data:

AFG - 90 1089.49
AFG - 91 969.85
AFG - 92 902.06
AFG - 93 600.9
AFG - 94 431.85
AFG - 95 619.04
AFG - 96 570.38
AFG - 97 527.20
AFG - 98 490.59
AFG - 99 453.98
AFG - 00 427.41
AFG - 01 406.17
AFG - 02 614.79
AFG - 03 703.86
AFG - 04 696.6
AFG - 05 775.73
AFG - 06 799.45
AFG - 07 894.21
AFG - 08 894.04
AFG - 09 1018.12
AFG - 10 1049.36
ALB - 90 3230.62
ALB - 91 2339.25
ALB - 92 2295.08
ALB - 93 2516.33
ALB - 94 2680.77
ALB - 95 2985.9
ALB - 96 3231.05
ALB - 97 3076.33
ALB - 98 2959.32
ALB - 99 3296.7
ALB - 00 3416.42
ALB - 01 3526.94
ALB - 02 3628.66
ALB - 03 4064.41
ALB - 04 4559.67
ALB - 05 4938.810
ALB - 06 5397.97
ALB - 07 5902.05
ALB - 08 6606.32
ALB - 09 6789.51
ALB - 10 6616.63
DZA - 90 5002.350
DZA - 91 4902
DZA - 92 4840.26
DZA - 93 4641.32
DZA - 94 4487.26


How can I do this?

Thanks in advance!

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

Re: Averaging within series

Postby EViews Gareth » Mon Jun 16, 2014 7:03 am

Set the workfile sample to be the dates you want, then open the series and click on View->Descriptive Statistics->Stats Tablep

ADNL
Posts: 13
Joined: Thu May 15, 2014 9:51 am

Re: Averaging within series

Postby ADNL » Wed Jun 18, 2014 1:30 am

Thanks!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests