/

QuartileExc

[this page | pdf]

Function Description

Returns the quartile of a series (treating the lowest value as corresponding to the ’th percentile and the highest as corresponding to the ’th percentile), i.e. the value of  where.

 

The equivalent function in Microsoft Excel is QUARTILE.EXC. See also MnPercentileExc.

 


NAVIGATION LINKS
Contents | Prev | Next


Output type / Parameter details

Output type: Double
Parameter NameVariable TypeDescription
InputArrayDouble()Array containing data series to be analysed
quartIntegerQuartile to be returned (1, 2 or 3)

Links to:

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other Statistical functions

-          Computation units used


Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement


Desktop view | Switch to Mobile