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
 Origin Forum
 How to create a running mean		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

KLDEVRIES

UK
Posts
Posted - 04/10/2007 :  07:06:44 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): Origin Pro 7.5 student version
Operating System: Windows Vista

I'm completly new to Origin. But I now have to process worksheets of more than a million rows and so have moved to using Origin Pro instead of Excel. I've been through all the tutorial files, but am finding the software quite different from what I'm used to.

My question is very simple: How do I create a running mean? I have a column of data, and want to create a new column that contains a running mean of the first column. That is, I want to average all records in rows 1 thru 16 and store that as my first row value in the new column. Then I want to average rows 2 thru 17 and store that in my new row 2. Average 3 thru 18, and so on to the end of the column.

It sounds so simple, but how do I do that in Origin?

KLDEVRIES

UK
Posts
Posted - 04/10/2007 :  09:28:56 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I can't even seem to find a simple built-in average/mean function? Surely there must be one?
Go to Top of Page

Mike Buess

USA
3037 Posts
Posted - 04/10/2007 :  10:45:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
LabTalk's average command does pretty much what you want. Look for "Average command" in the index of the programming guide. Origin C also has an Average function that's above "Average command" in the index. Both versions actually smooth the data by Adjacent Averaging which is on the Analysis menu for graphs... Analysis > Smoothing > Adjacent Averaging

Mike Buess
Origin WebRing Member
Go to Top of Page

KLDEVRIES

UK
Posts
Posted - 04/10/2007 :  3:50:16 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks Mike,
With your help I've managed to get the ave command working, as long as I duplicate my column first so that I don't overwrite the original values!

And I see I'll need to use the Origin C average function if I want to average over an even number of rows.

Thanks again for your help.

Edited by - KLDEVRIES on 04/10/2007 4:13:29 PM

Edited by - KLDEVRIES on 04/10/2007 4:14:40 PM
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