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)

 

 

 

>