ProductSolutionsTemplatesResourcesPricing

FREQUENCY

Calculates the frequency distribution of a one-column array into specified classes. Learn more

Video field
Array

The FREQUENCY function in Google Sheets is a statistical function that calculates the frequency distribution of a data set. It takes two arguments: an array or range of data, and an array or range of classes.

The function returns an array of values that represent the frequency of data values falling within each class. For example, if you have a list of test scores and want to know how many students scored between 0-50, 51-100, 101-150, etc., you can use the FREQUENCY function to get this information. Here's the syntax for the FREQUENCY function:

=FREQUENCY(data_array, classes)

Where: data_array: The array or range of data to be analyzed. classes: The array or range of classes to group the data into.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!