The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 calculate mean and sem form group of column repeat

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: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
bankanidhi Posted - 11/23/2017 : 08:58:24 AM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:

Hi, i have say 1000 columns with same number of rows.
I want to calculate statistics on rows with 10 column each successively and store them in new columns. How should i write a script?

or is there a origin function to do this.

Thanks
2   L A T E S T    R E P L I E S    (Newest First)
bankanidhi Posted - 11/24/2017 : 07:17:15 AM
Dear Jacqueline,
Thanks. This is working really nice. Now one additional question. Suppse i want to write all the mean and SD to a new sheet in the same book, what would be the format?

Thanks,
Banka
JacquelineHe Posted - 11/24/2017 : 03:57:59 AM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000