Home > ICT4D Statistics, m4d > Mobile Phone Penetration: Google Motion Chart Data Visualisation

Mobile Phone Penetration: Google Motion Chart Data Visualisation

I’ve entered the ITU data on mobile phone penetration for all countries from 1998-2008 into a Google Docs spreadsheet, and then added the Motion Chart visualiser (the same engine made famous by Hans Rosling and TED, though they use the Gapminder Trendalyzer version).

Unfortunately, WordPress scripting rules mean I can’t post the active chart here. To access the spreadsheet data and Google Motion chart, you need to go to:

http://spreadsheets.google.com/pub?key=tUzZsw5SoG_jXRDl6p8tRCg&single=true&gid=0&output=html

Screenshots below give an indicator of how you can visualise the data. The chart offers three main means to visualise (bubble, bar chart, and line graph) via tabs at the top right. You can change the axes and element colouring/size, and highlight individual countries. For bubble and bar, the main point of the chart is that you can click play (bottom left) and show how things change over time. (Note playback speed variation control, and also the ability to drag over and zoom in on parts of the chart.)

Not sure it adds a lot of analytic value but it’s engaging, helps give a sense of some overall trends, and identifies some interesting outliers. (Some older PCs and low-bandwidth connections will struggle to display.) I’ll repeat for other ITU data in later posts (e.g. broadband data visualisation here). You can find similar visualisation for mobile, Internet and a host of other development data at: http://devdata.worldbank.org/DataVisualizer (though currently up to 2007 only, no obvious access to underlying data, and the mobile data display doesn’t seem to work properly).  And, finally, on a separate blog entry you can find a set of rough converters to change mobile phone subscription data to data on ownership, access, use and non-use.

  1. 1 December 2009 at 2:24 pm

    Dear Richard,

    Great and so useful work! I’m really enjoying!

    I’m a journalist and PhD researcher om mobile phone use for citizen journalism in low-income countries.

    Do you know some relevant works (besides Voices of Africa, Ushahidi, Knight Fellowship Programs, etc)?

    I really would like to maintain contact with you.

    Best regards,

    Paulo

  2. Richard Heeks
    1 December 2009 at 3:45 pm

    On citizen journalism; a couple of applications that have a value – FrontlineSMS as already used; txteagle as just a possibility.

    Useful links on citizen journalism at MobileActive: http://mobileactive.org/taxonomy/term/925

    and The Communications Initiative: http://www.comminit.com/en/search/node/%22citizen+journalism%22

    Richard

  3. Richard Heeks
    9 December 2009 at 4:05 pm

    Some more data visualisations on mobile, provided via Prabhas Pokharel and Katrin Verclas (who is quoted here):

    http://manyeyes.alphaworks.ibm.com/manyeyes/visualizations/world-mobile-phone-costs-compariso

    http://manyeyes.alphaworks.ibm.com/manyeyes/visualizations/world-mobile-phone-costs

    http://manyeyes.alphaworks.ibm.com/manyeyes/visualizations/sms-average-voice-costs

    http://manyeyes.alphaworks.ibm.com/manyeyes/visualizations/sms-voice-costs-scatterplot-withou

    First one is a scatterplot. You can select different datasets to graph vs. each other. Mostly we put that up to see SMS vs. voice costs, graphed with size being population, or mobile phone coverage growth, or mobile phone coverage.

    The second one is just a graph of SMS, Voice, etc. To have one metric for voice costs, we took the average and minimum voice costs in each country, and you can graph that if you want.

    The third one is a comparison that includes a metric calls SMS/Voice, with a couple of outliers removed so the graph is actually interesting. Basically we took SMS costs, and divided by voice costs. High numbers mean SMS is expensive compared to voice, or voice is cheap compared to SMS.

    The fourth is the same as #3, but put on a scatterplot.

  4. Richard Heeks
    4 September 2012 at 8:22 am

    You can get figures (at time of writing) up to 2010 for mobile and other ICTs at: http://www.gapminder.org/world – select ‘Communication’ under ‘Infrastructure’ on the Y axis

  1. 13 December 2009 at 10:37 pm
  2. 9 February 2010 at 9:02 pm
  3. 16 September 2010 at 7:51 pm

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

%d bloggers like this: