Calculating mean and median and mode values
December 25, 2017Downloading and installing the ExQuilla addon – ExQuilla
December 26, 2017To 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)
