Standard Deviation


Posted by Christine on April 24, 2001 12:23 PM

I have created a line graph in excel. I am also trying to incorporate a standard deviation line in excel. I have not been able to figure it out!



Posted by Malc on April 26, 2001 12:53 AM

Standard deviation is a single result from a population. I assume you want to plot the single line across the graph which already has the population plotted.
In a cell at the end of the population enter the Standard deviation formula then link it or paste imediatly under the population cells than reselect your graph series and change the chart type to multi axes (line on two axis) in the special chart types and voila.
Binomial distributuion with quartiles? Don't know how.