multiple standard deviation

[patiencescientist]

how do I put multiple standard deviation on a control chart?

 

[Bernard Liengme]

Did you try my earlier suggestion?

 

[patiencescientist]

I guess it is difficult to explain, I am to find the standard deviation
actually (3x) then I have to plot it, I guess I am trying to do every thing
in Excel?

 

[patiencescientist]

I probably asked the question wrong. I am to find standard deviation and plot
it using standard deviation 3x sorry if I am not stating more clearner.

 

[Jon Peltier]

You have to calculate the standard deviation of your data in the worksheet.
Then you can add a pair of lines for mean ± sd to your chart. See this link:

http://peltiertech.com/Excel/Charts/RunChtLines.html

- Jon

 

[patiencescientist]

thanks I will look at the link

You have to calculate the standard deviation of your data in the worksheet.
Then you can add a pair of lines for mean ± sd to your chart. See this link:

http://peltiertech.com/Excel/Charts/RunChtLines.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______