Collecting and Organizing Data

Master data collection and organization methods: surveys, tables, frequency tables, stem-and-leaf plots, and more through these 3 detailed exercises.

Data Collection and Organization Problems
1 Frequency Table Problem
Exercise 1
The number of books read by 20 students in one month: 3, 5, 2, 4, 6, 3, 4, 5, 2, 3, 4, 5, 6, 4, 3, 2, 4, 5, 3, 4. Create a frequency table.
Definition:

Frequency table: A table that shows how often each value occurs in a dataset.

Solution Method:
  1. Organize data in ascending order
  2. List unique values in the first column
  3. Count occurrences of each value
  4. Create the frequency table
Step 1: Organize the data

Original data: 3, 5, 2, 4, 6, 3, 4, 5, 2, 3, 4, 5, 6, 4, 3, 2, 4, 5, 3, 4

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

Step 2: Count frequencies

Books = 2: appears 3 times

Books = 3: appears 5 times

Books = 4: appears 6 times

Books = 5: appears 4 times

Books = 6: appears 2 times

Number of Books Frequency
2 3
3 5
4 6
5 4
6 2
Step 3: Verify the total

Total frequency = 3 + 5 + 6 + 4 + 2 = 20 (matches original count)

The frequency table is shown above.
Final answer:

The frequency table organizes the data showing how many students read each number of books.

Applied rules:

• Data organization: Sorting helps count occurrences accurately

• Frequency counting: Count each unique value separately

• Verification: Total frequency should equal original data count

2 Stem-and-Leaf Plot Problem
Exercise 2
Test scores of 15 students: 78, 82, 85, 76, 90, 88, 79, 82, 85, 77, 89, 84, 81, 87, 83. Create a stem-and-leaf plot.
Definition:

Stem-and-leaf plot: A graphical display that separates each data value into a "stem" (leading digit) and "leaf" (trailing digit).

Step 1: Identify stems and leaves

For each score, tens digit is stem, ones digit is leaf

Example: 78 → stem = 7, leaf = 8

Step 2: Sort the data

Sorted scores: 76, 77, 78, 79, 81, 82, 82, 83, 84, 85, 85, 87, 88, 89, 90

STEM
7
8
9
LEAF
6 7 8 9
1 2 2 3 4 5 5 7 8 9
0
Step 3: Organize the plot

Stem 7: leaves 6, 7, 8, 9 (scores 76, 77, 78, 79)

Stem 8: leaves 1, 2, 2, 3, 4, 5, 5, 7, 8, 9 (scores 81-89)

Stem 9: leaf 0 (score 90)

Step 4: Add a key

Key: 7 | 6 = 76

Stem-and-leaf plot completed with all data organized.
Final answer:

The stem-and-leaf plot shows the distribution of test scores while preserving individual values.

Applied rules:

• Digit separation: Separate tens (stem) from ones (leaf)

• Sorting: Arrange leaves in ascending order for each stem

• Key: Always provide a key to explain the notation

3 Survey Data Organization
Exercise 3
A survey of 40 students asked about favorite sports: Soccer (12), Basketball (10), Tennis (8), Swimming (6), Baseball (4). Create a frequency table and calculate percentages.
Definition:

Survey data: Information collected from individuals to determine preferences, opinions, or characteristics.

Step 1: Create the frequency table

List sports and their frequencies

Sport Frequency Percentage
Soccer 12 (12/40)×100 = 30%
Basketball 10 (10/40)×100 = 25%
Tennis 8 (8/40)×100 = 20%
Swimming 6 (6/40)×100 = 15%
Baseball 4 (4/40)×100 = 10%
Step 2: Calculate percentages

Formula: (Frequency ÷ Total) × 100

Soccer: (12 ÷ 40) × 100 = 30%

Step 3: Verify totals

Frequency total: 12 + 10 + 8 + 6 + 4 = 40 ✓

Percentage total: 30 + 25 + 20 + 15 + 10 = 100% ✓

The complete frequency table with percentages is shown above.
Final answer:

The table shows both raw frequencies and percentages for easy comparison.

Applied rules:

• Percentage calculation: (Part ÷ Whole) × 100

• Total verification: Percentages should sum to 100%

• Data interpretation: Percentages make comparisons easier

Comprehensive Summary: Collecting and Organizing Data
\(\text{Percentage} = \left(\frac{\text{Part}}{\text{Whole}}\right) \times 100\)
Percentage Calculation Formula
Key Definitions:

Data: Facts, figures, or information collected for analysis.

Population: The entire group being studied.

Sample: A subset of the population used for data collection.

