Let us consider some statistical functions in Excel. We look at :

- AVERAGE
- MEDIAN
- MODE

Here’s the definition of each one

**Average**which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.**Median**which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.**Mode**which is the most frequently occurring number in a group of numbers. For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.

Let us look at the examples:

__1. AVERAGE__

Suppose your data is like this :

To calculate the AVERAGE we use the function as follows :

=AVERAGE(B2:B8)

Averages all of numbers in list above (9.5)

=AVERAGE(B2:B4,B8)

Averages the top three and the last number in the list (27.5)

__2. MEDIAN__

Look at the above data. Let’s use the MEDIAN function.

=MEDIAN(B2:B8)

If you notice the mid section where numbers are greater or less than a number is 25. Hence the MEDIAN is also 25.

__3. MODE__

The most frequently occurring number is 30,

Hence =MODE (B2:B8) will yield 30.

Just shown you some of the statistical functions. There are many more.