ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Resampling Log Data (https://www.excelbanter.com/excel-worksheet-functions/179124-resampling-log-data.html)

Little Mul

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?

David Biddulph[_2_]

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