The Origin Forum - Binned and Averaged Data

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Binned and Averaged Data

New Topic

Reply to Topic

Printer Friendly

Author

Topic

consistory

9 Posts

Posted - 05/20/2009 : 8:14:31 PM

Origin Ver. and Service Release (Select Help-->About Origin): Origin 8 SR5 v8.0987
Operating System: Win XP SP3

Hi,

I would like to bin a column of Y data based on the column X intervals. Would like to have an average value of Y for 1.0 unit intervals of X. Example data:

S Count
-0.91 4
-0.70 2
-0.53 5
-0.22 6
0.05 8
0.58 9
0.96 9
1.33 12
1.68 11
1.82 13
2.23 15
2.67 18
2.96 20
3.24 22
3.56 25
3.78 28
3.93 27
4.21 29
4.48 35
4.67 38
4.86 45
5.12 49

And the result should look similar to:

S Count
-1.0 3
0.0 6
1.0 10
2.0 12
3.0 28
4.0 31
5.0 44

Alternatively, if there is a way to smooth XY scatter plot data in a similar fashion that would work well.

Is there a easy way to do this in Origin?

Thanks.

easwar

USA
1964 Posts

Posted - 05/21/2009 : 10:57:30 AM

Hi,

We will be adding such functions for data reduction in our next version.

Smooth tool generates output at same x as the original data, so the output will not be reduced in size as you want here.

You can try Mathematics->Interpolate tool where you can specify begin and end x values and number of desired values and there is option to interpolate using linear, spline or b-spline, but this will of course not average your data, just interpolate to find new y values.

I have e-mailed you as well about this issue.

Easwar
OriginLab

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000