How a box and whisker chart computes its quartiles (Excel.ChartBoxQuartileCalculation).
Excel.ChartBoxQuartileCalculation
Inclusive
QUARTILE.INC
linear
p
p * (n - 1)
Exclusive
QUARTILE.EXC
weibull
p * (n + 1)
How a box and whisker chart computes its quartiles (
Excel.ChartBoxQuartileCalculation).InclusiveisQUARTILE.INC, numpy'slinear: thepquantile sits at rankp * (n - 1), counting from 0.ExclusiveisQUARTILE.EXC, numpy'sweibull: rankp * (n + 1), counting from 1, held at the smallest and largest value outside them.