 Statistics and Excel. Combining two histograms on one chart, part number three. Get ready, taking a deep breath, holding it in for ten seconds and 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 basically built this from a blank worksheet. However, we started in a prior presentation with just our data set. 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 could get right to the heart of the practice problem. Blank tab is where we started with just our data set so that we can practice formatting cells within Excel as we work through the practice problem. So what did we do last time? We had our data set on the left related to heights. We created a table with it. We then made a histogram from it. Now, because we're dealing with heights and we have a pretty extensive sample of heights, we get this nice shape which looks kind of like a bell type shape where we have most of the results somewhere in the middle and they're tapering off to either side. Then our objective is to take two data sets and put them on the same chart. To do that, it's not so easy to do if I go to the Insert tab with just a histogram, easier with, say, a bar chart. So what we did is mirror our histogram with a bar chart by creating our buckets manually, not really manually, but using Excel to do it instead of using a histogram to do it, and then we created a bar chart. So now we have something that we might be able to plot some other data on it as well. So we then said let's take our data set and make another related data set. Now, to do that, we just took the prior data set times 0.95, imagining this was for men, this was for women. That's not actually the case with this data set, but it just gives us an idea of what we can now do. So we then made a histogram from that data set and it looks similar to this histogram, but the middle point is different because of course we just shifted it by multiplying by 0.95 on the second data set. We then created a bar chart in a similar way as we did over here, but we wanted to make the buckets line up to the same buckets. This is where it gets kind of tricky because these bucket size, if you want to put two of these bar charts on the same graph, you want to have the same bucket sizes. So we took these bucket sizes over here and extended them to the lower regions so that we have enough buckets to contain all the data sets for the men and the women. Alright, so now we're going to put them on the same graph. Now before we do that, let's imagine that we just put them on top of each other. Like if we added these two data sets together in one data set and we made one histogram from it, it's going to come up with a mush, just a bunch of, it's not going to separate the two data, so let me show you what I mean. So let's copy this entire data set right here for the heights. I'm going to put my cursor up top. Let's just select the entire column of Z and then I'm going to right click and copy. I'll bring that on over to the right and let's just test that out in AY. We'll right click and I'm just going to paste it. Did I paste it 1, 2, 3? Let's undo that. Let's just paste it normal. Paste it normal. I did paste it normal. Okay, so it pulled in and then I'm going to go back on over. And I'm also going to take the data set for the women. Now I'm going to copy just the women's data by putting my cursor in the dropdown and copying just the data. So now I'm not getting the header and right click and copy. And then I want to put this underneath so we have this very large data set. So I'm going to go into the data set. This goes down quite far. So to get to the bottom, I'm going to hit control shift and down. That takes me to the bottom and then I'm just going to paste the data right here at the bottom. I'm way down here, 25,000. So I'm going to right click and paste this data. Let's paste this 1, 2, 3. And so now we have all this data going all the way down to 5,000 lines. We just put the two data sets on top of each other. What would that do if we entered the histogram to it? Let's put a table around it just to lock this in place. So I'm going to go to the insert tab, table group and insert a table. And so it's going all the way down to 5,000. That looks right. The dancing ants are doing their mamba around the proper location. I don't care if they're dancing as long as they're doing the work, right? You work hard, you play hard. If the ants want to dance, then they can as long as they get it done. As long as you get it done. That's what I'm talking about. Anyway, so then I'm going to go over here and I'm going to insert, let's put our cursor up top. And so now I'm going to select all that data and let's just make a histogram from that. So I'm going to go to the insert charts and then drop down and let's make a histogram. So there it is. So now you'll notice what happened here is it kind of mushed the two histograms together, right? So when you do that, you might expect that it's going to give you kind of two histograms or something. But no, it's going to mush all the data together so I can't really separate the two data sets so we get this wider histogram as opposed to, so you can kind of imagine what happened here, right? We had these two histograms that we had, this one, and this one. We took the two data sets and put them together and we get something that looks like this. And you can imagine these are really kind of two histograms that are kind of mushed together because if we break them out in two data sets, let's do that now. So now what I want to do is say, well, what I'd like to do is show two different data sets, maybe have them as a different color. So what I want to do is take my buckets, take all this stuff that we made for the men and the women. And I'll put them together and then put them on the same graph. So let's put them together like that. I'm going to go to the left and let's choose this whole data set. All I really need are the buckets that we made and then the results. So I'm going to copy that. So I'm going to take this all the way down and right click and copy. And I'm going to go to the right to where we want to put it. And so we'll put it.