| T O P I C R E V I E W |
| KLDEVRIES |
Posted - 04/10/2007 : 07:06:44 AM
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?
|
| 3 L A T E S T R E P L I E S (Newest First) |
| KLDEVRIES |
Posted - 04/10/2007 : 3:50:16 PM
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 |
| Mike Buess |
Posted - 04/10/2007 : 10:45:07 AM
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 |
| KLDEVRIES |
Posted - 04/10/2007 : 09:28:56 AM
I can't even seem to find a simple built-in average/mean function? Surely there must be one? |
