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