How is relative frequency calculated?

Divide a group’s count by the stated denominator. For A, A, B, the counts are 2 and 1, and the relative frequencies are 2/3 and 1/3. The table shows exact count/denominator fractions and percentages rounded to six decimals.

How do missing values change the denominator?

Choose whether empty selected cells are excluded or included as a separate group. Included missing values appear last. With A, a blank and B, exclusion gives denominator 2; inclusion gives denominator 3. Literal text such as NA or null is not treated as missing. Whitespace-only cells count as missing only when surrounding whitespace is trimmed.

Which input formats are supported?

Use one value per line, a comma-separated list, or a selected column from CSV records. CSV supports comma, semicolon and tab delimiters, an optional first-record header, quoted delimiters, doubled quotes and line breaks inside quoted fields. Column numbers start at 1. A short record without the selected cell counts as missing.

How are numeric bin boundaries handled?

Supply 2–101 strictly increasing decimal edges. Each bin includes its lower endpoint and excludes its upper endpoint; the last bin also includes the final edge. Values below the first or above the last edge are counted in separate buckets and stay in the denominator. Decimal comparisons are exact for the supported six-decimal inputs.

What does cumulative frequency mean for categories?

It is the running sum in the displayed order: first observed, label order or highest count first. It does not imply an inherent ranking of categories. Numeric bins always use numeric interval order, with any included missing group last. Cumulative values include earlier table pages.

Are all groups included in the chart and export?

The linked chart and table show the same page of up to 25 groups. Paging changes both views while keeping the bar scale fixed. Select a bar to inspect its count and highlight its row. CSV and TXT include every group, including groups not on the visible page.

What are the data limits?

The tool supports up to 100,000 data rows or list values. It rejects larger inputs without truncating them. Numeric values and edges support six decimal places and absolute values up to 1,000,000,000,000. Counting runs in a cancellable worker with a 15-second timeout. Practical file capacity also depends on browser memory.

Are files uploaded or saved?

No. Files are read locally as UTF-8 text, and counting runs in your browser. Inputs and results are not automatically saved. CSV exports include the missing policy and exact fractions; formula-like category labels are prefixed with an apostrophe. Export before leaving.

Frequency Table Maker

Count observations by category or numeric interval. Make missing-value handling explicit, inspect exact relative and cumulative frequencies, and export a complete table from pasted values or CSV.

Observations and grouping

Paste data

One-value-per-line mode treats each line as an observation, including internal blank lines. A final line ending does not add a row. Choose comma-separated values for a list such as A, A, B. CSV mode counts one selected column per record. Quoted fields can contain commas or line breaks.

Load UTF-8 CSV

Input formatGroupingMissing-value policyCategory order

Trim surrounding whitespace in values

An empty selected cell, a blank record or an absent cell in a short CSV row is missing. Literal “NA” or “null” remains a category. Case is preserved. A missing group is distinct from a literal category named “Missing value”. Up to 100,000 data rows are supported; input is never truncated.

Observations3Column 1

Missing cells0Excluded

Denominator32 groups / bins

Linked count chart and frequency table

Both views show the same page of up to 25 groups. Select a bar to inspect its exact count and highlight its table row. Bar lengths use the largest count in the entire result, so the scale stays fixed across pages. Full labels appear in the table.

Selected category: A · 2 / 3 (66.666667%). Cumulative: 2 / 3 (66.666667%).

Category / interval	Kind	Count	Relative frequency	Cumulative count	Cumulative frequency
A	category	2	2/3 · 66.666667%	2	2/3 · 66.666667%
B	category	1	1/3 · 33.333333%	3	3/3 · 100%

Page 1 of 1 · 2 groups

Relative frequency = group count ÷ denominator. Cumulative frequency uses all groups up to that row, including earlier pages. For categories, it follows the chosen display order and implies no natural ranking. Percentages round to six decimals.

Frequency summary

Frequency table
Column: Column 1
Data rows: 3
Missing selected cells: 0
Missing policy: exclude
Denominator: 3
Grouping: category
Order: first, then missing
Trim surrounding whitespace: true

category | A | count 2 | relative 2/3 (66.666667%) | cumulative 2/3
category | B | count 1 | relative 1/3 (33.333333%) | cumulative 3/3

Exact counts under the selected missing-value policy and bin boundaries. Relative frequencies use the displayed denominator; decimal displays are rounded. Descriptive summaries only.
Numeric bins are [lower, upper), except the final bin includes its upper edge. Out-of-range numeric values have separate buckets and remain in the denominator. Missing values, when included, are a separate final group. Categorical cumulative frequency follows the displayed order and does not imply a natural ranking.

The summary field previews up to 100 groups. Copy and exports include every group, exact count/denominator fractions and the missing-value policy. Formula-like category labels in CSV are prefixed with an apostrophe. Data and files stay in this browser and are not saved automatically.

Exact counts under the selected missing-value policy and bin boundaries. Relative frequencies use the displayed denominator; decimal displays are rounded. Descriptive summaries only.

Common questions

How is relative frequency calculated?: Divide a group’s count by the stated denominator. For A, A, B, the counts are 2 and 1, and the relative frequencies are 2/3 and 1/3. The table shows exact count/denominator fractions and percentages rounded to six decimals.
How do missing values change the denominator?: Choose whether empty selected cells are excluded or included as a separate group. Included missing values appear last. With A, a blank and B, exclusion gives denominator 2; inclusion gives denominator 3. Literal text such as NA or null is not treated as missing. Whitespace-only cells count as missing only when surrounding whitespace is trimmed.
Which input formats are supported?: Use one value per line, a comma-separated list, or a selected column from CSV records. CSV supports comma, semicolon and tab delimiters, an optional first-record header, quoted delimiters, doubled quotes and line breaks inside quoted fields. Column numbers start at 1. A short record without the selected cell counts as missing.
How are numeric bin boundaries handled?: Supply 2–101 strictly increasing decimal edges. Each bin includes its lower endpoint and excludes its upper endpoint; the last bin also includes the final edge. Values below the first or above the last edge are counted in separate buckets and stay in the denominator. Decimal comparisons are exact for the supported six-decimal inputs.
What does cumulative frequency mean for categories?: It is the running sum in the displayed order: first observed, label order or highest count first. It does not imply an inherent ranking of categories. Numeric bins always use numeric interval order, with any included missing group last. Cumulative values include earlier table pages.
Are all groups included in the chart and export?: The linked chart and table show the same page of up to 25 groups. Paging changes both views while keeping the bar scale fixed. Select a bar to inspect its count and highlight its row. CSV and TXT include every group, including groups not on the visible page.
What are the data limits?: The tool supports up to 100,000 data rows or list values. It rejects larger inputs without truncating them. Numeric values and edges support six decimal places and absolute values up to 1,000,000,000,000. Counting runs in a cancellable worker with a 15-second timeout. Practical file capacity also depends on browser memory.
Are files uploaded or saved?: No. Files are read locally as UTF-8 text, and counting runs in your browser. Inputs and results are not automatically saved. CSV exports include the missing policy and exact fractions; formula-like category labels are prefixed with an apostrophe. Export before leaving.

Exact counts under the selected missing-value policy and bin boundaries. Relative frequencies use the displayed denominator; decimal displays are rounded. Descriptive summaries only.