how to draw Gaussian distribution graph

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?
 
D

David Biddulph

NORMDIST will give you a Gaussian distribution, which you can then add to
your chart.
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I add a Gaussian curve to a histogram on Excel? 5
How to draw a gaussian curve with Excel? 3
How do I create a Cumulative Frequency Histogram on Excel? 1
How can I draw a circle on a graph using point data and the axis? 1
Histogram, And "Normal" Curve For ? 1
Graph line graphs where X & Y values meet 1
Graph Line Width ? 1
How do I make a graph for a normal distribution in Excel? 2

Top