# Statistical Functions [DONE]

Hi

It would be great to have a wider range of statistical functions.

Thanks

Shaheed

Hi Shaheed,

what statistical functions would you consider to be the most essential?

Median, Mode and Standard Deviation would be a good start.

Hi Dmitry,

Is the standard deviation function already available ?

It would also be nice to have a function to calculate quartiles or percentiles.

Thanks,
Nikolaas

Hi Nikolaas,

statistical functions are not available yet. You can read in Release Notes whatâ€™s available in new releases. When statistical functions become available, it will be indicated in Release Notes.

The â€śStatistical aggregationâ€ť action in version 4.1 calculates:

• Median
• Percentile
• Standard deviation
• Standard error
• Variance

Hello,

Great feature! Very useful.
Can you provide us more details about how is works Percentile mode: Inclusive, Exclusive, Nearest Rank in â€śStatistical aggregationâ€ť transformation ?

Thank you.

â€śInclusiveâ€ť is equivalent to PERCENTILE (now obsolete) and PERCENTILE.INC in Excel.

â€śExclusiveâ€ť is equivalent to PERCENTILE.EXC in Excel.

â€śNearest rankâ€ť is explained here: https://en.wikipedia.org/wiki/Percentile#The_nearest-rank_method

1 Like

Hi Dmitry,

It would also be very useful if we could calculate this using the subtotal action.

Use case: we want to replace empty values by the median of a subset. Now we have to create a separate table using statistical aggregation. Then merge de result into the dataset.

Could this also be extended to include the mode into this action ?

Thanks !
Nikolaas