Frequency Table vs Relative Frequency Table- Key Differences
What Is a Frequency Table?
A frequency table is a way to organize data by showing how often each value appears in a dataset. You list the unique values in one column and count how many times each occurs in another.
It's the most basic form of data summarization. Teachers use it to track test scores. Businesses use it to count customer purchases. Researchers use it to understand survey responses.
How to Read a Frequency Table
Look at the left column. That's your data value or category. The right column shows the count. That's it. Nothing complicated.
What Is a Relative Frequency Table?
A relative frequency table does the same thing, but instead of showing raw counts, it shows each count as a proportion of the total. You divide each frequency by the total number of observations.
The result is usually expressed as a decimal, fraction, or percentage. It tells you what portion of the whole each category represents.
Why Bother With Percentages?
Because raw numbers don't always tell the full story. If 50 people bought product A and 25 bought product B, you might think A is twice as popular. But if 100 people took the survey, that's 50% versus 25%. The percentages give you better perspective.
Key Differences Between Frequency and Relative Frequency Tables
Here's what separates them:
- Values shown: Frequency tables use whole numbers. Relative frequency tables use proportions or percentages.
- Purpose: Frequency tables answer "how many?" Relative frequency tables answer "what fraction?" or "what percent?"
- Comparison ease: Relative frequencies make it easier to compare datasets of different sizes.
- Interpretation: Percentages are often more intuitive for general audiences.
Side-by-Side Comparison
| Feature | Frequency Table | Relative Frequency Table |
|---|---|---|
| Shows raw counts | Yes | No |
| Shows proportions | No | Yes |
| Works across dataset sizes | Limited | Yes |
| Ease of comparison | Difficult for different-sized datasets | Straightforward |
| Common use case | Exact counts needed | Proportional analysis |
How to Build Each Table
Building a Frequency Table
Steps:
- Collect all your data values
- Identify unique values or create class intervals
- Count how many times each value appears
- Record the count in a two-column table
Building a Relative Frequency Table
Steps:
- Start with your frequency table
- Add up all frequencies to get the total
- Divide each frequency by the total
- Convert to decimal, fraction, or percentage
Example in Practice
Say you're tracking shirt colors sold: Red (15), Blue (10), Green (5). That's a frequency table. Now divide by 30 total: Red (50%), Blue (33.3%), Green (16.7%). That's your relative frequency table.
The first tells you exact sales. The second tells you your sales mix. Different answers for different questions.
When to Use Which
Use a frequency table when:
- You need exact counts
- Your audience wants precise numbers
- You're working with small, manageable datasets
Use a relative frequency table when:
- Comparing groups of different sizes
- Presenting data to non-technical audiences
- You need percentages for reports or presentations
Common Mistakes to Avoid
Don't use frequencies when percentages would serve better. If someone asks "what percentage of customers chose option A?" a frequency table won't answer that directly.
Don't forget to include a total row. Without it, relative frequencies are useless because readers can't verify your math.
Don't round too aggressively. If you're working with sensitive data, keep at least 2-3 decimal places until your final calculation.
The Bottom Line
Frequency tables and relative frequency tables are two sides of the same coin. One shows counts. One shows proportions. Neither is better. They're tools for different jobs.
Pick based on what question you're trying to answer. That's the only rule that matters.