Origin Ver. 8 and Service Release (Select Help-->About Origin): Operating System: Xp X64
I have a worksheet with a series of temperatures for x values and lots of series of intensities as Y values from many samples. ive found how to use the statistics to give me the max value for each sample, but it doesnt tell me the X value at that point. is this possible? I have way too much data to do it manually.
You can do this with script using the limit command which has the syntax: limit <dataset> where <dataset> is a Y dataset with implied X and sets the limit structure as follows: limit.IMAX The row index where maximum Y occurs limit.IMIN The row index where minimum Y occurs limit.SIZE The size of the dataset limit.XMAX The maximum value in the X dataset limit.XMIN The minimum value in the X dataset limit.YMAX The maximum value in the Y dataset limit.YMIN The minimum value in the Y dataset
So you could use this script in the Before Formula Scripts section of Set Column Values for column b in this case: limit col(b); rowatmaxy = limit.imax; rowatminy = limit.imin; col(b)[C]$ = Max Y of $(limit.ymax) occurs at X of $(xof(col(B))[rowatmaxy]), Min Y of $(limit.ymin) occurs at X of $(xof(col(B))[rowatminy]).
max value statistics
Posted - 10/29/2009 : 4:59:42 PM
