FREQUENCY Function in Excel: Syntax, Examples and Free Practice
FREQUENCY is an Excel Statistical function. Shows how often values occur within ranges (bins).
FREQUENCY syntax
Arguments
data_array: The values to group into binsbins_array: The set of ranges to group the values into
When to use FREQUENCY
FREQUENCY is used in data analysis work to summarize or test patterns across a data set.
Practice FREQUENCY online, free
Open the live Excel-style spreadsheet and try FREQUENCY yourself. No Excel install or sign-up needed to start.
Practice FREQUENCY now →More Statistical functions
Frequently asked questions
What does the FREQUENCY function do in Excel?
Shows how often values occur within ranges (bins).
What is the syntax of FREQUENCY in Excel?
The syntax is =FREQUENCY(data_array, bins_array). data_array: The values to group into bins; bins_array: The set of ranges to group the values into.
Where can I practice FREQUENCY online for free?
Open the free live spreadsheet on Cellgrids and try FREQUENCY yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts