Data Handling - Organization and Presentation Guide

Key Definitions in Data Handling

  • Data Handling Overview: The systematic process of organizing, presenting, and interpreting collected data.

  • Raw Data: Data that is unorganized and directly collected from a source prior to any grouping, sorting, or mathematical analysis.

  • Class: A specific category, object type, or numerical value of data. In a frequency table, the class is always listed in the first column.

  • Class Interval: A defined set or range of continuous values bounded between two specific numbers used to aggregate data points.

  • Class Width: The size or span of a class interval, calculated using the formula:   Class width=Larger number of class intervalSmaller number of class interval\text{Class width} = \text{Larger number of class interval} - \text{Smaller number of class interval}

  • Frequency: The total number of times a specific value, category, or range of data appears within the raw data. In a frequency table, frequency is always listed in the second column.

Frequency Tables for Data Organization

  • Ungrouped Frequency Tables:

    • Purpose: Designed for organizing raw data that contains only a few specific numerical values or distinct non-numerical categories.

    • Example 1 (Discrete Numerical Data - "How many pets do you have?"):

    • Class (0 pets0\text{ pets}): Frequency = 1010

    • Class (1 pet1\text{ pet}): Frequency = 55

    • Class (2 pets2\text{ pets}): Frequency = 33

    • Class (3 or more pets3\text{ or more pets}): Frequency = 22

    • Example 2 (Categorical Data - "Which GRC value is your favourite?"):

    • Class (Gratitude): Frequency = 33

    • Class (Respect): Frequency = 55

    • Class (Compassion): Frequency = 1111

  • Grouped Frequency Tables:

    • Purpose: Designed for organizing continuous data sets or data that spans a large range of many distinct values.

    • Example (Continuous Quantitative Data - "What is the distance from your home to school?"):

    • Let yy represent the distance from home to school measured in kilometers (km\text{km}).

    • Class Interval (0<y2km0 < y \le 2\,\text{km}): Frequency = 99

    • Class Interval (2<y4km2 < y \le 4\,\text{km}): Frequency = 33

    • Class Interval (4<y6km4 < y \le 6\,\text{km}): Frequency = 33

    • Essential Rule on Class Intervals (Avoiding Data Overlap):

    • Class intervals must be constructed so that there is NO OVERLAP between groups.

    • Incorrect Construction Example: Creating class intervals such as (0y2)(0 \le y \le 2) and (2y4)(2 \le y \le 4) within the same frequency table is invalid because the value 22 would belong to both groups simultaneously.

    • Correct Construction Standard: Use strict inequality on one boundary (e.g., 0<y20 < y \le 2 and 2<y42 < y \le 4) so that the upper bound value 22 falls strictly into the first class interval and not the second.

Methods for Presenting Organized Data

  • Pictogram:

    • Primary Uses:

    • Used to visually engage and catch the audience's attention.

    • Uses pictures, icons, or symbols to represent a specified quantity of data.

    • Appropriate when exact numerical accuracy is not strictly required.

    • Detailed Example ("Varieties of Apples in a food store"):

    • Symbol Key:

      • 1 full apple icon=10 apples1\text{ full apple icon} = 10\text{ apples}

      • 1 half apple icon=5 apples1\text{ half apple icon} = 5\text{ apples}

    • Red Delicious: 33 full apple icons = 3030 apples

    • Golden Delicious: 22 full apple icons + 11 half apple icon = 2525 apples

    • Red Rome: 44 full apple icons = 4040 apples

    • McIntosh: 22 full apple icons = 2020 apples

    • Jonathan: 33 full apple icons + 11 half apple icon = 3535 apples

  

Pictogram showing varieties of apples in a food store
  • Bar Graph:

    • Primary Uses:

    • Used to compare discrete categories, groups, or distinct sets of data side-by-side.

    • Essential when the audience needs to clearly evaluate exact quantities against a structured numerical scale.

    • Detailed Example ("Favorite Types of Music"):

    • Vertical Axis (Y-axis): Number of Students (scaled from 00 to 1414).

    • Horizontal Axis (X-axis): Types of Music (Categories: hip hop, classical, rock, jazz).

    • Data Values:

      • Hip Hop: 1212 students

      • Classical: 88 students

      • Rock: 77 students

      • Jazz: 1414 students

  

Bar graph showing favorite types of music
  • Line Graph:

    • Primary Uses:

    • Used to compare data collected across sequential time intervals (time-series data).

    • Ideal for highlighting continuous trends, growth patterns, or changes over time.

    • Detailed Example ("Russel's height at 3-year interval"):

    • Vertical Axis (Y-axis): Height in feet (feet\text{feet}), scaled from 00 to 8feet8\,\text{feet}.

    • Horizontal Axis (X-axis): Age in years (years\text{years}), plotted at 3-year3\text{-year} intervals (0,3,6,9,12,15,18,21,240, 3, 6, 9, 12, 15, 18, 21, 24).

    • Plotted Measurements:

      • Age 3years3\,\text{years}: 2feet2\,\text{feet}

      • Age 6years6\,\text{years}: 2.5feet2.5\,\text{feet}

      • Age 9years9\,\text{years}: 2.75feet2.75\,\text{feet}

      • Age 12years12\,\text{years}: 3feet3\,\text{feet}

      • Age 15years15\,\text{years}: 4.5feet4.5\,\text{feet}

      • Age 18years18\,\text{years}: 5.5feet5.5\,\text{feet}

      • Age 21years21\,\text{years}: 6feet6\,\text{feet}

      • Age 24years24\,\text{years}: 6.1feet6.1\,\text{feet}

  

Line graph showing Russel's height at 3-year intervals
  • Pie Chart:

    • Primary Uses:

    • Used to display the relative proportion or percentage of individual parts compared to a whole (100%100\%).

    • Recommended when there are a small number of distinct categories to maintain visual clarity.

    • Detailed Example ("Favorite Sports Distribution"):

    • Total Percentage: 100%100\% distributed across 55 sports categories.

    • Proportional Breakdown:

      • Soccer: 30%30\%

      • Swimming: 27%27\%

      • Track: 20%20\%

      • Tennis: 12%12\%

      • Gymnastics: 11%11\%

  

Pie chart showing favorite sports distribution