+ Reply to Thread
Results 1 to 6 of 6

How to create a bell curve / normal distribution graph

  1. #1
    Registered User
    Join Date
    10-12-2010
    Location
    MI
    MS-Off Ver
    Excel 2003
    Posts
    20

    How to create a bell curve / normal distribution graph

    Hello Everyone,

    I am having hard time to create the bell curve. I have sorted the data (please see the attached file) according to the ditribution (only the green marked data) and I believe I will have to use different formulas to create the column graph and the curve.

    I would appreciate it a lot if someone could take a look at this an advise, how to do it. I have already spend couple of hours researching how to do this but it seems to be quiet complex. Is there an easy way to create that type of chart?

    Thanks,
    anstasija
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: How to create a bell curve / normal distribution graph

    Hi anstasija,

    It is a lot easier using the newer versions of Excel. Read.
    http://www.exceluser.com/explore/statsnormal.htm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    10-12-2010
    Location
    MI
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create a bell curve / normal distribution graph

    Quote Originally Posted by MarvinP View Post
    Hi anstasija,

    It is a lot easier using the newer versions of Excel. Read.
    http://www.exceluser.com/explore/statsnormal.htm
    Thank you very much.

    I am trying to working myself through this right now. I wonder, which Excel version has been used in the example... I am having hard time to understand "Insert, Name, Create". I am using 2007 version.

    Man, this bell curve is really taking me hours to create even I am not a begiiner though....

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to create a bell curve / normal distribution graph

    Hello,

    if you are using Excel 2007, please update your profile to reflect that.

    You can select the data in columns B and L and create a line chart, or you can add a column, numbering your rows from 1 to 11 and create an XY chart with a smoothed line.

    See attached for both examples.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-12-2010
    Location
    MI
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create a bell curve / normal distribution graph

    Quote Originally Posted by teylyn View Post
    Hello,

    if you are using Excel 2007, please update your profile to reflect that.

    You can select the data in columns B and L and create a line chart, or you can add a column, numbering your rows from 1 to 11 and create an XY chart with a smoothed line.

    See attached for both examples.

    Oh man! Thank you so much! That looks so much better than what I had in my column graph. (I have done a column graph with a trendline). Now I just have to find out, how to combine the xy schatter and the column graph in one graph...

    One day I will learn the right way to do the bell curve. This thing is giving me nightmares.

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to create a bell curve / normal distribution graph

    Please remember to update your profile with your Excel version.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1