The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Minimum value?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

kara31

2 Posts

Posted - 01/13/2012 :  05:12:25 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page

Hideo Fujii

USA
1582 Posts

Posted - 01/13/2012 :  11:03:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

kara31

2 Posts

Posted - 01/16/2012 :  03:26:52 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you both for your answer!
it works perfectly
Go to Top of Page

DrXM

Germany
2 Posts

Posted - 03/04/2015 :  05:20:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
1386 Posts

Posted - 03/04/2015 :  10:56:14 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Just FYI:

min(col(A)[2:4])= works.

Thanks, Snow
Go to Top of Page

diladik

USA
1 Posts

Posted - 03/16/2015 :  10:37:13 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks guys this answer my question

author of
linda ikeji blog
Go to Top of Page

Hideo Fujii

USA
1582 Posts

Posted - 03/17/2015 :  11:36:59 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

Yooun

Australia
1 Posts

Posted - 05/10/2015 :  10:47:12 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

SeanMao

China
288 Posts

Posted - 05/11/2015 :  01:50:34 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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

Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000