![]() |
Resampling Log Data
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? |
Resampling Log Data
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. -- David Biddulph "Little Mul" wrote in message ... 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? |
All times are GMT +1. The time now is 09:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com