Utah Population by County

I found the 2000 U.S. Census population data for each county in Utah last night (I guess it was early this morning). I used GEGraph to create a 3D bar chart of population by county. I did it several times to explore the options, and came up with two that I really liked (one I adjusted after importing it into Google Earth).

The one that I will say was naturally occurring was one where both the height and diameter of the cylinder are scaled relative to the distribution of the population across counties. This one really gives you a good sense of how small the populations of most of the counties are when compared with those counties on the Wasatch Front (Utah, Salt Lake, Davis, and Weber).

The second one had only the height of the cylinder changed with respect to population distribution. The diameters of all of them were the same. Once I got this imported into GE I selected each of the 29 individually and edited their points so that the shape was no longer cylindrical, but instead matched the general shape of the county itself. This view is nice when trying to read the data because the polyhedrons provide a solid background for viewing the text.

The .kml files for both of these are available, but you must email me for them, as I have not yet figured out where I can post them online. I have a couple of options, but they are down at the moment. When I find something I will update this post.

My next project is to figure out how to get all my iTunes library into Fathom. I can get the music in easy enough, but am looking at a way to include the podcasts and the movies as well.

iTunes Data in Fathom

This afternoon in our PCMI SSTP (Secondary School Teachers Program) data working group we had the chance to mess around with Fathom. I have not been overly impressed to this point with the friendliness of the Fathom interface, but am getting more comfortable as I play with it. I am not convinced that I will be letting my students touch it anytime soon, but as the start of the school year is still two months away, that is ok.

I was wondering how to spend the two hours of Fathom-time and I decided to see if I could import the data from my iTunes library. I had to fiddle with things a bit, but after

1. choosing export from the iTunes File menu (not Export Library...), and then
   
2. importing this .txt file into an Excel spreadsheet,
   
3. cleaning up the data a bit,
   
4. exporting it as tab delineated .txt file, and then
   
5. importing this file into Fathom I had my data in the form of a collection.

I created a box plot that had Genre as the y-axis and Play Count as the x-axis. From this I determined that my country music songs are played more often than the other genres that I had. A histogram showed that the number of country songs in my iTunes is larger than the number of songs from any other genre. A dot plot with file size on the y-axis and time of song (which shows in seconds) on the x-axis showed a linear pattern with very few files outside the lines. The files with larger file sizes relative to the length of the song were files of the MPEG audio format. This makes some good sense, since the default in iTunes is to import songs in the more compressed AAC format.

It wouldn't be too much trouble to design a lesson where we compiled students' iTunes library information and looked for trends among classes or found the equation of the line that fits the dot plot of song length vs. file size. I am sure I will get time to look at this over the course of the next few weeks.