To get the minimum value (lowest value of the list)
To get the max value (which would be the biggest value of the list)
To get the values that are in the 25% place
This is called the first quartile value so we can
To get the values that are in the 50% place
This would be the 2nd quartile and to get it we can use
=quartile(range,2) this would also be the median
To get the values that are in the 75% place
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.