Charts and graphs let you summarize your data visually. In this video, learn how to create a specialized chart called a histogram. A histogram is a column chart that indicates the number of values that fall into a number of bins or value ranges.
- [Instructor] Charts and graphs let you summarize your data visually. In this movie, I will discuss and demonstrate how to create a specialized chart called a histogram. A histogram is a column chart that indicates the number of values that fall into a number of bins or value ranges. My sample file is the histogram workbook and you can find it in the Chapter02 folder of the exercise files collection. In column A, I have 50 values where I've captured hourly demand for a particular process.
I currently have cell A1 selected and if I press Control + down arrow, I'll move to the bottom of the list, so I can see how many values I have. And then by pressing Control + up arrow, I can move back up to the top of the column of data. If I want to create a histogram, again, to summarize using columns based on value ranges, I can select any cell in the data range and then on the Insert tab of the ribbon, go to the Charts area and I'll click the Insert Statistics Chart button.
And in the top section, I have Histogram. I will click the one on the left. And you can see that I have my chart. I won't bother changing the Chart Title. And you can see from this histogram how the values are spread out. So I have a bin from 40 to 64, so 40 would be my minimum. And then at the right, I have a value from 136 to 160. And you can see that each bin is 24 units wide. So we go 40 to 64, 64 to 88, and so on.
The height of the chart tells you how many values are within each bin. So I have 16 values within 88 to 112, and then looks like I have 12 from 112 to 136, and 15 from 64 to 88, and so on. If you want, you can change how Excel creates these bins. To do that, right-click any place on the horizontal axis. And then click Format Axis from the shortcut menu that appears. In the Format Axis task pane, you'll see under Axis Options that we have Bins.
They are currently being created automatically. And you can see that the bin width is 24. And the number of bins is 5. You can change either the bin width or the number of bins. Let's say that I select the Bin Width radio button. And I will change the value from 24 to 12. So I'll do that, press Enter, and the bins have changed. I'll clear the Format Axis task pane for a moment. And we can see the entire chart. So now we go 40 to 52, 52 to 64, and so on.
I could also set a specific number of bins instead of changing the width, the number of values. So I'll right-click a value on the horizontal axis, click Format Axis again, and now, I will select the Number of bins radio button, I currently have 10, and I will change it to 6, press Enter, and there I have my six bins. In this case, the values are even numbers, so we go from 40 to 59, 59 to 78, and so on.
However, Excel will, on occasion, use decimal values. So I might have seen 40.123 to 59.246 and so on. In this case, however, it worked out evenly and my histogram shows me how my values are distributed within my dataset.
- Distinguish between the mean, median, and mode.
- Describe the relationship between variance and standard deviation.
- Identify a nondirectional hypothesis.
- Point out the difference between COVARIANCE.P and COVARIANCE.S.
- Explain correlation.
- Analyze Bayes’ rule.