Stock chart with std dev plot

[novice198]

Hi,
I would like to plot a chart in excel as under:-
Stock price with Date ( I have this data and plotted the data)
Plot regression trend line ( have done this also)
Plot a line one std dev above and another std dev below the regression line ( dont know how to do this)
Plot a line 2 std dev above and another std dev below the regression line ( dont know how to do this)
Can someone pls help me with this.
Thanks in advance
Novice198

 

[thisoldman]

I used monthly closing price so I had less than 350 data points. You used somewhere around 7000 data points. We used similar but different data. Look closely at the line for the prices and you will probably catch many differences. Both your trendline and mine are valid. The different equations just show we are not using the same data.

 

[novice198]

Thanks for clarification, which is much appreciated.

Cheers
Novice

 

[arthurbr]

Cross post Statistical chart