percentages.co.uk

Frequency Percentage Calculator

Written by the percentages.co.uk team. Reviewed for accuracy.

This calculator converts a frequency table into percentages, cumulative percentages and relative frequencies. Enter up to 10 categories with their counts to get a complete frequency distribution table instantly.

Takes about 30 secondsUpdated 17 May 2026
CategoryFrequency

How it works

A frequency distribution shows how often each category appears in a data set. Converting frequencies to percentages makes it easy to compare distributions across data sets of different sizes. Cumulative percentage shows the running total, useful for identifying median values and distribution spread.

The formula

Percentage = (Frequency / Total) × 100

Relative frequency = Frequency / Total

Cumulative % = Sum of percentages up to and including this row

Why this works: Dividing each frequency by the total gives a proportion (relative frequency) between 0 and 1. Multiplying by 100 gives the percentage. All percentages in the table will sum to 100, and cumulative percentage will reach 100 at the last category.

Worked examples

A survey of 200 UK shoppers asks their preferred payment method: Card 120, Cash 45, Digital wallet 35. Build the frequency table.

  1. Card: (120/200) × 100 = 60%, cumulative 60%
  2. Cash: (45/200) × 100 = 22.5%, cumulative 82.5%
  3. Digital wallet: (35/200) × 100 = 17.5%, cumulative 100%

Answer: Card 60%, Cash 22.5%, Digital wallet 17.5%

A class of 30 students gets the following GCSE grades: A* 4, A 8, B 10, C 6, D 2. What is the percentage for each?

  1. A*: (4/30) × 100 = 13.33%
  2. A: (8/30) × 100 = 26.67%
  3. B: (10/30) × 100 = 33.33%
  4. C: (6/30) × 100 = 20%
  5. D: (2/30) × 100 = 6.67%

Answer: Distribution across 5 grade categories

Website visits by source: Organic 850, Direct 320, Social 180, Email 150. What percentage does each represent?

  1. Total: 1,500 visits
  2. Organic: (850/1500) × 100 = 56.67%
  3. Direct: (320/1500) × 100 = 21.33%
  4. Social: (180/1500) × 100 = 12%
  5. Email: (150/1500) × 100 = 10%

Answer: Organic 56.67%, Direct 21.33%, Social 12%, Email 10%

Customer complaint types: Delivery 42, Product quality 28, Customer service 18, Billing 12. What percentage is each?

  1. Total: 100 complaints
  2. Delivery: 42%, Product: 28%, Service: 18%, Billing: 12%

Answer: Delivery 42%, Product quality 28%, Service 18%, Billing 12%

A poll on working patterns: Office 5 days 35, Hybrid 112, Fully remote 53. What is the distribution?

  1. Total: 200 respondents
  2. Office: (35/200) × 100 = 17.5%
  3. Hybrid: (112/200) × 100 = 56%
  4. Fully remote: (53/200) × 100 = 26.5%

Answer: Office 17.5%, Hybrid 56%, Remote 26.5%

When to use this

  • Market research and surveys: Converting raw response counts to percentages so results can be compared across surveys with different sample sizes.
  • GCSE and A-level statistics: Building frequency distribution tables is a standard topic in GCSE Maths and A-level Statistics in England.
  • Business reporting: Summarising categorical data such as support ticket types, sales by region or customer demographics for management reports.
  • Quality control: Analysing defect types or failure modes by frequency to identify the most common issues using Pareto analysis.

Understanding the result

Cumulative percentage is particularly useful for identifying the 80/20 rule (Pareto principle): often 80% of effects come from 20% of causes. Sort your categories from highest to lowest frequency before entering them and use the cumulative percentage to find where you reach 80%.

Relative frequency (the decimal form of percentage) is used in probability calculations and statistical tests where exact decimal values are needed rather than rounded percentages.

Related concepts

➡ For comparing two overlapping data sets to find what they share in common, use the overlap percentage calculator to find the similarity between two groups. ➡ When your data involves moles rather than counts, the mole percentage calculator builds a frequency-style table for chemical mixtures. ➡ To convert any specific count into a percentage of a total, the percentage of a number calculator works for any two values.

How to do this in Excel

=(B2/SUM($B$2:$B$6))*100

Put frequencies in column B starting at B2. Use an absolute reference for the SUM so you can copy the formula down. For cumulative percentage: =SUM($C$2:C2) in a separate column where column C contains the percentages.

How to do this without a calculator

Add all frequencies to find the total. For each category, divide its frequency by the total and multiply by 100. To build the cumulative column, add each percentage to the running total from the previous row.

Common mistakes

Percentages not summing to 100 due to rounding

When percentages are rounded to one or two decimal places, they may sum to 99.99% or 100.01%. This is a rounding artefact, not an error. The unrounded relative frequencies will always sum to exactly 1.

Including zero-frequency categories

Categories with zero frequency contribute 0% to the distribution but can still be meaningful to include (for example, showing that no respondents chose a particular option). Do not remove them if they are genuine categories in your data.

Related calculators

Overlap Percentage Calculator

Calculate the percentage overlap between two ranges or sets.

Mole Percentage Calculator

Calculate mole percentage and mole fraction for gas or liquid mixtures.

Percentage of a Number Calculator

Find what a percentage of any number is instantly.

Average Percentage Calculator

Calculate the average of up to five percentage values.

Ratio to Percentage Calculator

Convert any ratio to a percentage instantly.

Percentage Points Calculator

Find the difference between two percentages in percentage points.