| T O P I C R E V I E W |
| jimmyr |
Posted - 10/29/2009 : 4:59:42 PM
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.
thanks in advance |
| 2 L A T E S T R E P L I E S (Newest First) |
| jimmyr |
Posted - 11/03/2009 : 03:51:45 AM
ok, thats a bit above my abilities!
im new to this sort of thing.
i think i will do it manually
|
| greg |
Posted - 11/02/2009 : 2:42:27 PM
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]).
|
