T O P I C R E V I E W |
JoseMGuil |
Posted - 11/05/2011 : 04:44:56 AM Origin Ver. and Service Release (Select Help-->About Origin): 8.0 SR-6 Operating System:Windows 7
I get a large amount of data (tens of thousands) with a data adquisition system even with the lower data adquisition rate. I would like to reduce that large number by substitution of every n data by their averaged (mean) value. Thanks |
4 L A T E S T R E P L I E S (Newest First) |
JoseMGuil |
Posted - 11/17/2011 : 11:50:32 AM Thanks to couturier and Drbobshepherd. The way: Analysis/Mathematics/Inter-Extrapolate worked well when using "Number of points" as non-auto and equal to total number of points divided by the number of points to be averaged.
|
Drbobshepherd |
Posted - 11/07/2011 : 2:19:08 PM Couturier's suggestion is a good one; all you have to do is select the size of your smoothing window (n datapoints), and the size of your final reduced dataset (N datapoints). N should equal [(No.of Samples)/n] +1, to ensure all data is utilized. (You may want to experiment with the +1;I cold be off a little.) |
couturier |
Posted - 11/07/2011 : 12:48:13 PM Maybe the following can help:
1. Analysis/Signal processing/Smooth Choose adjacent averaging and set the desired n points of window
2. Analysis/Mathematics/Inter-Extrapolate Choose desired number of points |
Drbobshepherd |
Posted - 11/07/2011 : 10:29:51 AM Lo siento. Origin 8.1 implemented a new X-function, reduce_ex, that solves your problem; it reduces the dataset by replacing every N values with an average. This function can also be executed using the "Analysis/Data Manipulation/Reduce by evenly spaced X" drop-down menu. Unfortunate for you, I do not think you have this function in version 8.0.
Try using the smooth routine with adjacent-averaging. Then write a program to delete rows using nested loops. Bueno suerte. |