The Origin Forum

The Origin Forum

All Forums

LabTalk Forum

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Chryseor	Posted - 10/08/2012 : 10:57:02 AM operating system: 8pro sr0 hello, is it somehow possible to select a range of column values (ie the 20 first values) and calculate the average value of this range and using then this value to normalize the whole column? thanks a lot for our help, cheers, chryseor
1 L A T E S T R E P L I E S (Newest First)
Penn	Posted - 10/10/2012 : 04:31:16 AM Hi chryseor, You can use the range notation to define part of the column values, and then use the stats function to perform statistics on this range to get the average value. Then to normalize the whole column. For example, the data is stored in column A, and select column B and right click to choose Set Column Values to open the Set Values dialog. In the Before Formula Script panel, put the following script. And the upper panel will be "col(A)/ave" (not sure what is your normalization method, just simplify the example). range rA = col(a)[1:20]; // range stats rA; // statistics double ave = stats.mean; // average The Set Values dialog should looks like: Penn

The Origin Forum