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