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
Normalize by dividing by mean of a selected range
Posted - 10/08/2012 : 10:57:02 AM
