| Author |
 Topic  |
|
|
eno
Japan
34 Posts |
 Posted - 10/31/2005 : 8:22:52 PM
|
Origin Version : 7.5SR5
Operating System: Win XP Pro SP2
Hi all,
My question is about LabTalk script for statistics on rows.
1. How to select all/partial data in a row?
2. How to execute?
3. How to get max, mean, min, sd and total(like sum object)?
Thanks,
eno
|
|
|
Mike Buess
USA
3037 Posts |
Posted - 11/01/2005 : 07:36:34 AM
|
Hi eno,
1. The worksheet -s command can be used to select any range of contiguous cells...
worksheet -s c1 r1 c2 r2;
worksheet -s 0 2 0 2; // select all of row 2
worksheet -s 2 2 4 2; // select columns 2,3,4 in row 2
2 & 3. The Statistics on Rows menu command runs the [StatRow] section of the file WKS.ogs. All you need to know should be there.
Mike Buess
Origin WebRing Member |
 |
|
|
eno
Japan
34 Posts |
Posted - 11/01/2005 : 11:47:41 PM
|
Hi Mike,
Thank you for your advice.
When I have the following worksheet(data1),
1,2,3,
4,5,6,
and execute the script,
worksheet -s 1 1 3 2;
_sum=sum(data1,wks.c1,wks.c2);
copy -b 1 _mean data1_d -b 1 -e 2;
the worksheet becomes
1,2,3,2,
4,5,6,5,
That's right!
Again, many thanks.
|
|
|
| |
Topic |
|
|
|
Statistics on Rows ?