- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - MODE.SNGL Function
Description
The MODE.SNGL function returns the most frequently occurring, or repetitive, value in an array or range of data.
Syntax
MODE.SNGL (number1, [number2]...)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Number1 | The first argument for which you want to calculate the mode. | Required |
| Number2, ... | Arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas. |
Optional |
Notes
The MODE.SNGL function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.
Arguments can either be numbers or names, arrays, or references that contain numbers.
If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
If a value that is supplied directly to the Function (i.e. not part of an array of supplied values) is non-numeric, MODE.SNGL returns the #VALUE! Value.
If the data set contains no duplicate data points, MODE.SNGL returns the #N/A error value.
Applicability
Excel 2010, Excel 2013, Excel 2016
Example
