topic Re: Finding Min Value in a set of data and populating it in next column then selecting it to subset it in Discussions

Finding Min Value in a set of data and populating it in next column then selecting it to subset it

LearningJMP — Sat, 10 Jun 2023 23:50:33 GMT

Hi,

From the attached test2.JMP file I am looking to eventually get Subset of Result.JMP.

so basically I am looking to:

1) find the min value until there is no data for -3dB column then populate that min value in the next column but same row

2) Select the rows with only those min value populated in another column

3) Subset the selected rows.

I tried min, col min, rank etc functions but with no luck.

Finding that min value for only a set of rows (not all rows) in a particular column and then populating in next column is the main challenge.

Please help!

Re: Finding Min Value in a set of data and populating it in next column then selecting it to subset it

txnelson — Wed, 29 Jun 2022 20:54:32 GMT

Here is the formula that I cam up with

If( Row() == 1,
	theMin = 9999999999999;
	theCount = 0;
);
x = .;
If( Is Missing( :"-3dB"n ) == 0,
	If( theMIn >= :"-3dB"n,
		theMin = :"-3dB"n
	);
	If( Is Missing( Lag( :"-3dB"n, -1 ) ) == 1,
		x = theMin;
		theMin = 9999999999;
	,
		x = .
	);
);
x;

Re: Finding Min Value in a set of data and populating it in next column then selecting it to subset it

LearningJMP — Thu, 18 Aug 2022 20:47:51 GMT

Thank you

Re: Finding Min Value in a set of data and populating it in next column then selecting it to subset it

pauldeen — Fri, 19 Aug 2022 06:27:47 GMT

If you are building a script to do this analysis multiple times, then great!

If this is just a one time analysis, then the better way to do this is by making a graph and then selecting the points in the graph and subsetting them.

Re: Finding Min Value in a set of data and populating it in next column then selecting it to subset it

LearningJMP — Fri, 19 Aug 2022 16:59:32 GMT

Thank you Pauldeen.

It was for multiple times so had to create a script