Let’s work with the following rainfall records
The average rainfall is 101,83
So in this example, the quantity of rainfall the most probable in the year is 100.
In our example, the mode is equal to 57.
If all values are unique, the function returns an error.
Be careful to not confuse the MODE function with the function MOD (modulo)
In our example, we will split the values into 4 groups ranging from 15 to 186. The function needs the range of cells that contains data and a value corresponding to the Quartile
The last parameter range from 1 (first quarter) to 4 (last quarter).
The first quartile (25% of the rainfall) is:
We note that the QUARTILE 2 is equivalent to the median
This is the main difference with the QUARTILE function.
QUARTILE function expects a value between 1 and 4 and the function PERCENTILE expects a percentage.