Page 1 of 1

Generate statistics for rows in spreadsheet

Posted: Wed Jan 01, 2014 1:37 pm
by Vron
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!

Re: Generate statistics for rows in spreadsheet

Posted: Wed Jan 01, 2014 4:22 pm
by EViews Gareth
Use the @row functions on your group. More information can be found in the Command Reference.

Re: Generate statistics for rows in spreadsheet

Posted: Wed Jan 01, 2014 5:01 pm
by startz
Gareth,

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

Re: Generate statistics for rows in spreadsheet

Posted: Wed Jan 01, 2014 5:38 pm
by EViews Gareth
Impossible to tell without knowing where the data came from.

Re: Generate statistics for rows in spreadsheet

Posted: Thu Jan 02, 2014 6:35 am
by Vron
Thank you very much for your responses! They solved my problem.