ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   STANDARD DEVIATION AND GRAPH (https://www.excelbanter.com/excel-discussion-misc-queries/195637-standard-deviation-graph.html)

patiencescientist

STANDARD DEVIATION AND GRAPH
 
How do I graph a plot with 3 standard deviations

Bernard Liengme

STANDARD DEVIATION AND GRAPH
 
Could you please give a bit more detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
How do I graph a plot with 3 standard deviations




patiencescientist

STANDARD DEVIATION AND GRAPH
 
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

"patiencescientist" wrote:

How do I graph a plot with 3 standard deviations


Bernard Liengme

STANDARD DEVIATION AND GRAPH
 
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/...nColChart.html
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
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

"patiencescientist" wrote:

How do I graph a plot with 3 standard deviations




patiencescientist

STANDARD DEVIATION AND GRAPH
 
Thanks for your help. Have a good day!!!

"Bernard Liengme" wrote:

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/...nColChart.html
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
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

"patiencescientist" wrote:

How do I graph a plot with 3 standard deviations






All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com