| T O P I C R E V I E W |
| JThieser |
Posted - 02/22/2011 : 06:09:00 AM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
Dear all,
I have a question. I have a data set with two colunms.
One with time. Time steps about 4 sec. for example from starting 12.01 to the 30.01.
and a second column which gives a certain time a value Y.
But the time format is not äquidistant so there are some gaps between.
No i would like to average the values.
So for example averaging time of 5 min.
So the programm should start at a certain time and scan through the data.
If there are more than for example 50 datapoints in a 5 min range the programm should give the mean value plus Standard Diviation + number of data points of this intervall...
Maybe some ideas??
would be great....
Cheers Jim |
| 2 L A T E S T R E P L I E S (Newest First) |
| JThieser |
Posted - 03/01/2011 : 11:28:12 AM
Thanks for the answer.
This function is really good and for the beginning i will use it.
But for the future i think i will try to write a script.
Is anyone here who can give me maybe a idea how to start because i'm not so familiar with writing scripts.....
Thanks... |
| greg |
Posted - 02/25/2011 : 4:40:20 PM
If you can accept just the mean value AND you have 8.5SR1 Pro, then you can use Analysis : Data Manipulation : Reduce to Evenly Spaced X.
If your X column is formatted as Time then you should be able to use "Sampling Interval" of "5min"
and
"Sampling Method" of "Y Mean"
(You can also use reduce by group, but you will have to use X increment of 0.0034722222222222 which is 5 minutes expressed as the fraction of a day.)
If you really need Standard + number of points you need to write a script. |
