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
 finding the Median of 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

FabianG.

Germany
2 Posts
Posted - 10/28/2009 :  10:16:48 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:

Hi,
i want to get the median for a column. I have about 500 Sheets and i am writing a Macro at the moment. I used this command:

col(13)[1] = stat.DS.median(col(9));

i want to write in the first line of col(13) the median of all data in col(9). Both colums exists in the worksheet!

thanks Fabian

greg

USA
1378 Posts
Posted - 10/28/2009 :  1:27:20 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You failed to fill in the version number so I am guessing from your question that you are using 7.5 or earlier. Too bad, because 8SR6 makes it as easy as your question suggests:
col(13)[1] = median(col(9));

Two extra lines are required in earlier versions:
STAT.DS.DATA$ = %(%H,9);
STAT.DS();
col(13)[1]=STAT.DS.MEDIAN;
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