STANDARD DEVIATION AND GRAPH

[patiencescientist]

How do I graph a plot with 3 standard deviations

 

[Bernard Liengme]

Could you please give a bit more detail
best wishes

 

[patiencescientist]

Thanks for answering so quickly I have data where I need to firgure out the
standard deviation, then to plot the data with +3 standard deviations and
-3 standard deviation

 

[Bernard Liengme]

To find 3*stdev use =3*STDEV(A1:20) ; adjust the range as needed

Look here for how to add horizontal lines to chart:
http://peltiertech.com/Excel/Charts/HorizLineOnColChart.html

 

[patiencescientist]

Thanks for your help. Have a good day!!!

To find 3*stdev use =3*STDEV(A1:20) ; adjust the range as needed

Look here for how to add horizontal lines to chart:
http://peltiertech.com/Excel/Charts/HorizLineOnColChart.html
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email