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
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.
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.)
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.
Reducing large amount of data by periodicaveraging
Posted - 11/05/2011 : 04:44:56 AM
