From the course: Complete Guide to Excel Statistics with Copilot

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Histogram

Histogram

- [Instructor] In the previous video, we discovered a few different ways to create a frequency table. Now, let's use that same table to develop a histogram, a bar chart that helps us visualize our data, a bar chart that will likely help your audience understand the distribution and hopefully lead them to more informed conclusions, or perhaps lead them to asking interesting and important questions. Let's go ahead and build our histogram. So, here's our frequency table. The first thing that we're going to want to do is we're going to want to highlight our data. So, we're going to highlight the data that we want to put onto our histogram. Next thing, we're going to go up here into the Insert menu. There, you're going to see that there are a couple options that you can choose from. One is you can go to the bar charts and choose any one of those. You can also go in here into Recommended Charts, and you'll notice, first one right at the top, it's recommending a histogram. So, it's the same…

Contents