Home › Calculators › Frequency Table Generator

Frequency Table Generator

Paste raw data and get a complete frequency distribution table: classes, boundaries, midpoints, frequency, relative frequency and cumulative frequency. Numbers are grouped into classes of the width you choose (or one picked with Sturges' rule); text labels are counted category by category.

Last updated: October 24, 2026

Data

Numbers or text labels separated by commas, spaces (numbers) or new lines.

Data type

Detect automaticallyNumbers (grouped classes)Categories (count each value)

Class width

First class starts at

Sort categories by

Ignore upper/lower case

Enter your values to see the result.

How to use the Frequency Table Generator

Paste your data: numbers or labels separated by commas, spaces or new lines.
Choose the data type or leave it on automatic detection.
Set the class width and the first class start for numbers (leave blank for automatic).
Read the table with frequency, relative and cumulative columns.
Check the histogram and download the table as CSV.

Frequency table formulas

Column	Formula	Example (n = 30)
Frequency f	Count of values in the class	70–79: 8 values
Relative frequency	f ÷ n	8 ÷ 30 = 0.2667 (26.67%)
Cumulative frequency	f₁ + f₂ + … + f_i	3 + 4 + 8 = 15
Cumulative %	cumulative f ÷ n × 100	15 ÷ 30 = 50%
Midpoint m	(lower limit + upper limit) ÷ 2	(70 + 79) ÷ 2 = 74.5
Class boundaries	limits ± half the measuring unit	69.5 to 79.5
Grouped mean	Σ(f × m) ÷ n	Estimate of the mean

How many classes? (Sturges' rule)

Sturges' rule suggests k = ⌈1 + log₂ n⌉ classes. Too few classes hide the shape of the data; too many leave most classes nearly empty.

Number of values n	Suggested classes k
10	5
20	6
30–50	6–7
100	8
500	10
1,000	11

Then width ≈ range ÷ k, rounded up to a tidy value. Make sure the first class starts at or below the minimum so every value fits.

Frequently asked questions

What is a frequency table?

A frequency table lists each value or class of values together with how many times it occurs (its frequency). It usually also shows the relative frequency (frequency ÷ total) and the cumulative frequency (running total), which make the distribution of the data easy to read.

How do I choose the class width?

A common start is Sturges' rule: number of classes k = ⌈1 + log₂ n⌉, then width ≈ (maximum − minimum) ÷ k, rounded up to a convenient number such as 2, 5 or 10. Most textbooks recommend 5 to 20 classes. Leave the width blank and this tool applies that rule for you.

What is relative frequency?

Relative frequency is the frequency of a class divided by the total number of observations. For example, 6 values out of 30 gives 6 ÷ 30 = 0.2, or 20%. All relative frequencies add up to 1 (100%).

What is cumulative frequency?

Cumulative frequency is the total of the frequencies up to and including a class. The last class always has a cumulative frequency equal to n. Cumulative percentages are used to read off medians and percentiles and to draw an ogive.

What is the difference between class limits and class boundaries?

Class limits are the smallest and largest values that can belong to a class, such as 60–69 for whole numbers. Class boundaries split the gap between classes, such as 59.5–69.5, so the classes touch with no gaps; they are used for histograms.

How is the grouped mean calculated?

The grouped mean multiplies each class midpoint by its frequency, adds the products and divides by n: mean ≈ Σ(f × m) ÷ n. It is an estimate because it assumes the values in each class sit at the midpoint, so it can differ slightly from the exact mean of the raw data, which is also shown.

Can I count words or categories?

Yes. Text labels such as colours, survey answers or product names are counted per category. You can sort by frequency, alphabetically or by first appearance, and merge different capitalisations.

Are all the tools on FreeToolCabin tested for quality and accuracy?

Yes! Every tool on our site undergoes automated Q/A testing in real browser environments to ensure high precision, correct output, and zero errors. If you happen to spot a bug or have a suggestion, please contact us at [email protected] and our team will review it right away.

Related tools

Mean Median Mode CalculatorFind the mean, median, mode, range, min, max, sum and count of a list of numbers.Standard Deviation CalculatorStandard deviation, variance, mean, median, mode and quartiles.Percentile CalculatorValue at any percentile, percentile rank of a score, quartiles, IQR and outliers.Word Frequency CounterFind the most used words and phrases in any text and turn them into a word cloud.Count Duplicate LinesCount how many times each line appears, sorted by frequency, with duplicates-only and CSV export.Weighted Average CalculatorCalculate a weighted mean from values and weights, step by step.Average CalculatorMean, weighted average, median, sum, min and max of any list.A/B Test Significance CalculatorCheck if your A/B test result is statistically significant.Z-Score CalculatorZ-score from a value, mean and SD, plus percentile and p-value; or the value from z.Probability CalculatorFind and, or, not, conditional and at-least-once probabilities from P(A) and P(B).Permutation and Combination CalculatorCalculate nPr and nCr, with or without repetition, as exact big numbers.Confidence Interval CalculatorConfidence interval and margin of error for a mean or a proportion, with steps.Sample Size CalculatorHow many survey responses you need for a given confidence level and margin of error.Correlation Coefficient CalculatorPearson r and Spearman rank correlation with significance and interpretation.Average Order Value CalculatorAverage order value from revenue and orders, plus the revenue impact of raising AOV.Binomial Distribution CalculatorBinomial probabilities P(X = k), at most, at least or between, with mean, variance and chart.Normal Distribution CalculatorNormal probabilities P(X < x), between two values and inverse percentiles, on a shaded bell curve.Poisson Distribution CalculatorPoisson probabilities for a rate λ: exactly k, at most, at least or between, with a chart.T-Test CalculatorOne-sample, two-sample (Welch/pooled) and paired t-tests with p-value and CI.Chi-Square CalculatorChi-square goodness-of-fit and independence tests with p-value and expected counts.P-Value CalculatorOne- or two-tailed p-values from z, t, chi-square or F statistics, with critical values.Variance CalculatorSample and population variance and standard deviation with a step-by-step deviations table.Five Number Summary CalculatorMin, Q1, median, Q3, max, IQR and fences of a data set, with a box plot.Outlier CalculatorFind outliers with 1.5×/3× IQR fences, z-scores or modified z-scores; get the cleaned data.Geometric Mean CalculatorGeometric, harmonic, arithmetic and quadratic means compared, or average growth from % changes.Expected Value CalculatorExpected value, variance and standard deviation from outcomes and their probabilities.One-Way ANOVA CalculatorOne-way ANOVA for 2-10 groups: SS, df, MS, F statistic, p-value, effect size and full table.Bayes Theorem CalculatorPosterior P(A|B) from P(A), P(B|A) and P(B|not A), with a probability tree and table.Box Plot MakerPaste data to draw box-and-whisker plots with quartiles, IQR and outliers. Download PNG or SVG.Coefficient of Variation CalculatorCV % from a dataset (sample or population) with mean, SD and a two-dataset comparison.Critical Value CalculatorCritical values of z, t, chi-square and F for any alpha, tails and degrees of freedom.Dice Probability CalculatorOdds of rolling a sum (exactly, at least, at most) with any dice, plus the full distribution.Effect Size Calculator (Cohen's d)Cohen's d, Hedges' g and Glass's delta from two means, SDs and sample sizes, with CI.Histogram MakerPaste numbers, choose bins and get a histogram, frequency table and PNG download.Margin of Error CalculatorSurvey margin of error from sample size, confidence and proportion, with population correction.Moving Average CalculatorSimple, exponential and weighted moving averages of a data series, with table and line chart.Odds Ratio and Relative Risk CalculatorOdds ratio, relative risk, risk difference, 95% CIs and p-values from a 2x2 table.Standard Error CalculatorStandard error of the mean from data or SD and n, plus SE of a proportion, with CIs.Empirical Rule Calculator68-95-99.7 rule ranges from a mean and standard deviation, with a shaded bell curve.Z-Table (Standard Normal Table)Interactive z-table: find the area for any z-score, or the z-score for a probability.Average Rate of Change CalculatorAverage rate of change of f(x), two points or a data table over [a, b], with the secant line.Binomial Expansion CalculatorExpand (a + b)^n with the binomial theorem: every term, Pascal coefficients and any specific term.Combinations GeneratorList every k-combination of your items, with or without repetition, and copy or export them.Covariance CalculatorSample and population covariance of paired X and Y data, with a step table and scatter plot.Grouped Data CalculatorMean, median, mode, variance and standard deviation from class intervals and frequencies.Inverse Normal Distribution CalculatorinvNorm: find the x or z value for a left, right, central or two-tail area, with a shaded curve.Permutations GeneratorList all permutations of letters, words or items, with k-permutations and repeats, and export them.Statistical Power CalculatorPower or required sample size for t-tests, proportions and correlations, with a power curve.T Distribution CalculatorStudent's t probabilities and critical values for any df, with the area shaded on the curve.T-Table (Student's t Distribution)Interactive t-table: critical t-values for any df and α, p-values, and a printable full table.Z-Test CalculatorOne-sample, two-sample and proportion z-tests with z, p-value, decision and shaded curve.Shannon Entropy CalculatorEntropy of text, data or probabilities in bits, nats or hartleys with a frequency table.Descriptive Statistics CalculatorPaste data and get mean, median, mode, quartiles, SD, skewness, kurtosis and a histogram.

See all 52 Statistics & Probability Calculators →