Category Archives for Excel

EXCEL – Measuring maximums, minimums, and quartiles

To get the minimum value (lowest value of the list)

=min(range)

To get the max value (which would be the biggest value of the list)

=max(range)

To get the values that are in the 25% place

This is called the first quartile value so we can

=quartile(range,1)

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

=quartile(range,3)

 

 

 

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.

 

 

>