Category Archives: Scatter chart

Scatter plot showing changes in male and female tobacco smoking rates from 2000 to 2015

The scatter chart below shows the change in male and female tobacco smoking rates in different countries between 2000 and 2015. In addition, countries are color-coded by their income levels.

Almost all countries have seen female smoking rates drop – the Russian Federation and the Czech Republic are the two exceptions. Male smoking rates have also dropped in most countries. However, several African and Middle Eastern countries saw a rise.  The shaded green area indicates the part of the chart where both female and male smoking rates dropped.

2x2 scatter plot showing change in smoking rates in different countries

Changes in smoking rates between 2000 and 2015 in various countries depicted in scatter diagram

This chart was built using the Aploris add-in for PowerPoint on a Mac.

Link between health spending and life expectancy

The scatter chart below shows the relationship between life expectancy and health expenditure for a variety of countries. The x-axis shows life expectancy at birth and the y-axis shows healthcare spend per capita for each year of life expectancy (in 2010 international dollars). Countries are color coded based on their region.

In general, the more countries spend on healthcare the longer their citizens live.  However, the US is a significant outlier. The US spends much more than any other country but its life expectancy is below many. The source article (https://ourworldindata.org/the-link-between-life-expectancy-and-health-spending-us-focus) plots health expenditure per capita on the y-axis (instead of healthcare spend per capita for each year of life expectancy). However, we find that their visualization is not as effective in calling out the US as an outlier.

Scatter plot showing healthcare spending/life expectancy

Scatter plot showing the relationship between health spending and life expectancy

This chart was built with the Aploris PowerPoint add-in.

Scatter plots exploring relationship between heart rate and lifespan across different mammals

The scatter plots below examine the relationship between a mammal’s resting heart rate and its lifespan. The chart on the left compares heart rate to longevity of life span in years and the chart on the right compares heart rate to total lifetime heart beats. For both charts, log x and y axes are used to help make the relationships clear and to span the large scale. From the left chart we can see that there is an inverse relationship between longevity and heart rate.  However, a visual inspection of the right chart shows that lifetime heartbeats and heart are largely unrelated.

Scatter plots showing relationship between mammal heart rate and lifespan

Scatter plots showing relationship between heart rate and longevity/lifetime heart beats across different mammals

These charts or graphs were built using the Aploris add-in with the latest 64-bit release of PowerPoint for Mac. Aploris is a data visualization add-in for Mac and PC that helps PowerPoint users build better charts.

Scatter plot showing percent of words spoken by female characters in select Disney movies

The scatter plot below shows the percent of words spoken by female characters in select Disney movies over the last 30 years. With recent movies including Maleficent, Inside Out, Into the Woods, and Frozen, Disney may be putting an emphasis on having female characters speak more. However, most movies are still dominated by male characters. Even movies that feature female characters like Mulan and Pocahontas have over 65% of words spoken my male characters.

Scatter plot showing percent of words spoken by female characters in Disney movies

Scatter plot showing percent of words smoking by female characters in Disney movies

Note that Sleeping Beauty and Alice in Wonderland, both released in the 50s, had over 60% of words spoken by a female character and are not included here.

This scatter chart was built using the Aploris add-in for PowerPoint. Aploris enables users to build a variety of charts including Mekkos and waterfalls.

 

Are high CO2 emitters less intensely concerned about climate change?

The scatter chart below shows the relationship between a country’s concern for climate change and the amount of CO2 it emits per capita. The original source  zooms in and limits the y-axis between 8 and 12 on the climate change concern index. As result, it visually suggests a relatively strong correlation that high CO2 emitting countries are less concerned with climate change. Displaying the entire working range of the y-axis still suggests this correlation but it is less visually strong (note that lowest value concern index possible is 3).

Scatter chart of climate change concern and CO2 emission

Scatter plot showing correlation between a country’s climate change concern and CO2 emissions

The scatter chart was built using with PowerPoint using the Aploris charts add-in. Data provided by Pew Research Center.

Scatter plot showing the value of tweets by top endorsed athletes

The scatter plot below shows the number of Twitter followers (x-axis) and the potential price to buy a Twitter endorsement (y-axis) from some of the top endorsed athletes. The trend line shows that there is a correlation between the number of followers and the price per tweet.

The scatter plot is an effective way to display two dimensional numerical data. If we wanted to add additional numerical information, such as the total yearly endorsement for each athlete, we would have used a bubble chart instead.

This data is from Opendorse and only includes top 15 endorsed athletes with Twitter accounts.

Scatter plot showing number of twitter followers and estimated price/tweet for top endorsed athletes

Scatter plot showing number of twitter followers and estimated price/tweet for top endorsed athletes