Frequency Distribution Table (FDT) Construction Notes

Constructing a Frequency Distribution Table (FDT) Using Google Sheets
  • Introduction
    • Objective: Teach how to construct a frequency distribution table (FDT) using Google Sheets.
    • Example dataset: Sample size of 29 regarding average phone use per day in minutes.
  • Creating a Pivot Table
    • Step 1: Highlight all data up to the last row.
    • Step 2: Click on Insert, then select Pivot Table.
    • Options: Choose between creating a new sheet or an existing sheet for displaying results.
    • New Sheet: Generates a separate sheet for the pivot table.
    • Existing Sheet: Displays results in a specified cell of the current sheet.
    • Action: For this tutorial, select New Sheet and click Create.
  • Setting Up the Pivot Table
    • The pivot table is initiated with options for rows, values, and columns.
    • Step 3: Configure rows by adding the average phone use per day.
    • The pivot table organizes values from smallest to largest.
  • Creating a Pivot Group Rule
    • Action: Highlight the minutes data and right-click to select Create Pivot Group Rule.
    • Values: Set the minimum value to 72 and the maximum value to 350.

  • Calculating Class Interval

    • Formula to determine class interval size (K):

    [ K = \frac{(\text{Max} - \text{Min})}{\text{Number of Classes}} ]

    • Here, Max = 350, Min = 72.
    • Sturges' Formula to determine number of classes (K):

    [ K = 1 + 3.3 \log(n) ]

    • Where n = sample size (29).
    • Calculating using the formula gives K ≈ 5.8508 (rounded down to 5).
  • Class Interval Size Calculation
    • Determine class interval size:
    • Class interval = ( \frac{(350 - 72)}{5} ≈ 55.6 ), rounded down to 55.
    • Classes Definition:
    • Class 1: 72 to 126 (55)
    • Class 2: 127 to 181 (55)
    • Class 3: 182 to 236 (55)
    • Class 4: 237 to 291 (55)
    • Class 5: 292 to 350 (55)
  • Interpreting the Data
    • Note: Google Sheets does not show intervals without data points; e.g., there may be no data between 127 and 180.
  • Finalizing Frequency Distribution Table
    • Step 4: Add the count of persons in each class:
    • Click on values, add Person to reflect how many fall into each class interval.
    • Rename Columns: Example: Change column header to Frequency.
    • Definition of Frequency: Number of persons using their phones within each class.
  • Conclusion
    • The final FDT summarizes user data on average phone usage effectively.
    • Thank you for watching!