Generate statistics for rows in spreadsheet
Posted: 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!
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!