 Hi folks. This is Dr. Don. I want to show you how to use the Excel data analysis histogram tool. I'm not going to give you all the background information here on how I set this up. Here's the data that I have. It's a matrix of a number of points. I don't know how many and it said response time and minutes as customer calls. I've gone ahead and done this plenary work. Found the minimum maximum. From that I got the range. Number of bends. We were given by the problem. I wanted 10. And using any information you get the bend width and then I round that off to two decimal places. Once I get the bend width and I need 10 bends, I set the lower limit at .91, add the bend width to get the upper limit, and then complete this setup. So, we have this information. Now let's use the data analysis tool to get the histogram. We click on data, analysis, bring up a dialog box, histogram, click OK. We've got to give it the input range. I want to clear out what was there. And my input range is this matrix over here. Get that all selected. My bend range. Clear that again. Complete. They want the upper limit of the bends. And we don't have labels. My output. I'm going to want that again, and I'm going to select that cell there to get the tabular data. On this particular example, I'm going to get the histogram. So I need to check the chart output. And also I want the cumulative percentage, which you may find on some of your assignments. And that's all I need. I click OK. And we get this information. I'm going to move things over a bit here. Spanned a bit. Here's the rough histogram. We've got our bends, the frequency in each bend, and then the cumulative frequency. Now I'm going to make this bigger so you can see it. And again, this is a rough histogram, but we've got our cumulative frequency plotted as well on a secondary axis, which is helpful. What we need to do is to clean this up to get rid of the gaps. Remember, a histogram is for continuous data, which does not have gaps. This is just a column chart that Excel diverges to. We left click on one of the data points and then right click to get format data series. And we need to remove the gap, which corrects that problem. Let's click over here to the border. And I want a solid line. And I want it to show up. So I'm going to select black. And so that has created our rough histogram. You can go on in the other videos to learn how to change the information that's presented on the bend axes. But this is the basics of it. And you can fine tune it from there. So I hope this helps.