| Author |
 Topic  |
|
|
carmi
9 Posts |
 Posted - 03/04/2013 : 8:55:44 PM
|
Origin Ver.9 and Service Release (Select Help-->About Origin):
Operating System:64 bit
Hi,
the most basic things in excel is averaging data.
in that way i can perform very easily an average on the desired set, i.e if i have a column with 100 rows i can perform an average on every 5 adjacent rows.
in origin for some reason i found it to be very complicated.
how can i do it?
Thanks in advanced.
carmi
 |
|
|
matthew@originlab.com
73 Posts |
Posted - 03/05/2013 : 11:49:21 AM
|
Hi Carmi,
I’m assuming you want to find the average of rows 1-5, then of rows 6-10, and so on, so that if you had 20 rows in your original column, you would find 4 averages. To do this you can follow these steps:
1. Select your column and make sure it is designated as a Y column, if it is not then you can select it and right click on it and choose Set As > Y
2. Now, with the column still selected, go to Analysis > Data Manipulation > Reduce to Evenly Spaced X > Open Dialog…
3. Make sure the subgroup is “Every N Points”, that the Resample Factor is 5, that the Sampling Method is “Y Mean”, and that the Output is “(<autoX>,<new>)”, then click ok
==> A new column should appear in your worksheet with the averages you want
Let me know if that accomplishes what you were trying to do
Matthew
OriginLab |
 |
|
|
matthew@originlab.com
73 Posts |
Posted - 03/05/2013 : 12:22:19 PM
|
Hi Carmi,
Additionally, if you meant that you wanted to get a moving average, you can:
1. Create a new column, and with that column selected press CTRL+Q to open the set column values dialog.
2. Go to F(x) > Statistics > movavg(vd,n1,n2)
3. Highlight vd and go to the Col(A) menu and select the column containing your original data
4. Change both n1 and n2 to 2, this indicates that each value in the new column will be the average from the 2 rows before through the 2 rows after the corresponding row in the original data. Alternatively you could set n1 to be 0 and n2 to be 4, and the values in the new column would be the average of the corresponding row in the original column, and the 4 following rows.
5. Click "Apply" to set the column values.
==> The new column should populate with the moving average values.
Matthew
OriginLab |
|
|
|
carmi
9 Posts |
Posted - 03/05/2013 : 12:27:25 PM
|
Hi Matthew,
Thanks for the answer;
This is one way to perform it. usually I'm using moving average, i.e if I'm performing an average on 5 points and I'm in row 3 it will compute the average on 1-5, in row 4 it will compute 2-6, and so on,
Thanks again
Carmi
quote:
Originally posted by matthew@originlab.com
Hi Carmi,
I’m assuming you want to find the average of rows 1-5, then of rows 6-10, and so on, so that if you had 20 rows in your original column, you would find 4 averages. To do this you can follow these steps:
1. Select your column and make sure it is designated as a Y column, if it is not then you can select it and right click on it and choose Set As > Y
2. Now, with the column still selected, go to Analysis > Data Manipulation > Reduce to Evenly Spaced X > Open Dialog…
3. Make sure the subgroup is “Every N Points”, that the Resample Factor is 5, that the Sampling Method is “Y Mean”, and that the Output is “(<autoX>,<new>)”, then click ok
==> A new column should appear in your worksheet with the averages you want
Let me know if that accomplishes what you were trying to do
Matthew
OriginLab
|
|
|
|
Drbobshepherd
USA
Posts |
Posted - 03/05/2013 : 12:36:44 PM
|
Carmi,
If you are fond of using the Set Column dialog box (selected by menu or Ctrl-Q), but you don't want to execute a moving average, you can still go that route to re-sample your data. Follow Matthew's instructions for performing a moving average, but choose the ave(vd,n) function for F(x)instead. For vd, substitute the column of your original data, and for n enter 5. Then click on "Apply".
DrBob |
|
|
|
carmi
9 Posts |
Posted - 03/05/2013 : 7:18:13 PM
|
Hi everybody,
Thanks a lot for your kindly help,
With your instruction I found it very easy to calculate
Carmi
quote:
Originally posted by Drbobshepherd
Carmi,
If you are fond of using the Set Column dialog box (selected by menu or Ctrl-Q), but you don't want to execute a moving average, you can still go that route to re-sample your data. Follow Matthew's instructions for performing a moving average, but choose the ave(vd,n) function for F(x)instead. For vd, substitute the column of your original data, and for n enter 5. Then click on "Apply".
DrBob
|
|
|
| |
Topic |
|
|
|
Averaging Data