Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default multiple standard deviation

how do I put multiple standard deviation on a control chart?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default 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?




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default 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?




  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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?








  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default 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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Standard deviation Svi Excel Discussion (Misc queries) 5 October 15th 07 10:13 AM
standard deviation Ina Excel Discussion (Misc queries) 2 August 23rd 07 03:06 PM
Standard Deviation Stan Banner Excel Worksheet Functions 1 March 11th 06 09:11 PM
standard deviation Chris Excel Discussion (Misc queries) 1 October 13th 05 04:52 AM
how do you find the SD(standard deviation ) for the multiple reg Basem Salman Excel Worksheet Functions 2 July 7th 05 02:41 PM


All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"