| T O P I C R E V I E W |
| guy27 |
Posted - 05/21/2014 : 3:14:47 PM
OriginPro 9.1.0 (64-bit) Sr2
Windows7 Enterprise Service Pack 1
I would like to take the average per row, of the absolute values in a few columns.
The excel equivalent is:
> =AVERAGE(ABS(A1:C1))
> which an array formula it should be committed with Ctrl-Shift-Enter
> not just Enter.
Here a good explanation on an excel forum of what I want to do:
http://www.ozgrid.com/forum/showthread.php?t=45233
I tried statistics per row, put was unable to find a solution |
| 2 L A T E S T R E P L I E S (Newest First) |
| guy27 |
Posted - 05/22/2014 : 02:05:28 AM
Thanks,
especially the second solution is really useful as an example of how to do more complicated calculations using the formula entry with a script. |
| lkb0221 |
Posted - 05/21/2014 : 3:28:40 PM
Hi,
You can first add all abs value together and then divided by the number of columns, like:
(abs(col(A))+abs(col(B))+abs(col(C)))/3
Or, please see my example below, for that if you use variables:insert variables by selection, Origin will assign range by r# automatically:
And you only need to change the start and end value of the jj loop.
Zheng
OriginLab |
|
|
