Solved Exercises on Frequency Tables and Histograms

Master frequency tables and histograms: data organization, relative frequencies, and histogram construction through these 5 detailed exercises.

Solution: Exercises 1 to 3
1 Basic Frequency Table Construction
Exercise 1
Create a frequency table for the following dataset representing the number of books read by students: 3, 5, 2, 7, 5, 4, 6, 3, 5, 8, 4, 6, 2, 5, 7, 4, 3, 6, 5, 4
Definition:

Frequency table: A table showing categories of data and the number of times each category occurs (frequency).

Frequency: The number of times a particular value appears in the dataset.

Construction method:
  1. Identify all unique values in the dataset
  2. Count the occurrences of each value
  3. Create a table with columns for values and frequencies
  4. Calculate relative frequencies if needed
Step 1: Organize and count data

Sorted data: 2, 2, 3, 3, 3, 4, 4, 4, 4, 5, 5, 5, 5, 5, 6, 6, 6, 7, 7, 8

Step 2: Create frequency table
Number of Books Frequency Relative Freq.
2 2 2/20 = 0.10
3 3 3/20 = 0.15
4 4 4/20 = 0.20
5 5 5/20 = 0.25
6 3 3/20 = 0.15
7 2 2/20 = 0.10
8 1 1/20 = 0.05
Total 20 1.00
Step 3: Calculate relative frequencies

Relative frequency = Frequency ÷ Total number of observations

Example: For 5 books, relative freq = 5/20 = 0.25 = 25%

Step 4: Verify calculations

Sum of frequencies = 2 + 3 + 4 + 5 + 3 + 2 + 1 = 20 ✓

Sum of relative frequencies = 0.10 + 0.15 + 0.20 + 0.25 + 0.15 + 0.10 + 0.05 = 1.00 ✓

Frequency table completed with relative frequencies
Final answer:

The frequency table shows that 5 books was the most common response (frequency 5, 25% of students). The distribution is somewhat symmetric with a peak at 5 books.

Applied rules:

• Frequency calculation: Count occurrences of each unique value

• Relative frequency: Frequency ÷ Total observations

• Verification: Sum of frequencies equals total data points, sum of relative frequencies equals 1

2 Grouped Frequency Table
Exercise 2
Create a grouped frequency table for the following test scores: 65, 72, 88, 91, 76, 83, 79, 87, 94, 68, 75, 82, 90, 77, 84, 92, 69, 78, 86, 93, 71, 80, 89, 74, 81. Use intervals of width 10 starting at 60-69.
Definition:

Grouped frequency table: A frequency table where data is organized into intervals (classes) instead of individual values.

Class interval: A range of values grouped together (e.g., 60-69).

Step 1: Determine class intervals

Starting at 60-69, with width 10: 60-69, 70-79, 80-89, 90-99

Step 2: Tally data into intervals

60-69: 65, 68, 69 (frequency = 3)

70-79: 72, 76, 79, 75, 77, 78, 74, 71 (frequency = 8)

80-89: 88, 83, 87, 82, 84, 80, 86, 89, 81 (frequency = 9)

90-99: 91, 94, 90, 92, 93 (frequency = 5)

Step 3: Create grouped frequency table
Score Interval Frequency Relative Freq. Cumulative Freq.
60-69 3 3/25 = 0.12 3
70-79 8 8/25 = 0.32 11
80-89 9 9/25 = 0.36 20
90-99 5 5/25 = 0.20 25
Total 25 1.00
Step 4: Calculate cumulative frequencies

Cumulative frequency = sum of all frequencies up to and including current class

Example: For 80-89 interval, cumulative freq = 3 + 8 + 9 = 20

Step 5: Verify calculations

Sum of frequencies = 3 + 8 + 9 + 5 = 25 ✓

Final cumulative frequency = 25 ✓

Grouped frequency table with cumulative frequencies
Final answer:

The most common score range is 80-89 (frequency 9, 36% of students). The distribution shows that most students scored in the 70-89 range.

Applied rules:

• Interval selection: Choose appropriate width that balances detail and simplicity

• Non-overlapping: Intervals must not overlap (e.g., 60-69 vs 70-79)

• Cumulative frequency: Running total of frequencies up to each class

3 Histogram Construction
Exercise 3
Create a histogram for the grouped frequency table from Exercise 2. Describe the shape of the distribution.
Definition:

Histogram: A graphical representation of a frequency distribution using bars where the area of each bar represents the frequency of the class interval.

Bar width: Corresponds to the width of the class interval.

Step 1: Set up axes

X-axis: Score intervals (60-69, 70-79, 80-89, 90-99)

Y-axis: Frequencies (0 to 10)

