Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MULTIPLE DATA - How to insert new data into existing data.... Rodorodo Excel Discussion (Misc queries) 0 December 15th 06 11:50 PM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"