Statistical Functions [DONE]

Feature requests
1

Hi

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

Thanks

Shaheed

2

Hi Shaheed,

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

3

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

4

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

5

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.

6

The “Statistical aggregation” action in version 4.1 calculates:

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

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.
Radu.

8

“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
9

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