Syntax
=QUARTILE.EXC(array, quart)Arguments
| Argument | Required | Description |
|---|---|---|
array | Required | The numbers |
quart | Required | Which quartile, 1 to 3 |
How to use QUARTILE.EXC
QUARTILE.EXC takes 2 required arguments. Type =QUARTILE.EXC( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=QUARTILE.EXC({6,7,15,36,39,40,41,42,43,47,49}, 1)Result =QUARTILE.EXC({6,7,15,36,39,40,41,42,43,47,49}, 3)Result Related statistical functions
- PERMUTATIONAReturns the number of arrangements of items chosen from a set when items can repeat.
- PHIReturns the density of the standard normal distribution at a value.
- POISSON.DISTReturns the Poisson distribution probability of a number of events.
- PROBReturns the probability that values fall between two limits, given the probability of each value.
- QUARTILE.INCReturns a quartile of the values: 0 minimum, 1 first quartile, 2 median, 3 third quartile, 4 maximum.
- RANK.AVGReturns the rank of a number in a list; equal values get the average of their ranks.
- RANK.EQReturns the rank of a number in a list; equal values share the top rank.
- RSQReturns the square of the correlation coefficient (the R squared of a straight line fit).
- SKEWReturns the skewness of a sample (how lopsided the distribution is).