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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 mean of selected row values in a column
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ynnig

USA
Posts

Posted - 06/12/2008 :  2:23:26 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 7.5 sr6
Operating System: WinXP Pro

Hi~

Can someone help me with this? I would like to write a script that will take the mean and s.d. of a selected range of values within a column, and then place the result in designated separate columns?

Thanks!

Ginny

greg

USA
1380 Posts

Posted - 06/16/2008 :  3:00:41 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Here's something to start with:

start = wks.r1;
end = wks.r2;
%M = %H;
colM = colnum(Mean);
if(colM==0) wks.AddCol(Mean);
colS = colnum(SD);
if(colS==0) wks.AddCol(SD);
run.section(WKS,DescStats,1);
copy -b 1 %H_Mean %M_Mean -b start -e end;
copy -b 1 %H_SD %M_SD -b start -e end;
win -ca %H;



Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000