Step 2: Draw bars for each interval

60-69: Height = 3, Width = 10

70-79: Height = 8, Width = 10

80-89: Height = 9, Width = 10

90-99: Height = 5, Width = 10

Step 3: Ensure adjacent bars (no gaps)

Unlike bar graphs, histogram bars touch each other to show continuous data

Step 4: Analyze the shape

The highest bar is in the 80-89 interval (frequency 9)

The distribution peaks in the middle and tapers off on both sides

This appears to be approximately symmetric or slightly right-skewed

Step 5: Label the histogram

Title: "Distribution of Test Scores"

X-axis: "Test Score Ranges"

Y-axis: "Number of Students"

Histogram shows approximately symmetric distribution
Final answer:

The histogram shows a distribution that is approximately symmetric with a peak in the 80-89 interval. Most students scored between 70 and 89, with fewer students at the extremes.

Applied rules:

• No gaps: Adjacent bars in histograms to show continuous data

• Bar area: Proportional to frequency (height × width)

• Shape interpretation: Symmetric, skewed left/right, or uniform

Rules and methods, laws,...
Relative Frequency = \frac{Frequency}{Total Observations}
Relative Frequency Formula
Frequency
Count of occurrences
of each value
How many times value appears
Relative Freq.
Freq ÷ Total
× 100%
Percentage of total
Cumulative Freq.
Running total
up to each class
Add previous frequencies
Key definitions:

Frequency table: Organizes data by listing values and their frequencies

Grouped frequency table: Groups data into intervals for easier analysis

Histogram: Visual representation of frequency distribution using bars

Complete methodology:
  1. Organize data: Sort values in ascending order
  2. Identify unique values: For ungrouped, or determine intervals for grouped
  3. Count frequencies: Tally occurrences of each value or interval
  4. Calculate relative frequencies: Frequency ÷ total observations
  5. Create table: Include all necessary columns
  6. Verify totals: Check calculations
Tip 1: Always sort data first to avoid missing values.
Tip 2: Choose interval widths that make sense for your data.
Tip 3: Histogram bars must touch to show continuous data.
Tip 4: Relative frequencies should sum to 1 (or 100%).
Common errors: Overlapping intervals, gaps in histograms, incorrect frequency counts.
Exam preparation: Practice grouping data into intervals, calculating cumulative frequencies.
Formulas to know by heart:

• Relative frequency = Frequency ÷ Total observations

• Cumulative frequency = Sum of all previous frequencies

• Percentage = Relative frequency × 100%

Solution: Exercises 4 to 5
4 Relative and Cumulative Frequencies
Exercise 4
Using the grouped frequency table from Exercise 2, calculate the percentage of students who scored below 80. Also find the cumulative relative frequency for the 80-89 interval.
Definition:

Cumulative relative frequency: The proportion of observations that fall below the upper limit of a given class interval.

Percentage: Relative frequency expressed as a percentage (×100%)

Step 1: Recall the grouped frequency table
Score Interval Frequency Relative Freq. Cumulative Freq.
60-69 3 0.12 3
70-79 8 0.32 11
80-89 9 0.36 20
90-99 5 0.20 25
Step 2: Calculate percentage scoring below 80

Students scoring below 80 are in intervals 60-69 and 70-79

Frequency below 80 = 3 + 8 = 11

Percentage = (11/25) × 100% = 0.44 × 100% = 44%

Step 3: Find cumulative relative frequency for 80-89

Cumulative relative frequency = Cumulative frequency ÷ Total

For 80-89 interval: Cumulative freq = 20

Cumulative relative frequency = 20/25 = 0.80

Step 4: Interpret the results

44% of students scored below 80

80% of students scored 89 or below

Step 5: Verify calculations

Percentage below 80: 3 + 8 = 11 out of 25 = 11/25 = 0.44 = 44% ✓

Cumulative relative frequency for 80-89: 20/25 = 0.80 ✓

44% below 80; 80% at or below 89
Final answer:

44% of students scored below 80. The cumulative relative frequency for the 80-89 interval is 0.80 (80%), meaning 80% of students scored 89 or below.

Applied rules:

• Percentage calculation: (Part ÷ Whole) × 100%

• Cumulative relative frequency: Cumulative frequency ÷ Total observations

• Interpretation: Cumulative relative frequency represents proportion below upper limit

5 Histogram Interpretation
Exercise 5
A histogram of daily temperatures (°F) shows the following intervals and frequencies: 40-49°F (3 days), 50-59°F (7 days), 60-69°F (12 days), 70-79°F (15 days), 80-89°F (8 days), 90-99°F (2 days). Describe the distribution and identify the modal class.
Definition:

