Frequency Distribution: Complete Guide with Tables, Types, Graphs & Tools

For a visual output, try the frequency distribution table maker or the histogram maker.

What Is a Frequency Distribution?

Raw data — a column of 200 exam scores, a list of 500 customer wait times — does not tell you much on its own. You cannot see where the values cluster, how spread out they are, or whether any pattern exists. A frequency distribution fixes that by grouping each value with a count of how many times it appears.

The word frequency here just means count — how many times something shows up. Once you have all the counts, patterns that were invisible in the raw list become obvious: where do most values concentrate? Are there any gaps? Is the data roughly symmetric or does it lean heavily to one side?

Frequency distributions sit inside descriptive statistics, the branch of statistics focused on summarizing what your data looks like before you make any inferences. They connect directly to measures like the mean, median, and mode — all of which you can calculate from a frequency table — and to visual tools like the histogram.

Here is a simple example to keep in mind throughout this guide. Suppose 20 customers rate your product on a scale of 1–5:

That table is a frequency distribution. It shows at a glance that ratings of 4 were the most common and that ratings of 1 were rare. You will see this same dataset transformed into all four types in the next section.

The 4 Types of Frequency Distribution

Every frequency distribution is one of four kinds, depending on how the data is organized and what the count column represents. Here is what distinguishes them:

The Same Dataset in All Four Types

No competitor page shows you this. Below is the customer rating dataset from above displayed as all four types side by side, so the differences are concrete rather than abstract.

Reading across a single row — say, rating = 3 — tells you four different things at once: 5 people gave that rating, which is 25% of all respondents, 10 people rated it 3 or lower, and 50% of all respondents gave a 3 or lower. Each column answers a different question about the same data.

Grouped Frequency Distribution

When data is continuous or has too many distinct values to list individually, you split the range into equal-width intervals called class intervals or bins. Here is the same kind of data but now using exam scores from a class of 40 students:

The midpoint column — the average of each class's lower and upper boundary — is how you estimate the mean from a grouped table. The 70–79 class has the most students, so the mode class is 70–79. And from the cumulative frequency column, you can see that exactly half the class (20 students) scored below the 70–79 range, which is where you would look to interpolate the median.

How to Build a Frequency Distribution Table (Step-by-Step)

The process below applies to grouped data. For ungrouped data, steps 3 and 4 are skipped — you simply list each distinct value and count how many times it appears.

Key Formulas at a Glance

These are the formulas you will use most often when working with frequency distributions. No competitor page consolidates all of them in one place — bookmark this section as a quick reference.

Once you have the mean from a frequency table, you can move into standard deviation and variance calculations — those formulas also use class midpoints and frequencies in the same way.

Visualizing Frequency Distributions

A frequency table tells you the numbers; a graph shows you the shape. Each chart type suits different data and different questions.

Histogram

A histogram is the standard graph for a grouped frequency distribution of continuous data. Each bar represents one class interval, and the bar's height equals the class frequency (or relative frequency). The bars touch — no gaps — because the class intervals are contiguous on a number line.

Build a histogram in seconds with the site's histogram maker.

Bar Chart

Use a bar chart when your data is categorical (e.g., preferred payment methods: cash, card, app) or discrete with a small number of possible values (e.g., number of children: 0, 1, 2, 3, 4+). The height of each bar is the frequency or relative frequency for that category.

Frequency Polygon

A frequency polygon is drawn by connecting the midpoints of each histogram bar with straight lines and closing the polygon at zero on both ends. It makes comparing two frequency distributions on the same graph much easier than overlapping histograms — simply draw two lines and compare their shapes.

Ogive (Cumulative Frequency Curve)

An ogive plots the cumulative frequency against the upper boundary of each class. It always starts at zero and ends at n. Reading across from any point on the y-axis tells you how many observations fall below that value — which is exactly how you estimate medians and percentiles from grouped data. Try the ogive graph maker to build one from your data.

