how does one normalize two or more time series, so as to make them start with
ie 100, or for that mattern any other value?
I would like to see two time series starting from the same point, ie from
the first data point of the first series. On other words, i would like to
normalize one series with another.
How can it be done in excel?
thanks a lot
"Jon Peltier" wrote:
Normalize the data that feeds the chart. To normalize your data to MIN = -1
and MAX = 1, use a formula like this:
=2*(B2-MIN(B$2:B$1000))/(MAX(B$2:B$1000)-MIN(B$2:B$1000))-1
where your data is in B2:B1000, and this formula is to normalize the first
point, in B2.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"WA" wrote in message
...
I have the graph of the historical prices of a stock. I was wondering
whether
it can be normalized. To clarify, I would like to see a graph with (-1) to
(1) on the y axis and time on the x-axis. The trend line of the stock
price
data would be considered zero and the moves above or below that line would
be
depicted between -1 and 1.
If anyone knows whether there is a function/graph type in excel to perform
this task, your assistance would be greatly appreciated.
Thanks.