Excel: mean, median, mode

Three empty concrete seats

A lot of people will use Microsoft Excel to do their analysis as it is installed on their desktop computer. To do basic descriptive statistics you will need to know how to calculate the mean, median and mode.

Mean

To calculate the mean requires the AVERAGE function as follows:

=AVERAGE(cell_ref1:cell_ref2)

For example:

=AVERAGE(B2:B12)

Calculates the mean of the values contained in the range B2 to B12.

Median

The median refers to the central value of a set of values:

=MEDIAN(cell_ref1:cell_ref2)

If an even number of values is supplied to the MEDIAN function, the result will be calculated by taking the mean of the middle two values; this ensures that half of the data set is above the median value, and half of the dataset is below the median.

Mode

We use the MODE function when we want to find the most frequently occurring value.

=MODE(cell_ref1:cell_ref2)

Be the first to comment on "Excel: mean, median, mode"

Leave a comment

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.