Let us consider some statistical functions in Excel. We look at :
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:
Suppose your data is like this :
To calculate the AVERAGE we use the function as follows :
Averages all of numbers in list above (9.5)
Averages the top three and the last number in the list (27.5)
Look at the above data. Let’s use the MEDIAN function.
If you notice the mid section where numbers are greater or less than a number is 25. Hence the MEDIAN is also 25.
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.