topic Re: Is there a Column Formula to find 2nd highest value? in Discussions

Is there a Column Formula to find 2nd highest value?

datascienceepe — Thu, 26 Apr 2018 18:42:13 GMT

Hello all -

I am wondering if someone can help with something that has been stumping me in JMP. I have columns 1-10 that contain a value from the RandomGamma(1) function. I am trying to come up with a formula to enter for column 11 that would pull out the second highest value of columns 1-10 for any row. It would be like finding the second highest Maximum for columns 1-10. Does anyone have any ideas of how to do this? I am a student who is new(ish) to JMP and would appreciate as simple an answer as possible as I am very much still learning.

Thanks!

Re: Is there a Column Formula to find 2nd highest value?

Wendy_Murphrey — Thu, 26 Apr 2018 19:44:18 GMT

The Sort Descending() function would return the values in descending order. The following demonstrates the concept. The subscript of 2 will capture the second highest value. You will need to change the column names to your actual column names:

Sort Descending( Eval List( {:A, :B, :C} ) )[2]

Hope that helps!

Re: Is there a Column Formula to find 2nd highest value?

datascienceepe — Thu, 26 Apr 2018 19:49:57 GMT

Thank you so much! That is exactly what I was wondering how to do! :)