Look Who it Was Random video

Excel - Frequency Distribution in Excel: Formula vs. Pivot Table | Dueling Excel - Episode 1040

1,419 views · Published 19 June 2009 · 5:48 · Indexed 1 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Frequency Distribution in Excel: Formula vs. Pivot Table | Dueling Excel.

Welcome to another dueling Excel podcast! I'm Bill Jelen from MrExcel and I'm here with Mike Girvin from Excel Is Fun. Today, we're going to show you how to create a frequency distribution in Excel. Mike will demonstrate some formula methods and I'll show you an easy way to do it using a pivot table.

So, what exactly is a frequency distribution? It's a way to group data and count the number of occurrences within each group. For example, if we have a set of values and we want to group them into categories of 5, we can use a frequency distribution to see how many values fall into each category.

Mike will start us off by using the frequency function. This function requires us to specify the upper limit for each category, and then it will count the number of values that fall within that range. However, we can also use other formulas like SUMPRODUCT or COUNTIFS to create a frequency distribution when the upper limit is not included.

But, if you're looking for a simpler and more efficient way to create a frequency distribution, I'll show you how to do it using a pivot table. By inserting a table and grouping the data by 5 unit increments, we can easily see the frequency of values in each category without having to use any formulas.

So, whether you prefer using formulas or pivot tables, we've got you covered with different methods to create a frequency distribution in Excel. Thanks for watching and don't forget to subscribe to our channel for more Excel tips and tricks. See you next time for another dueling Excel podcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 shows you how.

Table of Contents:
(00:00) Introduction by Bill Jelen
(00:24) Welcome back to another dueling Excel podcast
(00:34) Question: How to create a frequency distribution from data?
(00:44) Mike demonstrates formula method
(02:40) Mike explains how to customize labels
(03:05) Mike discusses using the frequency function
(04:30) Bill demonstrates pivot table method
(05:30) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
COUNTIF function in Excel
COUNTIFS function in Excel
Easy way to create frequency distribution in Excel
Excel tips
Formula ways to create frequency distribution
Frequency distribution in Excel
Frequency function in Excel
Labels in frequency distribution
Pivot table in Excel
Subtracting values in Excel
SUMPRODUCT function in Excel
Upper limits in frequency function

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152467/

More from this channel