how to draw Gaussian distribution graph

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.
--
David Biddulph

"Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
news:54693913-5988-4FB1-8F4A-E88271761BF2@microsoft.com...
> 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?
>

Tushar shows how:

http://tushar-mehta.com/excel/chart...ution/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:46c18aa8_1@glkas0286.greenlnk.net...
> NORMDIST will give you a Gaussian distribution, which you can then add to
> your chart.
> --
> David Biddulph
>
> "Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
> news:54693913-5988-4FB1-8F4A-E88271761BF2@microsoft.com...
>> 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?
>>
>
>

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/Histog...NormalCurve.xls for an example
that uses proper scaling.

- Mike
http://www.MikeMiddleton.com



"Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
news:54693913-5988-4FB1-8F4A-E88271761BF2@microsoft.com...
> 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?
>