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
From the course: Complete Guide to Excel Statistics with Copilot
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.