How to do histogram in excel

broken image
broken image

Why don't we just define all of the buckets here? So the next one is ages 10 to 19, then 20 to 29, then 30 to 39, and 40 to 49, 50 to 59, let me make sure you can read that properly, then you have 60 to 69. So let's say the first one is ages zero to nine. It's the number (laughing), it's the number in the bucket. Number, I'll just write the number, oops. So the bucket, I like to think of it more of as a bucket, the bucket and then the number in the bucket. And so how could you do that? Well one way to think about it, is to put these ages into different buckets, and then to think about how many people are there in each of those buckets? Or sometimes someone might say how many in each of those bins? So let's do that. And so you're interested in somehow presenting this, somehow visualizing the distribution of the ages, because you want just say, well, are there more young people? Are there more teenagers? Are there more middle-aged people? Are there more seniors here? And so when you just look at these numbers it really doesn't give you a good sense of it.

broken image

And so these are the ages of everyone in the restaurant at that moment.

broken image

So you go around the restaurant and you write down everyone's age. So let's say you were to go to a restaurant and just out of curiosity you want to see what the makeup of the ages at the restaurant are.

broken image