Col Mean without excluded rows

[#1]

Hi.

Is there a way to add a Col Mean formula so the excluded rows will be excluded from the calculation?

[#2]

Hi @tom_abramov,

Happy new Year 2025 !

See previous response from @txnelson and @jthi on this exact same question :Why is my column mean not matching with one calculated via the distribution platform, after excludin... 

Hope these solutions will also solve your problem,

[#3 · Accepted solution]

Since JMP16? you can add Excluded(Row State()) to Col statistical functions

Do note that it will still calculate Mean for excluded rows as a separate "excluded" group.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << Clear Row States << Select Rows(Index(1, 10)) << Exclude;
dt << New Column("Col Mean for each Sex", Formula(Col Mean(:height, :sex)));
dt << New Column("Col Mean for each Sex grouped by Excluded",
	Formula(Col Mean(:height, :sex, Excluded(Row State())))
);