Statistics help needed
Well, it seems I bit off more than I can chew with my recent poll on Web browser window size. I now have, thanks to the help of a clever Ruby script Frode Danielsen sent me, a CSV file (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.
Update: Thanks for helping me out, everybody! I think I have what I need, so I don’t want to occupy any more of your time with this :-).
Update (2007-04-15): I have published the results of the poll in Poll results: 50.4% of respondents maximise windows.
- Previous post: Guidelines for creating better markup
- Next post: Poll results: 50.4% of respondents maximise windows