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!
Generate statistics for rows in spreadsheet
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
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
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
Gareth,
Is there a way to transpose this on read-in, and then just use ordinary series functions?
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
Impossible to tell without knowing where the data came from.
Re: Generate statistics for rows in spreadsheet
Thank you very much for your responses! They solved my problem.
Who is online
Users browsing this forum: No registered users and 2 guests
