The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel
MODE returns the most frequently occurring, repeated value in a given data array. MODE is not as common as other functions, but sometimes you still have to use MODE to get statistics when needed.
The following article describes the syntax and usage of the MODE function in Excel.
Description
The MODE function returns the value with the most frequent occurrence in an array or data range.
Syntax
= MODE (number1, [number2] .)
Inside:
- number1: the first argument that you want to calculate weak, required.
- number2: the next argument is an optional argument and a maximum of 255 arguments.
You can use a single array or reference an array instead of arguments.
Note
- Arguments can be numbers, arrays, or references that contain numbers.
- Arguments that are text or error values that cannot be converted into numbers will cause the function to fail.
- If an argument, reference, or array contains a logical value, text, or a blank cell, it will be ignored, cells with a value of 0 will be counted.
- If no argument is repeated more than 2 times, the function displays an error.
- There are many numbers with the same frequency of occurrence, the result will be the first argument appears.
For example
Find the number with the most frequent occurrence in the Values column in the data table:
You can apply the MODE function with the arguments that contain cells separated by commas as follows: = MODE (C6, C7, C8, C9, C10, C11).
In addition, you can also apply the MODE function with an array argument containing the values: = MODE (C6: C11).
Although the MODE function has now been replaced by new functions with greater accuracy and names that reflect their uses, MODE is still used. With the syntax and usage of the MODE function is very simple, you can easily use the function. Good luck!
You should read it
- GEOMEAN function - The function returns the average of a positive array or range of data in Excel
- How to use the Match function in Excel
- The Match function (the function searches for a specified value in an array or cell range) in Excel
- LOOKUP function searches in Excel
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
- LOGEST - The function returns an array of data that describes an exponential curve that fits the data given in Excel
- PERCENTILE.EXC function - The function returns the kth percentile of values in the range, with k in the range from 0 to 1 in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
May be interested
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excelpercentile.inc function: the function returns the kth percentile of values in the range with k in the range from 0 to 1. syntax: percentile.inc (array, k)
- LINEST function - The function returns a line description array using the least square method in Excellinest function: the function returns the line description array using the least squares method. syntax: linest (known_ys, [known_xs], [const], [stats])
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excelquartile.inc function: the function returns the quartile of a data set, with percentile values from 0 to 1 including 0 and 1. support functions from execl 2010 onwards. syntax: quartile.inc (array, quart)
- ZTEST function - Returns the probability value on one side of the z test in Excelztest function: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- Instructions for using Index function in Excelindex is a function that returns an array in excel. when using the index function, you get the values in a cell between the column and the row.
- TTEST - Returns the probability associated with a Student's t-Test in Exceldescription: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excelbinom.dist.range function: the function returns the probability of a test result using binomial distribution. support functions from the excel 2010 version. syntax: binom.dist.range (trials, probability_s, number_s, [number_s2])
- Z.TEST function - The function returns one-sided value of the z test in Excelz.test: the function returns the one-sided p value of the z test. support functions from excel 2010 onwards. syntax: z.test (array, x, [sigma])
- PEARSON function - The function returns the Pearson product moment correlation coefficient in Excel: the function returns the pearson product moment correlation coefficient, r with a scalar index in the range from -1 to 1. the function reflects the linear relationship expansion between the two data sets. syntax: pearson (array1, array2)