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 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.