Frequency: How often a particular value occurs in a dataset.

Raw Data: Unorganized information collected directly from a source.

Data Collection Methods:
  1. Surveys: Questionnaires distributed to gather opinions or facts
  2. Observations: Recording behaviors or phenomena as they occur
  3. Experiments: Controlled studies to test hypotheses
  4. Existing Records: Using previously collected data
Tip 1: Always organize raw data before analysis to identify patterns easily.
Tip 2: Use frequency tables to summarize categorical data efficiently.
Tip 3: Stem-and-leaf plots preserve original data values while showing distribution.
Tip 4: Always verify that frequency totals match the original data count.
Common Applications: Market research, scientific studies, opinion polls, academic assessments, demographic surveys.
Key Skills: Data organization, pattern recognition, percentage calculations, table creation, graph interpretation.
Essential Principles:

• Accuracy: Ensure data is collected without bias or error

• Organization: Structure data in a way that reveals patterns

• Verification: Always check calculations and totals

• Clarity: Present data in a format that is easy to understand

Data Organization Methods & Examples
\(\text{Relative Frequency} = \frac{\text{Frequency}}{\text{Total Number of Observations}}\)
Relative Frequency Formula
Data Organization Techniques:

Frequency Tables: Organize data by listing values and their frequencies.

Stem-and-Leaf Plots: Show distribution while preserving individual values.

Dot Plots: Display data points on a number line.

Cumulative Frequency Tables: Show running totals of frequencies.

Step-by-Step Organization Process:
  1. Collect Raw Data: Gather all information from the source
  2. Sort Data: Arrange in ascending or descending order
  3. Identify Categories: Determine distinct groups or ranges
  4. Create Tables/Charts: Organize data systematically
  5. Calculate Statistics: Find frequencies, percentages, etc.
  6. Verify Results: Check for accuracy and completeness
Tip 1: For large datasets, group data into intervals (bins) for easier analysis.
Tip 2: Use tally marks to count frequencies when dealing with unsorted data.
Tip 3: When creating stem-and-leaf plots, choose stems that make the data easy to read.
Tip 4: Always include a title and labels when creating data displays.
Common Mistakes: Miscounting frequencies, forgetting to sort data, incorrect percentage calculations, omitting units or labels.
Exam Preparation: Practice creating multiple data displays, memorize formulas, understand when to use each method.
Data Quality Principles:

• Representativeness: Sample should reflect the population accurately

• Randomness: Select participants randomly to avoid bias

• Completeness: Include all relevant data points

• Consistency: Use uniform methods for data collection

Frequently Asked Questions & Expert Answers

Questions & Answers

Question: When should I use a frequency table versus a stem-and-leaf plot? They seem similar.

Answer: Great observation! While both organize data, they serve different purposes:

  • Frequency Table: Best for categorical data or when you only need to know how often values occur. It's simpler and works well for repeated values.
  • Stem-and-Leaf Plot: Best for numerical data when you want to preserve the original values AND see the distribution. It shows individual data points.

For example, if you're counting favorite colors, use a frequency table. If you're analyzing test scores and want to see each specific score, use a stem-and-leaf plot.

The stem-and-leaf plot also makes it easier to identify patterns like clusters, gaps, and outliers in numerical data.

Question: I often struggle with organizing large sets of data. What's the best approach to stay organized?

Answer: Here's a systematic approach for organizing large datasets:

  1. First Pass: Simply list all values in the order you encounter them
  2. Sorting: Arrange data in ascending order (use tally marks if needed)
  3. Grouping: Group similar values together to make counting easier
  4. Tabulation: Create your organizational tool (table, plot, etc.)
  5. Verification: Count your organized data to ensure nothing was missed

For very large datasets, consider grouping data into intervals (like 0-9, 10-19, etc.) to make the organization more manageable.

The key is to work methodically and double-check your counts!

Question: How do I decide what the stems should be in a stem-and-leaf plot?

Answer: The choice of stems depends on your data range and precision:

  • For 2-digit numbers: Usually use the tens digit as the stem (ones as leaf)
  • For 3-digit numbers: Often use hundreds/tens as stem, ones as leaf (e.g., 12|3 for 123)
  • For decimals: Use whole number part as stem, decimal as leaf (e.g., 5|7 for 5.7)

The goal is to have enough stems to see the distribution clearly, but not so many that the plot becomes unwieldy. Aim for 5-10 stems typically.

If your data is 12, 15, 18, 21, 24, 27, 30, 33, 36 - use stems 1, 2, 3. This creates a clear visualization of the data spread.