Skip to main content
SV Siteview
Log in Create account
Home › Math › Statistics & Probability › Organizing Data with Frequency Tables

Organizing Data with Frequency Tables

Turn raw data into structured frequency tables that reveal patterns, proportions, and trends at a glance.

Lesson 2 of 10 Statistics & Probability Beginner ⏱ 8 min read
🔥 Why This Matters

Raw data is just noise until it's organized. Every business report, scientific study, and government survey begins by aggregating raw observations into a structured summary. Frequency tables are the first tool analysts reach for — they answer "how often does this happen?" in seconds. Whether you're a logistics manager tracking defect counts, a market researcher analyzing survey responses, or an HR professional reviewing performance ratings, frequency tables are the fastest path from chaos to clarity.

🎯 What You'll Learn
  • Build a frequency table from raw data using tallies and counts
  • Calculate relative frequency (proportion) and cumulative frequency for any dataset
  • Construct a grouped frequency table with equal-width class intervals
📖 Key Vocabulary
Frequency (f)The number of times a value or category appears in a dataset. Relative FrequencyThe proportion of observations in a category: \(f / n\), expressed as a decimal or percent. Cumulative FrequencyA running total of frequencies from the first class up to and including the current one. Class IntervalA range of values grouped together in a table (e.g., 10–19, 20–29). Must be equal-width and non-overlapping. Class WidthThe size of each interval: Upper boundary − Lower boundary.
Key Concept — Relative and Cumulative Frequency
\[ \text{Relative Frequency} = \frac{f}{n} \qquad \text{where } n = \text{total number of observations} \] \[ \text{Cumulative Frequency}_k = \sum_{i=1}^{k} f_i \]

All relative frequencies must sum to exactly 1.0 (or 100%). Use this as a built-in check on your work.

Frequency Table Structure — Test Scores Example

ScoreTallyFrequency (f)Relative Freq.Cumulative Freq.
70I10.101
75II20.203
80IIII40.407
90II20.209
100I10.1010
Total101.00
Worked Example 1 — Basic: Build a Frequency Table

Raw data: daily coffee orders at a café — S, M, L, M, S, L, L, M, M, L. Build a frequency table.

  1. List each unique value: S, M, L
  2. Count occurrences: S=2, M=4, L=4 → n=10
  3. Relative frequencies: S=0.20, M=0.40, L=0.40
  4. Check: 0.20 + 0.40 + 0.40 = 1.00 ✓
Worked Example 2 — Intermediate: Grouped Frequency Table

Ages of 12 survey respondents: 22, 35, 28, 41, 19, 33, 47, 26, 38, 52, 29, 44. Use class width = 10.

Classes: 10–19 (f=1), 20–29 (f=4), 30–39 (f=3), 40–49 (f=3), 50–59 (f=1)

\[ \text{Relative freq. for 20–29} = \frac{4}{12} \approx 0.333 \;(33.3\%) \]

The 20–29 and 30–39 bands together hold 7 of 12 respondents — 58% of the sample.

Worked Example 3 — Real World: Defect Tracking in Manufacturing

A quality control analyst logs defect types for 200 units: Scratch (45), Dent (30), Misprint (80), Missing part (25), Other (20). Which defect type to address first?

\[ \text{Rel. freq. Misprint} = \frac{80}{200} = 0.40 \;(40\%) \]

Misprints account for 40% of all defects. Using the cumulative frequency, Misprints + Scratches account for 62.5% of all failures. This is the classic Pareto principle: fix the top two categories and you eliminate most of the problem.

✏️ Quick Check
  1. A dataset has 25 observations and one category appears 5 times. What is its relative frequency?
  2. In a grouped frequency table, the first two classes have frequencies 8 and 12. What is the cumulative frequency after the second class?
  3. What must the sum of all relative frequencies equal?
▶ Show Answers
  1. \(5 / 25 =\) 0.20 (20%).
  2. Cumulative frequency = \(8 + 12 =\) 20.
  3. All relative frequencies must sum to 1.0 (or 100%).
⚠️ Common Mistakes
  • Overlapping class intervals: Classes like 10–20 and 20–30 overlap at 20. Use 10–19 and 20–29, or use strict inequalities (10 ≤ x < 20).
  • Unequal class widths: Mixing widths of 5 and 10 in the same table distorts any histogram built from it. Keep all intervals the same width.
  • Forgetting the total check: If your relative frequencies don't sum to 1.0, you miscounted. Always verify the total before moving on.
✅ Key Takeaways
  • Frequency counts occurrences; relative frequency = f ÷ n gives the proportion.
  • Cumulative frequency shows how many observations fall at or below a given value.
  • Group data into equal-width, non-overlapping intervals — never let class boundaries overlap.
  • All relative frequencies must sum to exactly 1.0 — use this as your error check.
💼 Career Connection — Market Research Analyst

Market research analysts build frequency tables constantly — from survey responses, product reviews, and sales logs. When a consumer goods company launches a new product, analysts tally customer ratings, usage frequency, and demographic responses into structured tables before any insight can be drawn. The relative frequency column answers the executive's question: "What percentage of customers rated us below 3 stars?" The cumulative frequency answers: "What proportion of customers rated us 4 stars or below?" These two numbers shape product roadmaps and marketing spend for entire quarters.

Calculator Connection

The Basic Statistics Calculator summarizes any numerical dataset — compute frequencies and summary statistics together to move quickly from raw data to structured insight.

Try it with the Calculator

Apply what you've learned with this tool.

Basic Statistics Calculator
Calculates mean, median, mode, and range for a set of numbers.
Use calculator →
← Previous Lesson
Back to
Understanding Data and Types of Data
Continue Learning
Up Next: Calculating the Mean (Average)
Next Lesson →
Test Your Knowledge

Organizing Data with Frequency Tables: Quiz

5 questions per attempt  ·  Beginner  ·  Pass at 70%

Start Quiz →

More in Statistics & Probability

Understanding Data and Types of Data Calculating the Mean (Average) Median and Mode: Finding the True Center
← All Statistics & Probability lessons