how to draw Gaussian distribution graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After drawing a histogram through data analysis, I want to draw a Gaussian
distribution graph (standard or reverse bell-shape graph) relevant to my
frequency data. Is there any built-in function to carry out this drawing?
 
NORMDIST will give you a Gaussian distribution, which you can then add to
your chart.
 
Khoshravan -

Excel has features for creating the histogram and for plotting the curve
using data from the NORMDIST worksheet function. But Excel does not have an
automatic feature for combining the histogram (Column chart type) and normal
curve (XY Scatter chart type). It can be difficult to line up the horizontal
axes (Column category and XY numerical) and to scale the vertical axes.

See the Histogram page at www.treeplan.com for an example that uses the two
chart types.

See http://www.mikemiddleton.com/HistogramWithNormalCurve.xls for an example
that uses proper scaling.

- Mike
http://www.MikeMiddleton.com
 
Back
Top