Tag Archives: Google Spreadsheets

baby names Excel Google Google Docs Google Gadgets GPS information graphics internet maps plugins poll social networking social news SPSS survey Usability Walk Score Web2.0 WordPress

Google Spreadsheets Time Series Chart of Baby Name Votes

Here’s a time series chart of the first 1000 votes in our baby name poll. This shows vote totals over time using the exact same interface as the stock charts in Google Finance.

EDIT: Well, it turns out I made some pretty crazy formulas and broke my own charts. I’ll have an update soon to tell you how to make cool charts and how not to break them. The voting form works, though, so don’t be afraid to contribute.

EDIT: the chart is a little hard to read in my narrow blog format, here’s a link to the full-sized version.

The first jump on September 8th came from sending out the link to friends and family via email, through my blog, and over Facebook. The second jump, starting after 5 p.m. or so, came from an internal mailing list at work. From there the votes slowly accumulated until October 2nd, when this was featured in the internal news at work. The poll has been picked up on a couple of forums and websites now, which probably accounts for the rate increase on the 3rd.

How did I create the chart? On your spreadsheet, click the “Insert Gadget” link and choose Interactive Time Series Chart. You’ll need at least two columns, one with the timestamps from your form, and another with the vote count. Since every row represents a vote, I just used the ROW() function in the second column to get the count.

I’m still working on getting it to update automatically as new votes come in, and I’ll also see if I can get the graph to show lines for each name to see relative popularity over time.

Internet Baby Naming Update

Friends, family, my co-workers at Google, and random strangers on the internet have contributed more than 500 votes for our kid’s name. At this point we have some clear favorites, with Dylan leading the boys chart and Olivia and Ada pulling ahead on the girls chart.

I’ve decided to move all the charts to this post, I’ll try to add updates with more detail as time goes on.

First, the graph of the most popular Girls’ names:

EDIT: Well, it turns out I made some pretty crazy formulas and broke my own charts. I’ll have an update soon to tell you how to make cool charts and how not to break them. The voting form works, though, so don’t be afraid to contribute.

DOUBLE EDIT: I’ve put in static versions of the charts while I work on fixing my spreadsheet.

Here’s the graph of the most popular Boys’ names:

Here’s a familiar, if not cognitively optimum, pie chart showing who has been voting:

Just for fun, here are graphs of some of the leading names’ popularity since the 1880s from the wonderful Baby Name Wizard website.

The only problem with these graphs is that they don’t give an identifiable scale. So, you can’t easily compare the different name graphs below – note that the darker the hue, the more babies had that name.

Olivia:

Popularity of names starting with OLIVIA

OLIVIA

Continue reading

Hey Internet, Help Us Name Our Child!

Happy Anniversary at Sarava My wife and I are expecting, and thus we have to pick a name for our new baby. We’ve perused baby name websites and tried the Freakonomics tactic of predicting popular names, but to be honest none of it was really working.

As a Googler, though, the answer should have been obvious – let the Internet do it! So that’s what we’re doing, opening up our baby’s name to an Internet-wide vote.*

In the next couple days I’ll also put up a live graph of the results. If you’d like to learn how to use Google Docs and Spreadsheets to put a poll on your site (or name your baby), check out this post.

Feel free to send this link to your friends, put it up on social news sites, or write about it on your blog – the more votes the better.

If you can’t see the poll, follow this link to get to it.

EDIT: Here’s a little preview graph, with the most popular boys’ and girls’ names so far. I’ll add a graph with user-suggested names soon too.

DOUBLE EDIT: I’ve moved the graphs to the next page, so as not to influence the voting.

TRIPLE EDIT: The form isn’t working for some readers, it looks like all the visitors from neatorama have taken Docs by surprise. I’ll talk to some folks at work tomorrow. If you can’t see the form, please try back again a little later. If you subscribe to my blog you’ll see an update when I’m sure everything’s okay.

* We do reserve the right to ignore the results of the poll completely. Otherwise we’ll end up with a kid named Mr. Splashy Pants. Actually, that has a nice ring to it…