Let’s work with the following rainfall records

## AVERAGE

The AVERAGE function returns the average of a cell range.

The average rainfall is 101,83

## MEDIAN

The median is a number that divides the sample into two parts, the population or the probability distribution such that each part contains the same number of values.

So in this example, the quantity of rainfall the most probable in the year is **100**.

## MODE

The mode is the number most often presented in a series.

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)

It is interesting to combine the MODE function with the COUNTIF function in a single formula, one can obtain the number of times what counted the most common in a series.

## QUARTILE

A quartile is one of three points that divide a data set into four equal groups, each representing a fourth of the distributed sampled population.

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:

The following table shows the breakdown by quartile.

We note that the QUARTILE 2 is equivalent to the median

## PERCENTILE

The percentile is based on the same principle as the quartile but in refining the accuracy with 10%.

This is the main difference with the QUARTILE function.

QUARTILE function

expects a valuebetween 1 and 4 and the function PERCENTILEexpects a percentage.