 Statistics and Excel. Combining two histograms on one chart, part number one. Get ready, take it a deep breath, holding it in for 10 seconds, looking forward to a smooth, soothing Excel. Here we are in Excel. If you don't have access to this workbook, that's okay because we'll basically build this from a blank worksheet. But if you do have access to this workbook, three tabs down below. Example, practice blank. Example, in essence, answer key. Practice tab, having pre-formatted cells so you can get right to the heart of the practice problem. Blank tab, just having the data within it so we can practice formatting cells as we work through the practice problem. Also note, if you don't have access to the data set, you can take a look at Kaggle K-A-G-G-L-E dot com as a source to look for some sample data sets. This one's related to height. We're going to go to the tab on the left, the example tab to get an idea of what we will be doing. We'll format our data into a table, calculate the average, and then we'll make a histogram from that data, given the fact that it's data about height, we would expect it to be somewhat bell shaped as it is here. Then in order to put two sets of data together, we're going to recreate our histogram with a bar type chart. So we'll format it in this format so we can make a bar chart, the bar chart being easier to overlay another chart on top of. Then we'll take our current data set and we'll kind of imagine that this is for men, and then we'll do another calculation to make a similar data set for women, just so we have some numbers to practice with. Then we could imagine that if we put those two data sets together, it would look something like this, but what we really want to do is try to create something like this. So now you've got basically the two histograms that you can see are distinct from each other and kind of offset it as we can see here. Alright, so let's go to the blink tab. We'll build this in a few presentations. I'm going to get rid of this Kaggle in the middle here and let's start off by just formatting our entire worksheet. That's our starting point typically. So I will then select the tab up top, the triangle, right click on the worksheet on the highlighted or selected area, format the cells. I'm going to go into the currency, negative numbers to be bracketed and red, get rid of the dollar sign. And here you'll note that there's multiple decimal places. So maybe I want to keep the decimal, but I'll round it to two decimal places, which will round off some of these numbers simply to do two decimals. So I'm going to say, okay, that looks good. Then I'll bold the whole thing, home tab, font group and emboldened the whole thing. Alright, I'm going to hold control and scroll up a little bit. So I'm currently at 265 on the zoom in. Now I'm going to create a table around our data set. So I'm going to go to the insert tab to do that tables and create a table. And so it's selecting the entire data set with the dancing ants doing a mamba around it. You can't see, again, you can't see their hips shaking or anything. But if you were to zoom in, their hips are shaking and they're getting into it when they're dancing. So it's not like a march. You would think they're marching, but they're not. They're totally into, they're totally like dancing. In any case, I'm going to put a space in between these two. I'm going to make this a little bit smaller and then wrap the text up top. So we're going to go to the home tab and alignment. Let's wrap the text and center it alignment and center. So now we could sort the data if we wanted to. And this is we have a fairly long data set. Notice that this is a pretty extended amount of a sample of data. So it's still a sample of data. So we're taking all of this data set as a sample of data. And if we had, it's down to 25,000 out of the population of a population. So if we take that and we make a histogram from it. So I'm just going to select the whole data set by putting my cursor on the dropdown. Now I've got all the data selected and we can go to the histogram we've seen in the past. Just go to the insert tab, charts, group, drop down on the histogram. And we want a histogram. Boom. It makes a pretty nice histogram here. I'm going to get rid of the title and then as we would expect with data like this. That's about, I'm going to make it a little larger height. We get a nice distribution because we have a very large, you know, sample of data that we have. So we've got the buckets that have been made down below. So we've got our buckets. And so 60.28 to 60.51, I believe these are in inches. So if you wanted to, you know, divide by 12 to get the feet or whatever. So if we wanted to convert to feet, you know, and so this middle point seems to be around 68. So again, if you wanted to convert this to feet, it's be something like 60, 68 divided by 12. You know, 5.67. So in any case, that's here. So, all right. So then, so now note, when I look at this plot, it's difficult to add another data set basically on top of this one, right? If I select the entire data set, then, then, you know, I can add another set of data set in it. If I want to lie something on top of it, it might be useful to for us to format the data in such a way that we can make a bar type of a column chart instead of a histogram. So we want to make a histogram using this tool instead of this tool, and then we'll be able to possibly put the two sets of data on top of each other. So let's first think about how to do that. How can I recreate this histogram? Well, I can, I can look at my data sets down here. I'm going to make a skinny bee column. Let's make a skinny bee and I'm going to make this a little bit wider and I'm going to mirror my buckets down here. So I've got the buckets from 6028 to 6051 and then 60.74 to 60.97. We could change those bucket sizes, by the way, by clicking on the histogram and then adjust the bend width if we so choose, which is currently at 0.23 difference. And we have 65 bends. So let's imagine down here that I'm going to have then let's do one more down. I'm going to say 60.28 and then it's going to 60.51. So I'm just copying this 60.28 to 6051. And then the bend width we can see is 23 difference. So if I go up, this is going to be equal to the one above it plus 0.23 should give us to the 6051, which is basically the ending bucket over here. And then I'm going to do the same thing this way. I'm going to say this equals this plus 0.23. And so I'm going to select those two and copy them down. And so now I've got now I've got the 60.74 here to the 60.97. And so if I keep copying that down, I want to copy it down.