topic Re: Col Mean without excluded rows in Discussions

Col Mean without excluded rows

tom_abramov — Mon, 06 Jan 2025 12:44:30 GMT

Hi.

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

Re: Col Mean without excluded rows

Victor_G — Mon, 06 Jan 2025 12:47:52 GMT

Hi @tom_abramov,

Happy new Year 2025 !

See previous response from @txnelson and @jthi on this exact same question :

Hope these solutions will also solve your problem,

Re: Col Mean without excluded rows

jthi — Mon, 06 Jan 2025 12:54:43 GMT

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())))
);