| Author |
 Topic  |
|
|
carboran
6 Posts |
 Posted - 02/28/2014 : 09:27:05 AM
|
Hello
I'm 1 weekn in origin now, i have some questions:
first: i have a column B with 2500 or more values. Now i wanna find the biggest value (maximum) in this column. How do i do this?
the next question is:
I have 50 columns of Xn and Yn values n=1,2,3...50
i want find the maximum for all, as i've written before, but i dont wanna type each the same operation for each column.
how to do that?
Then for all this columns i want to have the mean value for rows 1-400.
then i want to divide each column by their corresponding mean value?
with regards |
|
|
zahraa
USA
52 Posts |
Posted - 02/28/2014 : 11:16:31 AM
|
Dear carboran,
You could find the max for column B by going to Window: Script Window and typing in the script window that opens.
dd=max(col(B));
dd=;
Highlight the text and press enter.
You could find the max for multiple columns by using the GUI. Select all your columns, go to Statistic: Descriptive Statistics: Statistics on Columns and in the dialog that opens select Max as the Quantile to compute and click OK. The max values for each column will appear in a new sheet and in a new report sheet:
For more information on the types of statistical analysis you can do in Origin read this:
http://www.originlab.com/index.aspx?go=Products/Origin/Statistics/DescriptiveStatistics
http://www.originlab.com/index.aspx?go=Products/Origin/Statistics
Another way to do this, is by using script again. Go to Windows: Script Window and in the script window that opens, type in:
for(ii=1; ii<=50; ii++)
{
range ss = [book1]sheet1!col($(ii));
dd = max(ss);
dd=;
}
Highlight the text and then press enter.
This will give you the max values for the first fifty columns in your worksheet.
This script was made in Labtalk. For more information on this, in your Origin project go to Help: Programming: Labtalk
and for more information on finding the max for single columns, or multiple columns and datasets, you can read:
http://wiki.originlab.com/~originla/ltwiki/index.php?title=LabTalk:Max_(function)
(please copy paste above link into your browser)
Originlab Technical Representative |
Edited by - zahraa on 02/28/2014 12:48:26 PM |
 |
|
| |
Topic |
|
|
|
finding max and mean value in a colum