An unofficial blog that watches Google's attempts to move your operating system online since 2005. Not affiliated with Google.

Send your tips to gostips@gmail.com.

July 10, 2007

Swivel - Draw Conclusions from Data

Swivel is a place where you can upload data, create nice graphs and try to draw wise conclusions from it. "Swivel's mission is to liberate the world's data and make it useful so new insights can be discovered and shared." I happen to know a company with a similar mission (Google's mission is to organize the world's information and make it universally accessible and useful).

You can also correlate data from different sources and transform lifeless spreadsheets into interesting conclusions about the world. So you could try to find the number of Google employees over time and see if there's any correlation with Google's stock price, revenue or market share in search.

Swivel lets you use a list of existing tables or upload your own data as a CSV file (Google Spreadsheets has the option to export a sheet as a CSV file, like most spreadsheet apps).

It's important to make the distinction between correlation and causality. "A key thing to remember when working with correlations is never to assume a correlation means that a change in one variable causes a change in another. Sales of personal computers and athletic shoes have both risen strongly in the last several years and there is a high correlation between them, but you cannot assume that buying computers causes people to buy athletic shoes (or vice versa)."

Google hiring faster than it can afford?

5 comments:

  1. All Google needs to do is add charting to its Docs & Spreadsheets site.

    ReplyDelete
  2. Google Spreadsheets has charts (even though you can import charts from existing spreadsheets or export the charts when you save a spreadsheet as .xls).

    ReplyDelete
  3. If you could just define the colors. Red against red is simply a stupid choice.

    ReplyDelete
  4. You can actually change the colors, but I forgot to do that. Thanks.

    ReplyDelete
  5. I would like to see more cell formatting (espeacially for time and date) options in the Spreadsheets.

    ReplyDelete