ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   multiple standard deviation (https://www.excelbanter.com/charts-charting-excel/195973-multiple-standard-deviation.html)

patiencescientist

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

Bernard Liengme

multiple standard deviation
 
Did you try my earlier suggestion?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
how do I put multiple standard deviation on a control chart?




patiencescientist

multiple standard deviation
 
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?

"Bernard Liengme" wrote:

Did you try my earlier suggestion?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
how do I put multiple standard deviation on a control chart?





patiencescientist

multiple standard deviation
 
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.

"Bernard Liengme" wrote:

Did you try my earlier suggestion?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
how do I put multiple standard deviation on a control chart?





Jon Peltier

multiple standard deviation
 
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
_______


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

"Bernard Liengme" wrote:

Did you try my earlier suggestion?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote
in
message ...
how do I put multiple standard deviation on a control chart?







patiencescientist

multiple standard deviation
 
thanks I will look at the link

"Jon Peltier" wrote:

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
_______


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

"Bernard Liengme" wrote:

Did you try my earlier suggestion?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote
in
message ...
how do I put multiple standard deviation on a control chart?








All times are GMT +1. The time now is 05:46 PM.

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