Problem 652. Put two time series onto the same time basis

Created by Ned Gulley

Solve Later

{"relationships":[{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/document","targetMode":"","relationshipId":"rId1","target":"/matlab/document.xml"},{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/output","targetMode":"","relationshipId":"rId2","target":"/matlab/output.xml"}],"parts":[{"partUri":"/matlab/document.xml","relationship":[],"contentType":"application/vnd.mathworks.matlab.code.document+xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<w:document xmlns:w=\"http://schemas.openxmlformats.org/wordprocessingml/2006/main\"><w:body><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Use interpolation to align two time series onto the same time vector.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>This is a problem that comes up in</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/trendy/plots\"><w:r><w:t>Trendy</w:t></w:r></w:hyperlink><w:r><w:t> whenever you want to do mathematical operations on two trends (see for example the</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/trendy/plots/763\"><w:r><w:t>Ramen-to-Sushi Index</w:t></w:r></w:hyperlink><w:r><w:t>).</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Given two time series defined by the vector pairs (t1,d1) and (t2,d2), come up with a single new time vector tn such that (tn,d1n) and (tn,d2n) form consistent vector pairs.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Specifically, the new time vector should extend only to portions covered by both series (i.e. no extrapolation). Within this common interval, tn should contain all the time points from both time vectors. With this new time basis, use linear interpolation to generate two new data series.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Example 1:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[ t1 = [1 3 5]\n d1 = [2 4 2]\n t2 = [2 4]\n d2 = [1 5]\n\n tn = [2 3 4]\n d1n = [3 4 3]\n d2n = [1 3 5]]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Example 2:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[ t1 = [1 2 3 4 5]\n d1 = [2 3 5 6 3]\n t2 = [2 3.5 4 4.5 5 6]\n d2 = [3 9 8 2 0 1]\n\n tn = [2 3 3.5 4 4.5 5]\n d1n = [3 5 5.5 6 4.5 3]\n d2n = [3 7 9 8 2 0]]]></w:t></w:r></w:p></w:body></w:document>"},{"partUri":"/matlab/output.xml","contentType":"text/xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?><embeddedOutputs><metaData><evaluationState>manual</evaluationState><layoutState>code</layoutState><outputStatus>ready</outputStatus></metaData><outputArray type=\"array\"/><regionArray type=\"array\"/></embeddedOutputs>"}]}

Use interpolation to align two time series onto the same time vector.This is a problem that comes up in <a href="http://www.mathworks.com/matlabcentral/trendy/plots">Trendy</a> whenever you want to do mathematical operations on two trends (see for example the <a href="http://www.mathworks.com/matlabcentral/trendy/plots/763">Ramen-to-Sushi Index</a>).Given two time series defined by the vector pairs (t1,d1) and (t2,d2), come up with a single new time vector tn such that (tn,d1n) and (tn,d2n) form consistent vector pairs.Specifically, the new time vector should extend only to portions covered by both series (i.e. no extrapolation). Within this common interval, tn should contain all the time points from both time vectors. With this new time basis, use linear interpolation to generate two new data series.Example 1:<pre> t1 = [1 3 5]
 d1 = [2 4 2]
 t2 = [2 4]
 d2 = [1 5]</pre><pre> tn = [2 3 4]
 d1n = [3 4 3]
 d2n = [1 3 5]</pre>Example 2:<pre> t1 = [1 2 3 4 5]
 d1 = [2 3 5 6 3]
 t2 = [2 3.5 4 4.5 5 6]
 d2 = [3 9 8 2 0 1]</pre><pre> tn = [2 3 3.5 4 4.5 5]
 d1n = [3 5 5.5 6 4.5 3]
 d2n = [3 7 9 8 2 0]</pre>

Use interpolation to align two time series onto the same time vector.

This is a problem that comes up in <http://www.mathworks.com/matlabcentral/trendy/plots Trendy> whenever you want to do mathematical operations on two trends (see for example the <http://www.mathworks.com/matlabcentral/trendy/plots/763 Ramen-to-Sushi Index>).

Given two time series defined by the vector pairs (t1,d1) and (t2,d2), come up with a single new time vector tn such that (tn,d1n) and (tn,d2n) form consistent vector pairs.

Specifically, the new time vector should extend only to portions covered by both series (i.e. no extrapolation). Within this common interval, tn should contain all the time points from both time vectors. With this new time basis, use linear interpolation to generate two new data series.

Example 1:

t1 = [1 3 5]
 d1 = [2 4 2]
 t2 = [2 4]
 d2 = [1 5]

tn =  [2 3 4]
 d1n = [3 4 3]
 d2n = [1 3 5]

Example 2:

t1 = [1 2 3 4 5]
 d1 = [2 3 5 6 3]
 t2 = [2 3.5 4 4.5 5 6]
 d2 = [3 9   8 2   0 1]
 
 tn  = [2 3 3.5 4 4.5 5]
 d1n = [3 5 5.5 6 4.5 3]
 d2n = [3 7 9   8 2   0]

Solve

Solution Stats

773 Solutions
312 Solvers

Last Solution submitted on Sep 19, 2023

Last 200 Solutions

Problem Comments

3 Comments

3 Comments

@bmtran (Bryant Tran) on 3 May 2012

neat! i'd never used time series before

Jeffrey Daniels on 20 Nov 2013

I use timeseries all the time but don't usually use objects. Obviously using object oriented commands is much faster than more manual methods.

Aamod Garg on 26 Jul 2018

https://www.mathworks.com/matlabcentral/cody/problems/44699-prime-product

I created this problem. I think it should be in Indexing I.

Solution Comments

Show comments

Problem Recent Solvers312

Problem Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Problem 652. Put two time series onto the same time basis

Solution Stats

Last 200 Solutions

Problem Comments

Solution Comments

Problem Recent Solvers312

Suggested Problems

More from this Author50

Problem Tags

Community Treasure Hunt

Problem 652. Put two time series onto the same time basis

Solution Stats

Last 200 Solutions

Problem Comments

Solution Comments

Problem Recent Solvers312

Suggested Problems

More from this Author50

Problem Tags

Community Treasure Hunt

Players