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())]))
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
55
while
mode([55,34,67,88,65])
34
I can't get the right answer by using this formula.
Thank Jim!
The JMP mode formula seems rather lax.
In Excel, no mode is returned as "#N/A", and JMP is returned as "minimum".
The minimum is a correct mode. There just happens to be more than one mode.
