Calculation of Quartile

Hi all,

how can I calculate the Quartile which are equal to the excel formula “QUARTILE.INC”? I already found out, that you can do it with the GroupBy-Node and then use the aggregation “Quantil” with the settings 0,25; 0,5; 0,75 and 1. But which setting for the Estimation type do I need? I found out, that R_1 should fit, based on my tries with excel and KNIME, but according to wikipedia R_6 and R_7 should be the equivalent. But with R_6 and R_7 I dont achieve the same results as in Excel.

Just want to double check it and that it is not a coincidence that the values are matching with R_1.

Example data:

I want to find out the first to fourth Quartile for the following values:

Value
1750000
100000
30000000
10000
70000

The the interim result should be a table like that (which is achieved via excel function QUARTILE.INC):

Value Quartile
70000 1
100000 2
1750000 3
30000000 4

And in the end, the final step should be to assign a Quartile to each of the values from the first table like this:

Value Quartile
1750000 3
100000 2
30000000 4
10000 1
70000 1

Thank you in advance!
Dennis

Hi @Dennis6713 , you can use the AutoBin node and get a result like this:

autobin2

Here’s the configuration:

autobin

5 Likes

Wow. This works like a charm. Thank you very much!!!

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.