TFT

Frequency Distribution Table Generator – Organize Data Online

Create a complete frequency distribution table from any dataset with our free online tool. Includes frequency, relative frequency, and cumulative frequency for easy data analysis.

Recommended: 5-10 bins for most datasets

Examples:

Understanding Frequency Distribution Tables

A frequency distribution table organizes raw data into groups called classes or bins. Instead of looking at individual values, you see how many data points fall into each range. This makes patterns in large datasets much easier to spot.

The table shows several useful columns. Frequency counts how many values land in each bin. Relative frequency expresses this as a proportion of the total. Cumulative frequency keeps a running total, showing how many values fall below each bin's upper boundary.

How to Create a Frequency Distribution Table

  1. 1

    Find the range

    Subtract the minimum value from the maximum value. This tells you the total spread of your data.

  2. 2

    Choose the number of bins

    For most datasets, 5 to 10 bins work well. Too few bins hide patterns. Too many bins make the table hard to read.

  3. 3

    Calculate bin width

    Divide the range by the number of bins. Round up to a convenient number if needed.

  4. 4

    Create the bins

    Start at the minimum value and add the bin width repeatedly to create non-overlapping intervals.

  5. 5

    Count frequencies

    Tally how many data points fall into each bin. Each value goes into exactly one bin.

Worked Examples

Example 1: Test Scores (20 students)

Data: 45, 52, 38, 49, 55, 42, 48, 51, 39, 47, 53, 44, 50, 46, 41, 54, 43, 48, 52, 40
Min = 38, Max = 55
Range = 55 - 38 = 17
Using 5 bins: Bin width = 17/5 = 3.4
Bins: [38-41.4), [41.4-44.8), [44.8-48.2), [48.2-51.6), [51.6-55]
Count values in each bin to get frequencies

Example 2: Choosing Bin Numbers

Sturges' formula suggests: bins = 1 + 3.322 × log₁₀(n)

For n = 100: bins ≈ 1 + 3.322 × 2 = 7.6 ≈ 8 bins

For n = 50: bins ≈ 1 + 3.322 × 1.7 = 6.6 ≈ 7 bins

This formula gives a good starting point for most datasets.

Example 3: Interpreting Relative Frequency

If 15 out of 60 values fall in a bin:
Relative frequency = 15/60 = 0.25
Percentage = 0.25 × 100 = 25%
This means 25% of all data falls in this range.

Quick Fact

Florence Nightingale was a pioneer in using frequency distributions and visual statistics. During the Crimean War, she created "coxcomb" diagrams (early pie charts) showing that most soldier deaths were from disease, not battle wounds. Her statistical work revolutionized military medicine.

Frequently Asked Questions

How many bins should I use?

For small datasets (under 50 values), use 5-7 bins. For medium datasets (50-200), use 7-10 bins. For large datasets, you can use more. Sturges' formula gives a mathematical guideline, but adjust based on what reveals patterns best.

What if a value falls exactly on a bin boundary?

By convention, the left boundary is inclusive and the right is exclusive. So [40-50) includes 40 but not 50. The value 50 goes in the next bin [50-60). This prevents double-counting.

When should I use relative frequency?

Use relative frequency when comparing datasets of different sizes. It converts counts to proportions, making fair comparisons possible. A frequency of 10 means different things in datasets of 20 vs 200 values.

What does cumulative frequency tell me?

Cumulative frequency shows how many values fall at or below each bin. It's useful for finding percentiles and answering questions like "What percentage scored below 70?"

Can I use unequal bin widths?

Yes, but it's more complex. With unequal bins, you need to use frequency density (frequency divided by bin width) for accurate histograms. Equal-width bins are simpler and work for most purposes.

What's the difference from a histogram?

A frequency distribution table shows the numbers. A histogram is the visual representation of that table using bars. The table gives precise values; the histogram shows patterns at a glance.

Other Free Tools

Histogram Generator – Create Histograms Online Free

Create professional histograms from any dataset with our free online histogram generator. Customize bin sizes and view frequency distributions as visual bar charts instantly.

Mean, Median, Mode Calculator – Statistics Calculator Online

Calculate mean, median, and mode of any dataset with our free online statistics calculator. Enter your numbers and get comprehensive central tendency measures instantly.

Standard Deviation Calculator – Variance & SD Online

Calculate standard deviation and variance for any dataset with our free online calculator. Supports both population and sample standard deviation with step-by-step workings.

Box Plot Generator – Create Box and Whisker Plots Online

Generate box plots (box-and-whisker plots) from any dataset with our free online box plot generator. Visualize quartiles, median, and outliers with a clear and accurate diagram.

Five Number Summary Calculator – Min Q1 Median Q3 Max

Find the five-number summary of any dataset with our free online calculator. Instantly compute the minimum, Q1, median, Q3, and maximum for complete data analysis.

Outlier Detector – Find Outliers Using IQR Method Online

Detect outliers in any dataset using the IQR method with our free online outlier detector. Find lower and upper fences and identify all outlying values in your data.

Scatter Plot Generator – Create Scatter Plots Online Free

Generate scatter plots from any two-variable dataset with our free online scatter plot generator. Visualize data relationships, trends, and correlations instantly.

Z-Score Calculator – Find Standard Score Online

Calculate the Z-score of any data point with our free online Z-score calculator. Enter the value, mean, and standard deviation to get the standardized score instantly.