Home > ICT4D Statistics > Broadband Penetration Over Time: Data Visualisation with Google Motion Chart, Gapminder and Excel

Broadband Penetration Over Time: Data Visualisation with Google Motion Chart, Gapminder and Excel

I’ve entered the ITU data on broadband penetration for all countries from 1998-2008 into a Google Docs spreadsheet, and then added the Motion Chart visualiser.

To access the spreadsheet data and Google Motion chart, go to: http://spreadsheets.google.com/pub?key=tuY4rmkYVhRxKCXiltg_obg&output=html

The screenshot below gives an example. Also given below are two screenshot summary graphs derived from overview data about diffusion rates for broadband, which can be found at: http://spreadsheets.google.com/pub?key=tCyqBGWg0E8qg6qG77ltZ2g&output=html.

The most useful statistics are absolute growth rates (weighted by population), which show growth having peaked in 2005 for the richest fifth of nations, but generally still rising for the others. The percentage growth rates have been steadily declining, but mainly because those growth figures are insanely high in the first few years of broadband diffusion given the very low base they start from.

You can find similar visualisations that you can cross-match with a host of other data categories (demographics, economic/social development, and ICT diffusion) using World Bank data (http://devdata.worldbank.org/DataVisualizer/) or a graph I’ve created at Gapminder: http://bit.ly/78IWkN. But these don’t go up to 2008, and you can’t see or access the underlying data.

Note the dynamic visualisation charts will not show up on slower PCs or Internet connections.

For similar data visualisation of mobile phone penetration, see my earlier blog entry at: https://ict4dblog.wordpress.com/2009/11/30/mobile-phone-penetration-google-motion-chart-data-visualisation/

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 555 other followers

%d bloggers like this: