Resampling Log Data

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?
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top