Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Bell curve graph / Standard deviation graph

Latest post Tue, Apr 1 2008 2:24 AM by mayest. 4 replies.
  • Sat, Mar 29 2008 9:35 AM

    Bell curve graph / Standard deviation graph

    I need some help. I have 500 data points and I would like to create a bell shaped graph. Can someone please show me a step by step guide how to do this.

    my email address is vanse@hotmail.co.uk

    I can send you the data points if required. I've tried using the guide on google, but the instruction are not clear in how to create a mean and standard devaiation and you plot the resultng values.

    Thanks

    Filed under: , ,
    • Post Points: 21
  • Sat, Mar 29 2008 10:42 AM In reply to

    Betreft: Bell curve graph / Standard deviation graph

    If you want to have a frequency distribution, try installing the analisys toolpak addin and use its data analysis feature, Histogram option. That'll show you the distribution of your data in bins.

    Regards, Jan Karel Pieterse www.jkp-ads.com
    • Post Points: 21
  • Mon, Mar 31 2008 8:26 AM In reply to

    • fossildon
    • Top 150 Contributor
    • Joined on Mon, Mar 31 2008
    • Posts 2
    • Points 58

    Re: Betreft: Bell curve graph / Standard deviation graph

    Jan Karel Pieterse:

    If you want to have a frequency distribution, try installing the analisys toolpak addin and use its data analysis feature, Histogram option. That'll show you the distribution of your data in bins.

    And if one was wanting to compare that distribution curve to a normal distribution? That is to create a normal curve in the same chart relative to the same dataset?

    • Post Points: 37
  • Mon, Mar 31 2008 9:58 AM In reply to

    Betreft: Re: Betreft: Bell curve graph / Standard deviation graph

    The easiest would be to create a fixed dataset that follows the normal distribution using the same bins you use for your data histogram. The analysis toolpak has some functions for this IIRC.

    Regards, Jan Karel Pieterse www.jkp-ads.com
    • Post Points: 5
  • Tue, Apr 1 2008 2:24 AM In reply to

    • mayest
    • Top 50 Contributor
    • Joined on Wed, Mar 19 2008
    • Denver, CO USA
    • Posts 14
    • Points 166

    Re: Betreft: Bell curve graph / Standard deviation graph

     Tushar Mehta has a nice add-in and tutorial for charting a normal distribution.

    • Post Points: 5
Page 1 of 1 (5 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.