I would like to graph the probability of a stock or index closing +/- one
standard deviation from its closing price. I have the formulas however, I
would also like to graph the results.

Does anyone know how to do this or know of an add-in that will do this?


THanKS!

How would the chart look? How do you think the standard deviation should be
displayed?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Brian L." wrote in message
...
I would like to graph the probability of a stock or index closing +/- one
standard deviation from its closing price. I have the formulas however, I
would also like to graph the results.

Does anyone know how to do this or know of an add-in that will do this?


THanKS!

hi Jon,

The chart would look like a bell curve.

"Jon Peltier" wrote:

How would the chart look? How do you think the standard deviation should be
displayed?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Brian L." wrote in message
...
I would like to graph the probability of a stock or index closing +/- one
standard deviation from its closing price. I have the formulas however, I
would also like to graph the results.

Does anyone know how to do this or know of an add-in that will do this?


THanKS!