View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default normal distribution and/or standard deviation

colettey29 -

If you want a chart of the normal density function (bell-shaped curve) with
vertical lines to indicate the one-standard-deviation range, one way is to
enter x values in a column on the left with NORMDIST values in a column on
the right. Select the data in both columns and create an XY (Scatter) chart.
Then enter data (XY pairs) for the two lines, each of which can be defined
using just two XY data points, and add each new data series to the chart
using the Source Data tab. If you need more detailed instructions, specify
which version of Excel you are using.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"colettey29" wrote in message
...
Is there an easy way that I can create a chart for a normal distribution
and/or input data so that a chart includes one standard deviation above
and
below a specific number? (I have the exact numbers of the mean and what
one
standard deviation is... just trying to figure out how to set this up in
excel to easily create a chart.) thanks in advance!!