Graphing complicated data
June 1, 2007 3:00 PM Subscribe
I need help graphically representing some data.
So I’ve got this data. Each item is three digits long. The first digit refers to um say hair colour (1 brown, 2 blonde, 3 black 4 white 5 red), the second digit to hair length (say nearest inch) and the third as to whether the hair is curly (1)or not. (0). So a short sample of my data set might be like this: 121, 220, 310, 320, 120, 111, 430, 501.
I can quite easily separate the numbers from each other (text to columns excel) if necessary. Excel & Illustrator are my tools. I do not have a budget to change that. I have high school maths skills. My audience will be middle school teachers. (Obviously the data set isn’t really hair styles).
How do I graph this? How do I show visually that most of my sample don’t have curly hair, but the shorter the hair the more likely it is to be curly? What are good terms to search for graphing techniques that will narrow down my results?
I do know about this website http://infosthetics.com/ but what am I looking for, exactly? I did think of colour coding the digits and sorting by most common, but the problem is the digits in each of the columns has a different meaning. Brown <> 1 inch <> curly.
posted by b33j to Media & Arts (12 answers total) 3 users marked this as a favorite
You can easily do this in Excel.
posted by Loto at 3:09 PM on June 1, 2007