As a companion to my last question...
I need to identify the best window in a data table, e.g. from Samples/Data/Functional Data/Weekly Weather Data.jmp, I need to identify the X consecutive lines (moving window) with the highest TMAX by STATION. Not sure whether to use the window with the highest average, or the lowest minimum, so I'd like to know how to do both.
As before, I'm sure there's a way to do this with JSL, but I'd prefer to use a function if possible.
I've tried a bunch of things with Col Moving Average() and Col Rank() but it somehow feels just out of reach.