How to Read Distribution Shape

Building a frequency distribution is the first step. The second step is understanding what the shape tells you about your data — and that is something almost no statistics resource covers inside a frequency distribution article.

Skewed distributions are why the mean and median can disagree sharply. For income data — where a small number of extremely high earners exist — the median is a far more representative "typical" value than the mean. That is why median household income is the standard statistic, not mean household income. See the skewness and kurtosis page for the formal measures.

Frequency Distribution in Excel

Excel has three usable methods. Method 1 (the FREQUENCY function) gives you the most control. Method 2 (Data Analysis ToolPak) is fastest for a one-time table. Method 3 (PivotTable) works best with already-organized data.

Method 1: FREQUENCY() Array Function

This is an array formula. You define the bins yourself, which means you control every class boundary.

Method 2: Data Analysis ToolPak (Histogram)

Go to Data → Data Analysis → Histogram. Set the Input Range to your data and the Bin Range to your upper class boundaries. Check "Chart Output" and Excel draws the histogram automatically. The table it produces labels bins by upper boundary rather than as intervals, so you may need to relabel the classes manually.

Method 3: PivotTable

Select your data, insert a PivotTable, drag the value field to both Rows and Values (set Values to "Count of"). Then right-click any row label → Group → set Start, End, and By (class width). Excel creates a grouped frequency distribution with the group-by interval you specify.

Frequency Distribution in Python

Python's pandas and NumPy make it easy to build and visualize frequency distributions in a few lines. The three snippets below cover the most common use cases.

Method 1: pandas value_counts() — Ungrouped

import pandas as pd

ratings = [4, 3, 5, 4, 2, 4, 3, 4, 1, 5,
           4, 3, 2, 4, 1, 3, 4, 2, 5, 4]

s = pd.Series(ratings)

# Ungrouped frequency distribution
freq = s.value_counts().sort_index()
rel_freq = freq / len(s)
cum_freq = freq.sort_index().cumsum()

fd = pd.DataFrame({
    'Frequency': freq,
    'Relative Freq': rel_freq.round(2),
    'Cumulative Freq': cum_freq
})
print(fd)

Method 2: pandas cut() — Grouped

import pandas as pd

delivery_times = [14,22,31,18,27,9,35,21,16,29,
                  12,38,25,19,33,8,26,20,41,17,
                  24,32,11,28,15]

s = pd.Series(delivery_times)
bins = [7, 13, 19, 25, 31, 37, 43]

# Grouped frequency distribution
freq = pd.cut(s, bins=bins).value_counts().sort_index()
rel_freq = (freq / len(s)).round(3)
cum_freq = freq.cumsum()

fd = pd.DataFrame({
    'Frequency': freq,
    'Relative Freq': rel_freq,
    'Cumulative Freq': cum_freq
})
print(fd)

Method 3: matplotlib Histogram

import matplotlib.pyplot as plt
import numpy as np

data = [14,22,31,18,27,9,35,21,16,29,
        12,38,25,19,33,8,26,20,41,17,
        24,32,11,28,15]

plt.figure(figsize=(8, 4))
plt.hist(data, bins=[7,13,19,25,31,37,43],
         edgecolor='white', color='#4f46e5', rwidth=0.95)
plt.xlabel('Delivery Time (minutes)')
plt.ylabel('Frequency')
plt.title('Delivery Time Frequency Distribution')
plt.xticks([7,13,19,25,31,37,43])
plt.tight_layout()
plt.show()

For statistical computing in Python, see also statistics for Python for a broader overview of the libraries.

Real-World Examples by Industry

Test score examples appear in every statistics textbook. Here are five frequency distributions from actual professional contexts, using data types you are likely to encounter at work.

Common Mistakes and How to Avoid Them

Most errors in frequency distributions fall into one of six patterns. Recognizing them before you build the table saves you from having to rebuild it.

Frequently Asked Questions

Quick Reference Summary