topic Re: How to find the mode of multiple columns and partial rows? in Discussions

How to find the mode of multiple columns and partial rows?

lwx228 — Fri, 09 Jun 2023 23:36:21 GMT

For example, add new columns with "Big Class. JMP ", and find the mode of the data in the same row of the "height"、"weight" columns and the five rows above.

Thanks!

mode(Range(:weight[Index(Row()-5,Row())], :height[Index(Row()-5,Row())]))

Re: How to find the mode of multiple columns and partial rows?

lwx228 — Sun, 30 Aug 2020 07:27:00 GMT

I can't get the right answer by using this formula.

Thanks!

Re: How to find the mode of multiple columns and partial rows?

txnelson — Sun, 30 Aug 2020 11:24:38 GMT

Here is the formula that I came up with

If( Row() > 6,
	Mode( Matrix( :height[Index( Row() - 5, Row() )] ) || Matrix( :weight[Index( Row() - 5, Row() )] ) ),
	Mode( Matrix( :height[Index( 1, Row() )] ) || Matrix( :weight[Index( 1, Row() )] ) )
)

Note: The Range() function returns the minimum and maximum values found in the list or matrix

Note: JMP returns the minimum mode value if there is more than one mode

mode([77,55,33,77,55])

returns

while

mode([55,34,67,88,65])

returns

Re: How to find the mode of multiple columns and partial rows?

lwx228 — Sun, 30 Aug 2020 23:46:29 GMT

Thank Jim!

The JMP mode formula seems rather lax.

In Excel, no mode is returned as "#N/A", and JMP is returned as "minimum".

Re: How to find the mode of multiple columns and partial rows?

txnelson — Sun, 30 Aug 2020 23:53:32 GMT

The minimum is a correct mode. There just happens to be more than one mode.

Re: How to find the mode of multiple columns and partial rows?

lwx228 — Mon, 31 Aug 2020 00:14:57 GMT

Whether this can be verified

Re: How to find the mode of multiple columns and partial rows?

txnelson — Mon, 31 Aug 2020 00:47:24 GMT

It is a simple matter to determine if more than one value was found that determined what the mode is. If you want to set the resulting mode to a missing value when the mode comes from a single value, you can use the below logic

Names Default To Here( 1 );
mat = [1, 2, 3, 4, 5, 1];
xmode = Mode( mat );
If( N Rows( Loc( mat, xmode ) ) == 1,
	x = .
);
Show( xmode );