To find the corresponding value in column C on the same row where max or min value of Column B is found:.To find the corresponding x value of max or min value in column B, suppose B is an Y column.To find the corresponding row index number of max or min value in column B: If there are duplicate max/min values in column B, it returns the row index number of first occurance of max/min value.To find the maximum and minimum in column B:.Input the following into the F(x) cell or its Set Values dialog box: Since Origin 2017, Origin support spreadsheet cell notation in column formula so you can directly use B intead of col(B). You can use LabTalk functions in F(x)= cell or Set Values) dialog box to find the maximum and minimum value, index number, the corresponding xvalue, or corresponding value in any column. V4 = Table (col (B ), col (C ), Min (col (B ) ) ) Using Column Formula V3 = Table (col (B ), col (C ), Max (col (B ) ) ) Xvalue (list (min (col (B ) ),col (B ) ),col (B ) ) 2 ) Find corresponding value from a different column C : Xvalue (list (max (col (B ) ),col (B ) ),col (B ) ) To find the corresponding xvalue : 1 ) Find corresponding value from x column : MinIndex = list (min (col (B ) ),col (B ) ) MaxIndex = list (max (col (B ) ),col (B ) ) To find the maximum and minimum in column B : You can run the LabTalk script below in the Script Window (highlight one of the provided scripts below and press Enter): The following LabTalk functions( max() and min()) are provided for finding the maximum and minimum, the function list() finds the index number, and the function xvalue() finds the corresponding xvalue from a given index number. See: * The Statistics on Columns Dialog Box. In either dialog, you will find the check boxes for Minimum and Maximum under branch Quantities to Compute > Quantities. To bring up these tools, select Statistics:Descriptive Statistics:Statistics on Columns/Statistics on Rows. If the dataset is in a column or row, you can report the statistics and retrieve the minimum or maximum value. You can also right click on Status bar and Copy Statistics.īy Statistics on Columns/Statistics on Rows Tool You can right click on Status bar and check Min, Max, etc. When you highlight a column, multiple columns or a range of data in a worksheet, basic statistics of the selection shows on the Status bar located at the bottom of the Origin workspace.īy default Min and Max don't show. 2 By Statistics on Columns/Statistics on Rows Tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |