Frequency Table Generator
Turn raw observations into a clear frequency distribution table. Paste your numbers or categories, choose grouped or ungrouped data, and calculate frequencies, percentages, and cumulative totals.
Your Frequency Distribution Table
Enter your values, or choose an example. No result is calculated until you select the calculation button.
What Is a Frequency Table?
A frequency table summarizes how often each value or category occurs in a data set. Instead of reading a long list of observations, you can quickly identify common outcomes, compare categories, and see how the data are distributed.
How to Make a Frequency Table
Enter your observations, select the appropriate data type, and generate the table. For numerical data, use an ungrouped table to count each distinct value or a grouped table to combine values into class intervals. For categories, the table counts each label and reports its share of the total.
Frequency, Relative Frequency, and Cumulative Frequency
Frequency is the number of observations in a value or class. Relative frequency divides that count by the total number of observations. Cumulative frequency adds counts in numerical or ordered-class sequence, showing how many observations are at or below each listed value or class boundary.
Relative frequency = f/n; Percentage = 100f/n; Cumulative frequency at row j = Σ(i=1 to j) fᵢ
Grouped vs. Ungrouped Frequency Tables
An ungrouped frequency table lists individual values. A grouped frequency table combines numerical observations into intervals, making large or widely spread data easier to summarize. Grouping improves readability but loses some information about individual values.
Choosing Class Intervals
Class intervals should cover the full data range without gaps or overlaps. Equal-width classes are common, although different widths may be justified for some analyses. The class width and starting boundary influence how the resulting distribution looks.
The default class-count suggestion is ceil(log₂ n) + 1, capped at 30. Override it with a class count or width. Intervals use [left,right), except the final interval [left,right], so a boundary observation is counted once. Midpoints describe classes, not the original individual observations.
Common Frequency Table Mistakes
Do not mix numerical values and categories without choosing the appropriate mode. Avoid overlapping classes or omitting observations on class boundaries. Calculate cumulative percentages from original counts, not rounded intermediate percentages. Unordered category labels do not have an inherent cumulative numerical sequence.
Numerical modes accept 1–10,000 finite observations with a period as decimal separator. Categories are one per line or tab-separated spreadsheet cell; spaces within labels are preserved. Empty lines are ignored, but invalid numerical entries are rejected.
Worked Frequency Table Example
These examples use illustrative data, not your current inputs.
Worked Frequency Table Example
Consider the values 1, 2, 2, 3, 3, 3, 3, 4, 4, 5. There are 10 observations. The value 3 appears four times, so its frequency is 4, its relative frequency is 4/10 = 0.40, and its percentage is 40%. The cumulative frequency through the value 3 is 1 + 2 + 4 = 7.
Frequently Asked Questions
What is a frequency table generator?
It is a tool that counts observations and organizes the results into a table. It can show absolute frequencies, percentages and, for ordered data, cumulative frequencies.
What is the difference between frequency and relative frequency?
Frequency is a count. Relative frequency is that count divided by the total number of observations, so it represents a proportion.
How do I create a grouped frequency table?
Enter numerical data and choose grouped mode. The generator places each observation into a non-overlapping class interval and counts the observations in every class.
How do I calculate cumulative frequency?
Start with the first frequency and add each subsequent frequency to the running total. The final cumulative frequency equals the sample size.
Can I paste data from Excel or Google Sheets?
Yes. Copy a column of values and paste it into the data box. Tabs and line breaks are supported in numerical modes.
Can the table handle negative numbers and decimals?
Yes. Numerical data can contain negative values and finite decimals. Grouped intervals will be calculated or interpreted using the same numerical scale.
Should I use grouped or ungrouped frequency?
Use ungrouped frequency when individual values are important and the number of distinct values is manageable. Use grouped frequency when numerical data cover many values and a class-interval summary is more useful.
Does cumulative frequency make sense for categories?
Only when categories have a meaningful order. For unordered categories such as colors or brands, a cumulative total depends on an arbitrary display order and is usually not informative.
Sources and Methodology
Duplicate-preserving numerical or category parsing produces direct frequency counts. Numerical ordering is ascending; categorical display preserves first appearance and omits cumulative columns. Decimal integer boundaries allocate every observation exactly once, and cumulative percentages use unrounded counts. Up to 100 classes are supported; no grouped raw-data approximation is reported as an exact summary.
Reviewed: October 2026. Calculations run in your browser. No signup, upload, or server-side data processing is required. Read our methodology.