MODE.SNGL()/MODE()
Syntax. MODE.SNGL(number1,number2,...)
Definition. This function returns the most frequent value of a data group. The result of the function is the characteristic that most often occurs in a data set.
Arguments
number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier) for which you want to calculate the mode. You can also use an array or a reference to an array instead of arguments separated by commas.
Background. The MODE.SNGL() function returns the most frequently occurring or repetitive value in an array.
Assume that two ranges contain certain data where half of the data has a low value and the other half has a high value. In this case, the AVERAGE() and MEDIAN() functions return ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
