↓
 

chart planet

data-human interaction

chart planet

data-human interaction

  • blog
    • dashboard design
    • data visualisation
    • Power BI asteroid
    • reviews
  • visuals
    • charts
    • interfaces
  • LT
    • grafikai
    • apie duomenų vizualizaciją
  • inspirations
  • talks
  • about

Category Archives: visuals

graphic insights about the world we live in

Post navigation

<< 1 2 3 4 5 6 … 8 9 >>

Is discipline helping to be more productive?

chart planet Posted on 2020-08-03 by Chart Planet2023-03-18
Is discipline helping to be more productive?

This is another data selfie based on my own observation of myself.

I tracked down how disciplined am I based on how well I stick to my daily routine and also how much of weekly goals I do achieve. There is a visible positive correlation, but two facts leave me unconvinced that discipline is really useful: 1. When I am the least disciplined, my results are not really bad, at some weeks I even managed to achieve 100% 2. When I am the most disciplined, at some weeks I had results that are among the worst.

I guess that when I concentrate too much on those “daily routine” and “discipline” things I might be more motivated, but then I have less time for actual work on my goals. After those weeks of tracking my results, I dropped the effort to stick to the daily routine completely. And I believe I am as productive as I can be.

What: The proportion of weekly goals achieved and “level of discipline” measured in points. Discipline points are binned into arbitrary intervals, and the white gradient shows median at its brightest point.
When: 38 weeks during 2019-2020
Source: self-observation

My real goal here was to draw really “creative” chart even if it is hard to read.

Posted in charts | Tagged Boxplot, Data selfie, R

Is waking up earlier better?

chart planet Posted on 2020-07-29 by Chart Planet2023-03-18
Is waking up earlier better?

In this world of selfies I make data selfies. I documented my daily routine and weekly goals for 38 weeks and how I have some data to make conclusions on.

According to my own observations of myself the earlier I wake up and start working, the more weekly goals I achieve. Starting the work at 10 a.m. yields better results than at 9 a.m., but there were only 3 weeks when I woke up so late on average and even those were affected by a single day when I slept until noon after some kind of all-night activity.

When I wake up early my body and mind are ready to work at once – I’m definitely not an owl.

What: Weekly average time of starting to work, and the proportion of weekly goals achieved. Time is binned into intervals by 1 hour, and the proportion is averaged.
When: 38 weeks during 2019 and 2020
Source: self-observation

My real goal here was to draw really “creative” chart even if it is hard to read.

Posted in charts | Tagged Data selfie, R, Radial bar chart

How are China’s corporations doing compared to the rest of the world?

chart planet Posted on 2020-07-20 by Chart Planet2023-03-18

They’re doing well on the internet. China’s Tencent and Alibaba are among the top 10 for 4 years already.

What: Non-USA companies that are in the top 10 public traded companies by market capitalization every year. Saudi Aramco is not included, because only a small fraction of its shares are traded publicly.
When: 1997-2020Q2
Where: I hope it’s the whole world except the USA.
Source: https://en.wikipedia.org/wiki/List_of_public_corporations_by_market_capitalization

Posted in charts | Tagged Country specific, Interactive, R, Stock market, Unit chart

What kind of corporations rule the world?

chart planet Posted on 2020-07-15 by Chart Planet2023-03-18

Corporations of internet and computers.

What: Top 10 public traded companies by market capitalization every year. Saudi Aramco is not included, because only a small fraction of its shares are traded publicly.
When: 1997-2020Q2
Where: I hope it’s the whole world.
Source: https://en.wikipedia.org/wiki/List_of_public_corporations_by_market_capitalization

Posted in charts | Tagged Interactive, R, Stock market, Unit chart

If GDP has declined, will real estate prices go down?

chart planet Posted on 2020-06-25 by Chart Planet2023-03-18
If GDP has declined, will real estate prices go down?

Every drop in GDP is followed by a decline in real estate prices or at least a significant slow down in growth with the most obvious case at the beginning of ’80s.

What: Moving average of quarterly USA GDP growth (GDP in billions of chained 2012 dollars, seasonally adjusted) and moving average of quarterly median sales price of houses sold in the United States.
When: 1964Q1 – 2020Q1
Where: USA only.
Source: FRED

Posted in charts | Tagged Bar chart, GDP, R, Real estate

If the stock market has crashed, will GDP also decline?

chart planet Posted on 2020-06-22 by Chart Planet2023-03-18

Often when the market turns red there is at least a dip in GDP growth. However, there are cases when this does not happen.

What: Moving average of quarterly S&P500 index growth and moving average of quarterly USA GDP growth (GDP in billions of chained 2012 dollars, seasonally adjusted)
When: 1948Q1 – 2020Q1
Where: USA only, because S&P is populated by mostly American companies.
Source: Yahoo Finance for S&P500 and FRED for GDP.

Posted in charts | Tagged Bar chart, GDP, R, Stock market

Is oil the main reason of changes in GDP in Africa

chart planet Posted on 2020-06-17 by Chart Planet2023-03-18
Is oil the main reason of changes in GDP in Africa?

