 Hi, this is Dr. Don again, and this is the second video we have about creating histograms for my stat lab problems using StatCrunch and Excel. As you may remember from the previous video, and there's a link below to it, that when my stat lab has both StatCrunch and Excel available, the solutions, the correct solutions, generally follow the defaults of StatCrunch. And that's particularly true here for histograms because Excel and StatCrunch defaults for histograms are different. So I'm going to walk you through this problem, remember it is one where we're given a data set and we're asked to create three histograms, frequency histograms, with 5, 10, and 20 classes. And remember I've gone ahead and created screenshots of the solutions, and then we use those to come up with the correct solutions for StatCrunch. Now let's jump in to Excel. We're in the Excel worksheet with the data over here. I've pasted in the image of the StatCon solution, remember we matched that to the correct solution, and we know that my stat lab will default to what StatCrunch produces. Recall that we were very interested in the lower and upper bin limits, and in StatCrunch we have a bracket on the left side, the lower side, which tells us that's a closed limit, and it includes the one in this case, the value next to it. The upper limit, the right limit, has a parenthesis which is an open bracket, an open limit, and therefore the four falls into the next bin. So that's what we've got to match with Excel. Let's start by selecting our data, going to Insert, Recommended Chart, let's go to All Chart, Find Histogram, and just double-click on that to select it. And that's our basic histogram. The default for the Excel Histogram chart is three bins, and of course we want five bins. So how do we get there? One way is to left-click on the y-axis, and then right-click, and go to Format Axis, and we get a menu that opens up on the right side here, and here are our bin options. Automatic, we don't want that. Let's try the number of bins, and I want to put in five, and hit Enter, and then we're going to close this, and my goodness, that matched pretty well, doesn't it? We've got one, two, three, four, five bins, and it looks like this one. So here we've looked out a bit, and if we look at our bin limits, we can see why. You can see that Excel defaults to closed-closed, so that means the one is in the first bin, and the upper limit, 3.8, is in the first bin. And then after that, we've got open-left, closed-right, all the way there. Notice that the bin width of 2.8 was what Excel used because we did that arithmetic, right? Five into 14 is 2.8. That's what Excel used. It doesn't round up to the next integer, and that's the problem here. So we want to go back and change this again to make sure it works for whatever data set we have. Well, got lucky this time, I'm going to click on that axis again, right-click to format axis, and this time we're going to go to bin width, and we want to start with this stat crunch standard of rounding up to the integer, and I'm going to put three in and hit enter, close this so we can see it again, and now it doesn't match. But if we look at our limits, we can see it goes to one to four, and four is included in this first bin. We want it in the second bin. So what I found works pretty well. I'm going to go back here, right-click, format axis again, and instead of putting in 3.0, which is my rounded, I'm going to finesse this a bit, and I found that if I put in a value that's close to that, but smaller, that'll force that integer into the next bin. So I'm going to put in 2.999, hit enter, and then close this, and we can see now it matches, and we can also pretty this up to double check by adding our data labels, and then we've checked against the stat crunch, we'd see it match the 5, 7, 5, 5, 5, 5, 3. So that worked pretty well for the five classes, five bins. Let's change it now, and all we have to do is to click again to select the axis, format axis, and now we want to go up to the 10, and remember it's width was 2, but we're going to, again, finesse that down to 1.999 and hit enter, and close, and we can inspect and see that here it was 1 to 3, so the 3 would be in the second bin, and here we forced it to 1.2999, which means the 3 falls in the next bin, and then generally because we're so close to that 3, you should work out pretty well, particularly when you have integer values. If you had values with a lot of decimals, you would probably want to make this 1.999,999. You know, the more decimals you have in your data, the more decimals you would need when you do this finessing. So that works out for our second chart with 10 bins. We just repeat that again. I'm going to right click format axis, and this time I'm just going to put in 0.999, enter, and by inspecting the stat-crunt solution for 20 classes, we can see that we have a match of the pattern, and that's all you need for getting the right answer in my stat lab and these kinds of problems. I hope this helps.