Associated Learning Objectives: 

  • Construct and understand frequency tables for a set of business-related data
  • Construct and understand frequency tables for a set of data

Step-by-Step Instruction:

From a Frequency Distribution:

  1. Paste the frequency distribution into cell A1 of Google Sheets so the values are in column A and the frequencies are in column B.
  2. Enter “Relative Frequency” in cell C1.
  3. Enter “=B2/SUM(B$2:B$#)” in cell C2, where # is the row number of the cell with the last frequency. For example, if the last frequency is in cell B12, enter “=B2/SUM(B$2:B$12)” in cell C2 to calculate the relative frequency of the value in A2.
  4. Use the fill down feature to extend the formula from C2 down to construct the relative frequency distribution.
  5. Enter “Cumulative Relative Frequency” in cell D1. Enter “=SUM($C$2:C2)” in cell D2 to set up the cumulative relative frequency calculations.
  6. Use the fill down feature to extend the formula from D2 down to construct the cumulative relative frequency distribution.

From a Relative Frequency Distribution:

  1. Paste the frequency distribution into cell A1 of Google Sheets so the values are in column A and the relative frequencies are in column B.
  2. Enter “Cumulative Relative Frequency” in cell C1. Enter “=SUM($B$2:B2)” in cell C2 to set up the cumulative relative frequency calculations.
  3. Use the fill down feature to extend the formula from C2 down to construct the cumulative relative frequency distribution.
Did this answer your question?