I was deceived!

I saw that Equatorial Guinea, the African country that increased its GDP per capita the most during 1980-2018 had done this due to newly found oil. I saw that Gabon, the African country that decreased its GDP per capita the most during the same period, had done this due to diminishing its oil reserves. So I thought, the same applies to the most of rapidly growing (or contracting) African economies, but that is not true (except for Libya).

The sources of growth might not be very sustainable just like oil, but finding them requires a deeper analysis of every separate country.

What: GDP per capita divided into oil rents, rents from other natural resources and GDP from other sources. Grey bars indicate full GDP value with the unknown division.
When: From 1980 till 2018. Not all countries had a full range of data. No country had its GDP divided for 2018.
Where: Countries of the African continent with the biggest GDP per capita growth during 1980-2018 (top 8) and biggest fall (bottom 4, except South Sudan, which had very short data range)
Source: WB

Posted in charts | Tagged GDP, Oil, R, Stacked bar chart

Are there African countries that improved their economies a lot?

chart planet Posted on 2020-06-15 by Chart Planet2023-03-18

I will consider that improving economy simply means increasing GDP per capita.

And that happened in a handful of countries. What are the reasons for this increase? That is a question for the next image, but I expect to find oil. Also, what happened to Gabon?

What: GDP per capita.
When: From 1980 till 2018. Not all countries had a full range of data.
Where: Countries of the African continent
Source: WB

Posted in charts | Tagged GDP, Infographic, Tableau

Do electric cars emit less CO2?

chart planet Posted on 2020-06-03 by Chart Planet2023-03-18
Do electric cars emit less CO2?

Many people still have doubts about whether the lower emissions of driving an electric car outweighs the additional impact on the environment caused by manufacturing the batteries.

Two studies (the latter is more trustworthy than the former) show that electric cars do help to reduce the CO2 emission. But how much – it depends.
If the batteries are produced in a country where the industry is polluting more (China), reductions will be lower. If the car is driven in a country where electricity is produced by burning things (like Estonia or Poland) the reductions will be lower or even negative.
A special case is Japan, where cars are so fuel-efficient, that electric cars even raise emissions.

So, YES, electric cars are more often better than not.

What: Top = Lifetime emissions of cars in tonnes of CO2. Bottom = Lifetime emissions of cars in grams of CO2 per 1 kilometer.
When: Top = Estimate for 2020, Bottom = Estimate for 2030 with “current technological trajectory” scenario.
Where: Top = EU countries, Bottom = selected countries of the world.
Source: Top = European Federation for Transport and Environment, Bottom = Knobloch, F., Hanssen, S., Lam, A. et al. Net emission reductions from electric cars and heat pumps in 59 world regions over time. Nat Sustain (2020). https://doi.org/10.1038/s41893-020-0488-7

Posted in charts | Tagged Bar chart, CO2 emissions, R, Stacked bar chart

Is the world gaining debt too rapidly?

chart planet Posted on 2020-05-20 by Chart Planet2023-03-18
Is the world gaining debt too rapidly?

To see nominal numbers of debt increasing won’t tell us much, so it is better to look at debt expressed as percentage of GDP. Also we need to compare current growth to something, so I am comparing growth in 10 years until the most recent data (2008-2018) with growth in 10 years until the Great Recession (1998-2008).

One thing is seen at once – the governments in most countries are getting more debt than before.

Corporations and household are increasing their debt in more countries than decreasing, but the rate of increase is slower now and more countries are decreasing than before. We’re less crazy than in those crazy times.

What: Debt made of loans and debt securities expressed in % of GDP.
When: 1998 – 2018
Where: 103 countries of the world. Iceland was removed from the chart and they know why. (Because of extreme numbers, debt levels reaching over 700%). Also, there might be some bias in the data, because not all countries have data for all periods and all debt receivers.
Source: BIS

Posted in charts | Tagged Debt, Exploration interface, Interactive, Tableau

Game: Trading in Random Market

chart planet
Random Market Trader

Try trading in random market – buy stocks, borrow money, hedge with derivatives and go bankrupt! It’s fun!

CONTINUE >>>
Posted in interfaces | Tagged Game, R shiny, Stock market

Do we pay more for worse movies?

chart planet Posted on 2020-05-18 by Chart Planet2023-03-18
Do we pay more for worse movies?

Maybe, but more no than yes.

We spend more and more money on movies even in times of television and the internet. So, not a big surprise, that more and more movies are being made.

Median rating of all movies in the IMDB database is declining. Is it a sign of movies getting worse? No, its a sign of more movies being made, when this art is accessible to not only exceptional talents but mediocre talents as well. Anyway, who watches 2000 movies a year? Let’s become picky.

Let’s pick the most popular 200 movies each year and calculate their median. Now there is a stable trend – median popular movie usually has a rating of just around 6.4. (Movie popularity is measured in the number of ratings on IMDB). That’s good.

Now let’s take 200 top-rated movies each year with at least 25 000 ratings. A sharp decline becomes visible! And before the 80s not many such movies existed at all. So, if you like only top-rated popular movies, you might experience deterioration in their quality. Sequels of Transformers are getting worse and worse.

