Author |
Topic |
|
kara31
2 Posts |
Posted - 01/13/2012 : 05:12:25 AM
|
Hi,
I'm a new user of Origin so probably my question is stupid but I've already searched in the Help section and I couldn't find anything.
I would like to search for the minimum value in a column in my worksheet. But I don't want the minimum of the entire column, just on a specified range of lines (let's say the minimum between lines 1-3500) How can I do that?
I've tried things such as min(col(A)[1];col(A)[3500]) but it doesn't work.
Thanks for your help.
Kara |
|
Drbobshepherd
USA
Posts |
Posted - 01/13/2012 : 10:42:54 AM
|
Range notation comes in handy when you want to analyze subsets. Try:
range rr=col(A)[1:3500]; col(B)[1]=min(rr);
Your result should appear in column B, cell 1. |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 01/13/2012 : 11:03:23 AM
|
Or, if you don't want to type any command, you can highlight the range in the column (can use SHIFT+CLICK to select a contiguous range), and choose "Statistics: Descriptive Stats: Stats on Columns" menu.
--Hideo Fujii OriginLab |
Edited by - Hideo Fujii on 01/13/2012 11:05:53 AM |
|
|
kara31
2 Posts |
Posted - 01/16/2012 : 03:26:52 AM
|
Thank you both for your answer! it works perfectly |
|
|
DrXM
Germany
2 Posts |
Posted - 03/04/2015 : 05:20:10 AM
|
Thank you for posting your doubt kara31, I had the same question.
I have employed Drbobshepherd's suggestion #2, it does exactly what I wanted to do.
Thank you.
XM |
|
|
snowli
USA
1381 Posts |
Posted - 03/04/2015 : 10:56:14 AM
|
Just FYI:
min(col(A)[2:4])= works.
Thanks, Snow |
|
|
diladik
USA
1 Posts |
Posted - 03/16/2015 : 10:37:13 PM
|
Thanks guys this answer my question
author of linda ikeji blog |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 03/17/2015 : 11:36:59 AM
|
Hi,
Here is another easy way - In recent versions, the statistics of the highlighted cells are shown in the right side of the status bar at the bottom of the Origin window.
You can customize which statistics including the minimum are displayed. Right-clicking the status bar, and choosing "Copy Statistics" flyout copy the statistics in the clipboard as shown below. The advantage of this method is that it gives you the result even when the discontiguous blocks are selected.
--Hideo Fujii Originlab |
Edited by - Hideo Fujii on 03/17/2015 2:05:24 PM |
|
|
Yooun
Australia
1 Posts |
Posted - 05/10/2015 : 10:47:12 PM
|
Hi,
How can we find the minimum for multiple ranges with an increment? for example, I want to find a minimum between A and B with an increment of 800 until the end point of the data..
e.g: Find a minimum for 100-200, 900-1000, 1700-1800, 2500-2600, 3300-3400 and so on (with an increment of 800)
I have so much data where I need to find a minimum value at specific ranges with some increment for the whole data
Regards, Yooun |
|
|
SeanMao
China
288 Posts |
Posted - 05/11/2015 : 01:50:34 AM
|
Hi,
What you are looking for is "Reduce by Group" feature in Origin which can be accessed from menu Analysis: Data Manipulation: Reduce by Group.
Set SubGroup Method to be "By X Increment", set X Increment to 800, Merge Y by "Min".
Regards!
Sean
OriginLab Tech. Service
|
|
|
|
Topic |
|