Relative Frequency Distribution in Google Sheets

# Relative Frequency Distribution in Google Sheets

How to Construct a Relative Frequency Distribution and a Cumulative Relative Frequency Distribution in Google Sheets

Written by Michael Mancuso

Updated over a week ago

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

- Paste the frequency distribution into cell A1 of Google Sheets so the values are in column A and the frequencies are in column B.
- Enter “Relative Frequency” in cell C1.
- 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.
- Use the fill down feature to extend the formula from C2 down to construct the relative frequency distribution.
- Enter “Cumulative Relative Frequency” in cell D1. Enter “=SUM($C$2:C2)” in cell D2 to set up the cumulative relative frequency calculations.
- Use the fill down feature to extend the formula from D2 down to construct the cumulative relative frequency distribution.

- 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.
- Enter “Cumulative Relative Frequency” in cell C1. Enter “=SUM($B$2:B2)” in cell C2 to set up the cumulative relative frequency calculations.
- Use the fill down feature to extend the formula from C2 down to construct the cumulative relative frequency distribution.