| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
STANDARD DEVIATION AND GRAPH
How do I graph a plot with 3 standard deviations
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a bell graph for standard deviation? | Charts and Charting in Excel | |||
| standard deviation | Excel Worksheet Functions | |||
| Standard Deviation | Excel Worksheet Functions | |||
| Standard Deviation | Excel Worksheet Functions | |||
| standard deviation | Excel Discussion (Misc queries) | |||
Linear Mode
