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


This will give you the average data in the range.

To get the median which is the value exactly in the middle.
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.

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.