However there are great lesser-known movies, especially those made in non-English speaking countries, so they get less attention and therefore fewer ratings. I’d subjectively say that a good lesser-known movie has at least 4000 ratings. If we pick 200 best such movies, we get a different view – often a median movie will have a rating higher than 7, and no permanent downward trend is present. Great!

What: Movie earnings in USD billion adjusted for inflation.
The number of movies – with more than 100, 4000 and 25 000 ratings.
IMDB movie ratings indicate the median rating calculated for every year, and a trend line fitted using a generalized additive model.
All movies – those which have at least 100 ratings
Most popular movies – 200 most rated but having at least 100 ratings (because there were times when less than 200 movies were made).
Top-rated popular movies – 200 top-rated movies from those having at least 25 000 ratings.
Top-rated movies for cinephiles – 200 top-rated movies from those having at least 4000 ratings.
If less than 40 movies left remaining after filtering – no rating calculated for that year.
When: 1968 – 2019
Where: Movie earnings represent earnings around the globe.
Source:
IMDB for ratings and number of movies
the-numbers.com for movie earnings.
WB and IMF for inflation used to adjust earnings.

Posted in charts | Tagged Dot chart, Movies, R

Is the life improving for salarymen?

chart planet Posted on 2020-05-13 by Chart Planet2023-03-18
Is the life improving for salarymen?

Based on how many average baskets of goods one can buy for an average salary while living alone and without children – yes, absolutely. There were wiggles after the crisis, but the overall trend is upwards – people can buy more and more stuff because salaries are increasing faster than prices.
The only sad exception in the period analyzed is Slovakia.

What: Annual net earnings divided by price level index which result in the number of standard baskets of goods one can buy.
The average wage is “annual net earnings of a full-time single worker without children earning an average wage” measured in Purchase Power Standards.
Price level index is made to be 100 in 2020 for the EU as a whole for a standardized basket of goods. It is tailored for cross-country comparison.
Data for OECD countries was estimated using “Price level ratio of PPP conversion factor (GDP) to market exchange rate” (provided by WB, very accurate estimates), and “Average annual wage in 2018 constant prices at 2018 USD PPPs” (provided by OECD, not very accurate estimates)
When: 2000 – 2018
Where: 39 countries from the EU and OECD.
Source: EUROSTAT, OECD, WB

Posted in charts | Tagged R, Spaghetti chart, Wages

Where do salarymen have the best life?

chart planet Posted on 2020-05-11 by Chart Planet2023-03-18

Based on how many average baskets of goods one can buy for an average salary while living alone and without children – Poland takes the lead followed by Germany. For some time the United States seemed the best country for that. However in a few decades, things can change drastically – the Slovak Republic once at the top, now is somewhere at the bottom, and Poland itself climbed a long way up – the time between 2009 and 2010 was a mess.

It is very difficult to find time-series data about the average salary, so only the EU and OECD countries are included in this chart. It would be interesting to see how cheap is Thailand for Thai people!

What: Average wage divided by price level index which results in the number of standard baskets of goods one can buy.
The average wage is “annual net earnings of a full-time single worker without children earning an average wage” measured in Purchase Power Standards.
The price level index is made to be 100 in 2020 for the EU as a whole for a standardized basket of goods. It is tailored for cross-country comparison.
Data for OECD countries was estimated using “Price level ratio of PPP conversion factor (GDP) to market exchange rate” (provided by WB, very accurate estimates), and “Average annual wage in 2018 constant prices at 2018 USD PPPs” (provided by OECD, not very accurate estimates)
When: 2000 – 2018
Where: 39 countries of the world
Source: EUROSTAT, OECD, WB

Posted in charts | Tagged Bump chart, Interactive, R, Wages

How well are we reducing poverty?

chart planet Posted on 2020-05-06 by Chart Planet2023-03-18
How well are we reducing poverty?

There are good news and sad news.

The good news is that we are really reducing poverty. Fewer and fewer people live for 1,90 dollars a day, fewer and fewer experience hunger, fewer and fewer experience struggle to get water.

The sad news is the realization that behind nice world trends there are still countries where one-third of the total population are poor, experience hunger and struggle to get water. And even worse – while over 40% of people in low-income countries don’t have access to BASIC drinking water service, 73% don’t have access to SAFE drinking water service.

But we’re reducing. There is still much to achieve and let’s hope for the best.

What:
Very poor people = Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population),
Hungry people = Prevalence of undernourishment (% of population),
People not having water = People not using at least basic drinking water services (% of population)
When: Improvements by income class are shown between 2000 and 2017 with possible deviations a year or two for different category combinations.
Where: Total world + the world divided into 4 income groups by the World Bank.
Source: WB

Posted in charts | Tagged Bar chart, Line chart, Poverty, R

Post navigation

<< 1 2 3 4 5 6 … 8 9 >>

subscribe to blog posts

Please check your email to confirm subscription

linkedin fb bluesky instagram tableau sessionize rss
MJDC privacy policy
↑
Cookies are used on chart planet.