Modal class: The class interval with the highest frequency in a grouped frequency distribution.

Distribution shape: Describes how data is spread across values (symmetric, skewed, etc.)

Step 1: Analyze the frequency distribution
Temperature (°F) Frequency Relative Freq.
40-49 3 0.08
50-59 7 0.19
60-69 12 0.32
70-79 15 0.41
80-89 8 0.22
90-99 2 0.05
Total 47 1.00
Step 2: Identify the modal class

The modal class is the interval with the highest frequency

70-79°F has frequency 15, which is the highest

Modal class = 70-79°F

Step 3: Analyze the distribution shape

Low frequencies at low temperatures (40-59°F)

Increasing frequencies to peak at 70-79°F

Decreasing frequencies at higher temperatures (80-99°F)

This appears to be approximately symmetric or slightly left-skewed

Step 4: Describe key features

Most days had temperatures in the 60-79°F range (27 out of 47 days)

The distribution is concentrated in the moderate temperature range

Very few days were extremely hot (90-99°F) or cold (40-49°F)

Step 5: Calculate additional insights

Percentage of days with temperatures 70°F or above = (15+8+2)/47 = 25/47 ≈ 53.2%

Percentage of days with temperatures below 70°F = (3+7+12)/47 = 22/47 ≈ 46.8%

Modal class: 70-79°F; Approximately symmetric distribution
Final answer:

The modal class is 70-79°F with 15 days. The distribution is approximately symmetric with most temperatures in the 60-79°F range. About 53% of days had temperatures of 70°F or higher.

Applied rules:

• Modal class identification: Class with highest frequency

• Distribution shape: Analyze pattern of frequencies across intervals

• Interpretation: Connect histogram patterns to real-world context

Comprehensive Guide to Frequency Tables and Histograms
Relative Frequency = \frac{Frequency}{Total Observations}
Relative Frequency Formula
Key definitions:

Frequency table: A table that lists data values along with their corresponding frequencies (counts).

Frequency: The number of times a particular value or range of values appears in the dataset.

Relative frequency: The proportion of observations in each category, calculated as frequency divided by total number of observations.

Grouped frequency table: A frequency table where data is organized into intervals (classes) rather than individual values.

Histogram: A graphical representation of a frequency distribution using adjacent bars where the area of each bar represents the frequency of the class interval.

Complete methodology:
  1. Organize raw data: Sort values in ascending order to identify all unique values or ranges
  2. Choose appropriate format: Individual values for small datasets, grouped intervals for large datasets
  3. Count frequencies: Tally occurrences of each value or interval
  4. Calculate relative frequencies: Divide each frequency by the total number of observations
  5. Compute cumulative frequencies: Running total of frequencies up to each class
  6. Create table: Include all relevant columns (value/interval, frequency, relative frequency, cumulative frequency)
  7. Construct histogram: Draw adjacent bars with heights proportional to frequencies
  8. Verify calculations: Ensure sums match expected totals
Tip 1: Always sort data first to avoid missing values or double-counting.
Tip 2: For grouped data, choose interval widths that balance detail with clarity.
Tip 3: Histogram bars must touch each other to represent continuous data.
Tip 4: Relative frequencies should always sum to 1 (or 100%).
Tip 5: The modal class is the interval with the highest frequency in grouped data.
Tip 6: Use histograms to visualize the shape, center, and spread of data distributions.
Distribution Shapes: Symmetric (bell-shaped), skewed left (tail on left), skewed right (tail on right), uniform (approximately equal frequencies).
Interval Selection: Choose 5-15 intervals for most datasets. Intervals should be mutually exclusive and collectively exhaustive.
Class Boundaries: Ensure no gaps between intervals and that all data points fit into exactly one interval.
Essential formulas and rules:

• Relative frequency: RF = Frequency ÷ Total observations

• Percentage: Percentage = Relative frequency × 100%

• Cumulative frequency: CF = Sum of all frequencies up to current class

• Cumulative relative frequency: CRF = Cumulative frequency ÷ Total observations

• Class width: Upper limit - Lower limit of interval

• Verification: Sum of frequencies = Total observations, Sum of relative frequencies = 1

Visual Analysis: Frequency Distribution Patterns
Understanding Histogram Shapes
Different histogram shapes reveal important characteristics about data distributions:
Symmetric: Bell-shaped, equal distribution on both sides
Right-skewed: Tail extends to the right, mean > median
Left-skewed: Tail extends to the left, mean < median
Uniform: Relatively flat, equal frequencies across intervals

