Hi. everyone
I am stuck with plotting several time series on a common graph.
I have two functions:
y_t=0.5y_t-1 e_t
y_t=1.5y_t-1 e_t
there is a single shock (e_0 gt; 0) and ignore e_t.
would ypu help me out?
moohwan
You need X and Y values to generate a plotted curve. In one column, enter
your X values. For your formulas, these might be just consecutive integers.
In the next column, enter formulas that calculate the Y values. Since you
have two series to plot, you need two columns of Y data; in general you
might have two sets of X data, but your formulas look like they'd both use
the same X values.
Select the range of data (one column X and two columns Y), and start the
chart wizard. Choose the XY chart type, I suspect you want one of the
variations that connect the points with lines.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______
quot;Moohwanquot; gt; wrote in message
...
gt; Hi. everyone
gt; I am stuck with plotting several time series on a common graph.
gt; I have two functions:
gt; y_t=0.5y_t-1 e_t
gt; y_t=1.5y_t-1 e_t
gt; there is a single shock (e_0 gt; 0) and ignore e_t.
gt;
gt; would ypu help me out?
gt;
gt; moohwan
- Sep 10 Mon 2007 20:39
plot multiple time series
close
全站熱搜
留言列表
發表留言
留言列表

