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.
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
Notify me of follow-up comments by email.
Notify me of new posts by email.
This site uses Akismet to reduce spam. Learn how your comment data is processed.