FREQUENCY

The FREQUENCY function in Google Sheets calculates how many values from a data set fall into specified numeric ranges (or "bins"), returning the results as a vertical array. It's the go-to function for building histograms and distribution summaries directly within your spreadsheet. Dive into our comprehensive guide to master its application.

Parameters

• data: The array or range of values to analyze and count.
• classes: The array or range of bin boundaries to group the data into.

Step-by-Step Tutorial

1. Calculating a frequency distribution:
   • Example: If A1:A10 contains test scores and B1:B3 contains the bins 60, 75, 90, entering =FREQUENCY(A1:A10, B1:B3) will return an array showing how many scores fall into each bin.
   • Result: will return an array with one more value than the number of bins, with the last value counting anything above the highest bin.

Use Cases and Scenarios

1. Grade Distribution: Count how many students scored within specific grade ranges.
2. Histogram Building: Summarize numeric data into bins for charting.
3. Inventory Analysis: Group product quantities or prices into ranges for reporting.

Related Functions

• COUNTIF: Counts the number of cells that meet a specific condition.
• COUNTIFS: Counts cells that meet multiple conditions.
• LARGE: Returns the nth largest value from a data set.

Related Articles

• Understanding Statistical Functions in Google Sheets