Generate statistics for rows in spreadsheet

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

Vron
Posts: 6
Joined: Wed Jan 01, 2014 1:27 pm

Generate statistics for rows in spreadsheet

Postby Vron » Wed Jan 01, 2014 1:37 pm

Hi,
I´ve calculated the Human Development Index (HDI) 500 times (each time under different settings) for 187 countries. In my workfile I have therefore 500 different HDI series-objects. Opening them as a group gives me a spreadsheet with 93500 (=500*187) HDI-values, where the 500 different HDI-versions are columns and the 187 countries are rows. Now I would like to generate statistics/graphs etc. for a single country, i.e. analyze a row. How can I transform the rows to series objects in my workfile, to generate descriptive statistics/graphs etc.?

Any help or advice would be greatly appreciated!

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

Re: Generate statistics for rows in spreadsheet

Postby EViews Gareth » Wed Jan 01, 2014 4:22 pm

Use the @row functions on your group. More information can be found in the Command Reference.

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: Generate statistics for rows in spreadsheet

Postby startz » Wed Jan 01, 2014 5:01 pm

Gareth,

Is there a way to transpose this on read-in, and then just use ordinary series functions?

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

Re: Generate statistics for rows in spreadsheet

Postby EViews Gareth » Wed Jan 01, 2014 5:38 pm

Impossible to tell without knowing where the data came from.

Vron
Posts: 6
Joined: Wed Jan 01, 2014 1:27 pm

Re: Generate statistics for rows in spreadsheet

Postby Vron » Thu Jan 02, 2014 6:35 am

Thank you very much for your responses! They solved my problem.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests