RangeFractile - script and chart function

RangeFractile() returns the value that corresponds to the n-th fractile (quantile) of a range of numbers.

Information note RangeFractile() uses linear interpolation between closest ranks when calculating the fractile.

Syntax:

RangeFractile(fractile, first_expr[, Expression])

Return data type: numeric

Arguments:

The argument of this function may contain inter-record functions which in themselves return a list of values.

• fractile: A number between 0 and 1 corresponding to the fractile (quantile expressed as a fraction) to be calculated.
• first_expr: The expression or field containing the data to be measured.
• Expression: Optional expressions or fields containing the range of data to be measured.

Examples:

Examples and results
Example Result
RangeFractile (0.24,1,2,4,6) Returns 1.72
RangeFractile(0.5,1,2,3,4,6)

Returns 3

RangeFractile (0.5,1,2,5,6)

Returns 3.5

Example: (using expression)

RangeFractile (0.5, Above(Sum(MyField),0,3))

In this example, the inter-record function Above() contains the optional offset and count arguments. This produces a range of results that can be used as input to the any of the range functions. In this case, Above(Sum(MyField),0,3) returns the values of MyField for the current row and the two rows above. These values provide the input to the RangeFractile() function. So, for the bottom row in the table below, this is the equivalent of RangeFractile(0.5, 3,4,6), that is, calculating the 0.5 fractile for the series 3, 4, and 6. The first two rows in the table below, the number of values in the range is reduced accordingly, where there no rows above the current row. Similar results are produced for other inter-record functions.

Example expression output
MyField RangeFractile(0.5, Above(Sum(MyField),0,3))
1 1
2 1.5
3 2
4 3
5 4
6 5

Data used in examples:

RangeTab:

MyField

1

2

3

4

5

6

] ;

Example: (in table form)

Add the example script to your document and run it. Then add, at least, the fields listed in the results column to a sheet in your document to see the result.

RangeTab:

LOAD recno() as RangeID, RangeFractile(0.5,Field1,Field2,Field3) as MyRangeFrac INLINE [

Field1, Field2, Field3

10,5,6

2,3,7

8,2,8

18,11,9

5,5,9

9,4,2

];

The resulting table shows the returned values of MyRangeFrac for each of the records in the table.

Example output in table form
RangeID MyRangeFrac
1 6
2 3
3 8
4 11
5 5
6 4

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!