825947_en-US

liliconcom

Col Mean without excluded rows

Hi.

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

Data Blending and CleanupRe: Col Mean without excluded rows

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 excluding row(s)? 

 

Hope these solutions will also solve your problem,

Re: Col Mean without excluded rows

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