SheetFX
≡
<< Go back to all functions

FREQUENCY

The FREQUENCY function in Google Sheets calculates the frequency distribution of a one-column array into specified classes. It is a useful tool for analyzing data and understanding its distribution across different ranges.

Function Syntax and Parameters

Syntax: FREQUENCY(data, classes)

Parameters:

  • data: The one-column array of data to analyze.
  • classes: The array representing the class intervals or bins.

Step-by-Step Tutorial

  1. Using FREQUENCY to calculate frequency distribution:
    • Example: If A1:A10 has the values 5, 12, 8, 15, 20, 8, 10, 5, 10, 15 and B1:B4 has the values 0, 10, 15, 20, then enter =FREQUENCY(A1:A10, B1:B4) in C1:C4 to get the frequency distribution.

Use Cases and Scenarios

  1. Data Analysis: Understand the distribution of data points across different intervals.
  2. Survey Responses: Analyze the responses to a survey question based on different answer options.
  3. Test Scores: Group and analyze test scores to determine the frequency of scores falling within specific ranges.

Related Function

  • HISTOGRAM: Generate a histogram from a set of data.

Related Article