Resampling Log Data

  • Thread starter Thread starter Little Mul
  • Start date Start date
L

Little Mul

I have a data stream with a variable parameter (Y) measured at irregular
intervals (X).
I am using Excel 2003. How do I resample my data to produce parameter values
at regular X intervals?
 
If your data is at irregular intervals, you can't resample the data to get
it at regular intervals, unless your regular intervals are a subset of your
irregular intervals.
For example, if your existing samples are at 1, 3, 5,10, 16, 20, 24, 30, you
could resample at 10,20,30.
If you don't have data from which you can choose a suitable subset, the best
you're likely to be able to do would be to interpolate, and you may wish to
use the FORECAST function to do that.
 
Back
Top