Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |