FREQUENCY Function in Google Sheets

Calculate frequency distributions of data using the FREQUENCY function.

FREQUENCY Function

The FREQUENCY function in Google Sheets calculates the frequency distribution of a dataset based on specified classes.

Syntax

FREQUENCY(data, classes)
  • data: The dataset to analyze.
  • classes: The bins or classes to group the data into.

Examples

  1. Basic Example

Calculate the frequency distribution of data in range A1:A10 based on bins in B1:B5:

=FREQUENCY(A1:A10, B1:B5)

Notes

  • Returns an array of frequencies corresponding to each bin.
  • COUNTIF: Count cells that meet a condition.