Syntax
=QUARTILE.INC(array, quart)Arguments
| Argument | Required | Description |
|---|---|---|
array | Required | The numbers |
quart | Required | Which quartile, 0 to 4 |
How to use QUARTILE.INC
QUARTILE.INC takes 2 required arguments. Type =QUARTILE.INC( 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.INC({1,2,4,7,8,9,10,12}, 1)Result Related statistical functions
- 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.EXCReturns a quartile of the values using exclusive percentiles: 1, 2 or 3.
- 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).
- SKEW.PReturns the skewness of a whole population.