r/dataisbeautiful • u/FluidModeNetwork • 2d ago

OC [OC] Overall ranking for 51+ Countries

Post image

My sheets document includes the sources, but the ranking uses 13 different sources. Sadly, not every country is included in every source so you will see blank spaces for countries that are left out in the data. I've also created a correlation index to see how different metrics matched up with each other and you can see the data I used for each ranking.

https://docs.google.com/spreadsheets/d/1YbfVevxEthNgDtK69P48Xm39bXLHi8eqfeFwxTTYEJE/edit?usp=sharing

Hope you like it, lemme know if you have any questions.

0 Upvotes

36% Upvoted

92 comments sorted by

View all comments

Show parent comments

-3

u/FluidModeNetwork 2d ago

Any suggestions?

2

u/Ewan_Derstand 2d ago

Beauty is in the eye of the beholder. If the purpose of the visualization is to illustrate potential correlation between the national happiness index and other variables, I would personally use a lattice chart with scatterplots where each data point is a country.

So something like this. Lots of room for further refinement here, just highlighting an option for OP to consider.

0

u/FluidModeNetwork 2d ago

Oh I love this, is this what you did based on my data? I'd love a higher res image.

That said, instead of that, what I did what make an interactive correlation chart thingy because there are so many combinations you can make from 13 sources. Did you take a look at that? Or were you looking to create a single image of all of them? I also made a table showing each combo of two metrics coefficients to make it easier to determine which correlate or not and what was worth looking at.

The main goal of this image was to make a countries ranking, not a correlations table. But I would be happy in making a visualization for that.

1

u/Ewan_Derstand 2d ago

Yes, this was generated using your data

1

u/Ewan_Derstand 2d ago

A matrix ("lattice") of scatter plots can be an effective technique to illustrate differences in the correlation between variables in a set of data. It is typically not useful as replacement to a reference table, such as the ranking of each country in this case.