Table of Contents

  1. Spreadsheet Statistical Functions
    1. Methods of Averaging Data
    2. Arithmetic Mean
    3. The AVERAGE Function
    4. The Median
    5. The Mode
    6. Activity
  2. Frequency Distribution
    1. Frequency Distribution Table
    2. Frequency Calculations Using a Spreadsheet
    3. Step 1
    4. Step 2
    5. Step 3
    6. Step 4
    7. Step 5
  3. Analysing Frequency Distribution Tables
    1. Graphical Representation of Frequency Distribution
    2. Analysing the Graph
  4. Standard Deviation
    1. Finding the Standard Deviation