P
patiencescientist
How do I graph a plot with 3 standard deviations
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
Could you please give a bit more detail
best wishes
best wishes
P
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
standard deviation, then to plot the data with +3 standard deviations and
-3 standard deviation
B
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
Look here for how to add horizontal lines to chart:
http://peltiertech.com/Excel/Charts/HorizLineOnColChart.html
P
patiencescientist
Thanks for your help. Have a good day!!!
Bernard Liengme said: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