Hi,
You can try to use Labtalk script to calculate statistics on rows with 10 column.
For example, if you want to get the sum on rows for each 10 column, then you can:
1. Active the worksheet with the datasets:
2. Select Windows: Script Window.. and then paste the following loop script into the window. Highlight all script, and press Enter key.
for (ii = 1; ii<1000; ii+=10)
{
rowstats irng:=[Book1]Sheet1!Col($(ii)):Col($(ii+9)) mean:=<none> sd:=<none> sum:=<new>;
}
Note: for the function rowstats, it will calculate mean and sd by default. If you do not need to get them you need to add mean:=<none> sd:=<none> in the script.
To know more details, about rowstats function and loop script, plesae refer to these help page:
https://www.originlab.com/doc/LabTalk/ref/For-cmd
https://www.originlab.com/doc/LabTalk/guide/Descriptive-statistics
https://www.originlab.com/doc/X-Function/ref/rowstats
Thanks
Jacqueline
OriginLab
calculate mean and sem form group of column repeat
Posted - 11/23/2017 : 08:58:24 AM
