From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,900 courses taught by industry experts.
Frequency table
From the course: Complete Guide to Excel Statistics with Copilot
Frequency table
- [Instructor] A frequency table is a very simple, but very helpful tool when you're trying to get to know your data set. It allows you to put your data points in the buckets. For example, with exam scores, it allows you to see how many students scored between 90 and 100, how many scored between 80 and 89, and so on and so forth. This table will then help us create a bar chart or histogram that represents the same distribution in graphical form. In this video, we'll focus on a few different ways you can create a frequency table in Excel. In our next video, we'll use the same table to create the histogram. Okay, let's get started. So when we have a really small data set, as we see right here, five test scores, we don't really need a frequency table, do we? We can tell that there's one exam score in the 60s, one in the 70s, one in the 80s, and that there are two in the 90s. The issue is when we have 221 test scores and putting those into buckets of 90s, 80s, 70s, and so on. Now, what…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.