Calculating mean and median and mode values

To have the average of a certain data you can use the following

=average(range)

This will give you the average data in the range.

To get the median which is the value exactly in the middle.
=median(range)
If the values are even number, then the median would be the average of the 2 values in the middle.

To get the mode; which is the most common value in the range.
=mode(range)

To get multiple most common values
=mode.mult(range) you can use after typing this formula what is called an array function using ctrl+shift+enter … this would be after selecting 2 cells.

Read moreAnti-infective eye preparations