Kerrie blogged yesterday about a recent release of data from the ABS. The bit which caught my attention was:
my first thought was - what lovely statistical stuff for kids to play with in Excel. For example in a file called Schools by category, we have snapshots of numbers of schools in Government, Catholic, and Independent sectors over the period of 1986-2006. You could do all sorts of lovely charts!
Fortunately we don’t need Excel to show those charts anymore. There’s a number of web based services which will let you do that analysis online and share the results quickly.
Probably the easiest is Swivel.com. It’s still in beta, and there are occasional issues with the data imports, but you don’t even need to think about what graphs you want - it will just produce just about anything possible for you. Below is a sample, but you’ll probably want to look at the graph page for the legend etc.
Swivel’s also got a nice feature where you can compare one graph to another. I was hoping to use it to try and find a corallation between the unemployment rate and retention rates, but I couldn’t get it to work very well.
But what if you want to look at the data like you could in Excel? Fortunately there are options for that, too.
Firstly Google Spreadsheets:
Secondly, Zoho Sheet:
Post a Comment