Mean Median Mode Calculator
The tool doesn't count empty cells or non-numeric cells.
What is the difference between mean median and mode?
The mean median and mode are measures of central tendency.
The mean is the arithmetic average, the median is the middle of a sorted set of number, and the mode is the value that appears the most often. If the distribution is perfectly symmetrical, the mean and median will have the same value.
When the distribution is perfectly symmetrical and has only one mode, the mean and median and mode will have the same value.
What is the mean?
The mean is a value that represents the middle of a set of numbers.
Usually, the mean refers to to the arithmetic mean or arithmetic average .
How to calculate the mean?
1. Add up all the numbers.
2. Count how many numbers there are.
3. Divide the addition by the count.
Mean formula
x̄ = | Σ𝑥i |
n |
Σxi - the addition of all the values.
What is the median?
The mean is a value that represents the middle of a set of numbers.
Usually, the mean refers to to the arithmetic mean or arithmetic average .
How to calculate the median?
1. Sort the numbers in ascending order.
2. Count how many numbers there are, n.
3. If n is odd number the median is the middle number, the (n+1)/2th number.
4. If n is even number the median is the average of the two middle numbers, the (n/2)th number, and the (n/2+1)th number.
Median formula
1. Odd number of values (n):
Median = x(n+1)/2
2. Even number of values (n):
Median = | Xn/2 + X(n/2+1) |
2 |
What is the difference between sample mean population mean?
The population mean (μ) is the mean of the entire population.
Sample mean (x̄) is the mean of a random sample of data.
Usually, we don't have the data of the entire population and we use the sample mean to estimation the population mean.
How to calculate the mode
1. Sort the numbers in ascending order.
2. Count how many times each number appears.
3. Check which numbers appear most frequently, this number is the mode.
If no value appears more than once, for example for a continuous variable, you may run an histogram and find the bin with the highest count, the median is the average of this bin.
Mode formula
Count(xj)=Maxi(Count(xi))Group Data mode
Mode = L + h | fx - f1 |
2fx - f1 - f2 |
Choose bin x with the highest frequency.
fx - the frequency of bin x.
L - lower limit of bin x.
f1 - the frequency of the bin to the left (lower bin).
f2 - the frequency of the bin to the right (upper bin).
h - bin size.
Example
Name | Bin | Frequency |
---|---|---|
0 - 10 | 5 | |
1 | 10 - 20 | 18 |
x | 20 - 30 | 23 |
2 | 30 - 40 | 15 |
40 - 50 | 13 |
Mode = 20 + 10 * | 23 - 18 | = 23.846 |
2*23 - 18 - 15 |
Should I use average or median?
Both average and median measure the central tendency of the data Usually, we use the average statistic.
We prefer the median in one of the following cases:
1. The data contains outliers.
2. The data is very skewed, and the sample size is not large
In these cases, one outlier or one rare extreme value might change the average dramatically.
The median is not affected by extreme values.
Outliers
It is not recommended to exclude the outliers unless you know the reason for each outlier.
We use the Tukey's Fences method with k = 1.5.
For more options, you may use the Outliers calculator
Round
When the number is greater than 1, it will round to decimal places, for smaller number it will round to precision.
Example, digits = 2, format 0.001234 to 0.0012, and 88.1234 to 88.12