Analysis: Histograms provide visual summaries of data distribution, revealing patterns, central tendencies, and variability.

  • The height of each bar represents the frequency or relative frequency
  • Adjacent bars show continuous nature of quantitative variables
  • Shape reveals underlying patterns in the data
  • Outliers appear as isolated bars at extremes

Questions & Answers

Question: I'm confused about when to use a frequency table versus a grouped frequency table. How do I decide which one to use?

Answer: Great question! The choice depends on your data characteristics:

  • Use regular frequency tables when: You have a small number of distinct values (typically ≤ 10 unique values) or when each value has meaningful significance. Example: Number of siblings (0, 1, 2, 3, etc.)
  • Use grouped frequency tables when: You have many distinct values (continuous data or many discrete values), or when you want to summarize data in meaningful ranges. Example: Heights, weights, test scores

Guidelines:

  • If you have more than 10-15 distinct values, consider grouping
  • If your data is continuous (like measurements), grouping is usually better
  • Group data into 5-15 intervals for optimal clarity
  • Choose intervals that make sense in the context of your data

For example, test scores from 0-100 are better grouped into ranges like 60-69, 70-79, etc., rather than listing every possible score.

Question: Why do histogram bars need to touch each other while bar graph bars have spaces between them? What's the difference?

Answer: This is a crucial distinction that reflects the nature of the data being displayed:

  • Histograms: Used for quantitative (numerical) data, which is continuous. Bars touch to show that the variable can take any value within the range. For example, temperatures can be 69.5°F or 70.3°F - there are no gaps in possible values.
  • Bar graphs: Used for categorical data, which is discrete. Spaces between bars emphasize that categories are separate and distinct. For example, hair colors (blonde, brown, black) are completely different categories.

Key difference: Histograms represent continuous data where the variable can take any value within a range, while bar graphs represent categorical data where categories are distinct.

The touching bars in histograms also mean that the area of each bar (not just height) represents the frequency, which is important when intervals have different widths.

Question: How do I determine the appropriate number of intervals for a grouped frequency table? Is there a formula I should use?

Answer: Yes, there are several guidelines and formulas to help determine the number of intervals:

  • Sturges' Rule: k = 1 + 3.322×log₁₀(n), where n is the number of observations
  • Square Root Rule: k = √n
  • General guideline: Use between 5 and 15 intervals for most datasets

Examples:

  • For n=25 data points: Sturges' Rule suggests k = 1 + 3.322×log₁₀(25) ≈ 5.6 ≈ 6 intervals
  • For n=100 data points: Sturges' Rule suggests k = 1 + 3.322×log₁₀(100) = 1 + 3.322×2 ≈ 7.6 ≈ 8 intervals

Practical considerations:

  • Too few intervals: Lose important details in the data
  • Too many intervals: Pattern becomes difficult to see
  • Round interval widths to convenient numbers when possible (multiples of 5 or 10)
  • Ensure all intervals have the same width when possible

Always prioritize interpretability over strict adherence to formulas.

Question: What's the difference between cumulative frequency and cumulative relative frequency? When would I use each one?

Answer: Both are running totals, but they express different measures:

  • Cumulative frequency: The total count of observations up to and including each class interval. It's an actual count (e.g., 15 students).
  • Cumulative relative frequency: The proportion of observations up to and including each class interval. It's a decimal between 0 and 1 (e.g., 0.30 or 30%).

Formula relationship:

Cumulative relative frequency = Cumulative frequency ÷ Total number of observations

When to use each:

  • Cumulative frequency: When you need to know the actual number of observations up to a certain point
  • Cumulative relative frequency: When you want to know what proportion or percentage of the data falls below a certain value

Example: If cumulative frequency for scores ≤ 79 is 15 out of 50 total students, then cumulative relative frequency is 15/50 = 0.30 or 30%. This tells us that 30% of students scored 79 or below.

Question: How can I tell the shape of a distribution just by looking at a histogram? What specific features should I focus on?

Answer: Histogram shape reveals important characteristics about your data. Focus on these features:

  • Modality: Number of peaks (modes). Unimodal (one peak), bimodal (two peaks), or multimodal (multiple peaks).
  • Skewness: Direction of the tail. Right-skewed (tail to the right), left-skewed (tail to the left), or symmetric.
  • Symmetry: Whether the left and right sides are mirror images.
  • Center: Where most of the data is concentrated.
  • Spread: How wide the distribution is.

Shape indicators:

  • Symmetric: The histogram looks roughly the same on both sides of the center
  • Right-skewed: Peak on the left, tail extends to the right (mean > median)
  • Left-skewed: Peak on the right, tail extends to the left (mean < median)
  • Uniform: Roughly equal heights across all bars

Pay attention to outliers as well - these appear as isolated bars at the extremes of the distribution.