• Futurama Formulas - Date and time
• Futurama Formulas - Math
• Futurama Formulas - Statistical
• Futurama Formulas - Text
• Futurama Formulas - Logical
• Futurama Formulas - Table
• Futurama Formulas - Document
• Futurama Formulas - Conversion
• Futurama Formulas - Matrix
• Creating custom formulas in Futurama

Module: Editor

Version: 5.1.4 +

Type: Double

Category: Matrix

## Description

The formula 'Percentile' returns the percentile of a matrix over a specified dimension. This formula is changed in Futurama 5.3.0. See this page for more information.

## Parameters

Matrix:               the matrix you want to take the percentile of.

Percentile:          the percentile value from 0 to 1.

Dimension:         the dimension you want to take the percentile of. 1 means rows (downwards), 2 means columns (rightwards).

## Example

### Description

In the following example the formula 'Percentile' is used to take the 50% percentile of a matrix.

Matrix:

Column1
2
4
8
3

Percentile: 0,9

Dimension: 1

### Result

Number: 6,8

This result is calculated by:

1. ordening the array from small to large: {2,3,4,8}
2. first index in the array is 0, last index in the array is n-1 (in this example 3)
3. 90% percentile is index 90% * 3 = 2,7
4. interpolation between the values at index 2 and index 3 as follows: 30% * 4 + 70% * 8 = 6,8