QUARTILE.EXC takes two arguments, thearraycontaining numeric data to analyze, andquart,indicating which quartile value to return.
The QUARTILE.EXC function accepts 3 values for thequartargument, as shown in the table below.
The screen below shows how QUARTILE.INC and QUARTILE.EXC return different results for the same data.
Note QUARTILE.EXC cannot be used to get the minimum or maximum value like QUARTILE.INC.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
For example, =MEDIAN(1,2,3,4,5) returns 3.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
PERCENTILE Function
The Excel PERCENTILE function calculates the “kth percentile” for a set of data.
A percentile is a value below which a given percentage of values in a data set fall.
you might use PERCENTILE to determine the 90th percentile, the 80th percentile, etc.
