456 Berea Street
14th Apr 2007, 08:31 pm
Well, it seems I bit off more than I can chew with my recent poll on Web browser window size (http://www.456bereastreet.com/archive/200703/poll_do_you_maximise_your_browser_window/). I now have, thanks to the help of a clever Ruby script Frode Danielsen (http://frode.danielsen.net/) sent me, a CSV file (results.csv (http://www.456bereastreet.com/lab/polls/window-size/results.csv)) containing information about 1385 different setups. But I cannot for the life of me figure out how to get anything useful out of it.
I am a complete spreadsheet illiterate, but I gave it a try. Opening the file and getting the data into three different columns is easy. But what then? How can I turn that into a few nice pie-chart diagrams? I have spent (too) many hours on this, looking through the completely useless help in Excel, googling for help, and throwing things across the room in frustration.
I just don't get it, and am about to give up. Are there better applications than Excel or OpenOffice Calc for this kind of thing?
If you know how to turn the data in the CSV file into something useful, feel free to do so. I would also really appreciate some pointers to help with this. Not understanding how to do something that should be really simple is extremely frustrating.
Visit site to read or post comments… (http://www.456bereastreet.com/archive/200704/statistics_help_needed/#comments)Add 456 Berea Street to your Technorati favorites. (http://technorati.com/faves?add=http://www.456bereastreet.com)
Posted in Usability (http://www.456bereastreet.com/archive/categories/usability/).
http://feeds.feedburner.com/~a/456bereastreet?i=6wziFz</img> (http://feeds.feedburner.com/~a/456bereastreet?a=6wziFz)
http://feeds.feedburner.com/~f/456bereastreet?i=65cqu3mD</img> (http://feeds.feedburner.com/~f/456bereastreet?a=65cqu3mD) http://feeds.feedburner.com/~f/456bereastreet?i=e2A9BHzm</img> (http://feeds.feedburner.com/~f/456bereastreet?a=e2A9BHzm) http://feeds.feedburner.com/~f/456bereastreet?i=YpvtKAMr</img> (http://feeds.feedburner.com/~f/456bereastreet?a=YpvtKAMr)
More... (http://www.456bereastreet.com/archive/200704/statistics_help_needed/)
I am a complete spreadsheet illiterate, but I gave it a try. Opening the file and getting the data into three different columns is easy. But what then? How can I turn that into a few nice pie-chart diagrams? I have spent (too) many hours on this, looking through the completely useless help in Excel, googling for help, and throwing things across the room in frustration.
I just don't get it, and am about to give up. Are there better applications than Excel or OpenOffice Calc for this kind of thing?
If you know how to turn the data in the CSV file into something useful, feel free to do so. I would also really appreciate some pointers to help with this. Not understanding how to do something that should be really simple is extremely frustrating.
Visit site to read or post comments… (http://www.456bereastreet.com/archive/200704/statistics_help_needed/#comments)Add 456 Berea Street to your Technorati favorites. (http://technorati.com/faves?add=http://www.456bereastreet.com)
Posted in Usability (http://www.456bereastreet.com/archive/categories/usability/).
http://feeds.feedburner.com/~a/456bereastreet?i=6wziFz</img> (http://feeds.feedburner.com/~a/456bereastreet?a=6wziFz)
http://feeds.feedburner.com/~f/456bereastreet?i=65cqu3mD</img> (http://feeds.feedburner.com/~f/456bereastreet?a=65cqu3mD) http://feeds.feedburner.com/~f/456bereastreet?i=e2A9BHzm</img> (http://feeds.feedburner.com/~f/456bereastreet?a=e2A9BHzm) http://feeds.feedburner.com/~f/456bereastreet?i=YpvtKAMr</img> (http://feeds.feedburner.com/~f/456bereastreet?a=YpvtKAMr)
More... (http://www.456bereastreet.com/archive/200704/statistics_help_needed/)