average removing the largest and smallest

[gabrielfs2]

is there any way to calculate an average by removing the largest and smallest

[ArjenEX]

Hi @gabrielfs2

Perhaps the solutions from the same topic that you raised two weeks ago with some slight modifications can be used in this case as well?

Is it possible to create Excel function TRIMMEAN in knime?

@gabrielfs2 Modified workflow attached: Trimmean3.knwf (48.6 KB) [Screenshot_20230115_225130] Changes: You need to select have the grouping variable in the include box. The categories from this column will determine the grouping of the rows. Note that I have also selected Enforce Inclusion. It is worth understanding into which category (Exclude or Include) KNIME adds new columns if they are added to your workflow. If you select Enforce Inclusion then any new columns are added to the Exclu…

[Daniel_Weikert]

calculate min max either via math node or groub by node then filter or join the data (unmatched) and calculate the average
br