Graphing Standard Deviation

[Guest]

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!

 

[Jon Peltier]

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

- Jon

 

[Guest]

hi Jon,

The chart would look like a bell curve.

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
_______