Results 1 to 6 of 6

Normal Distribution Curve in Excel

This is a discussion on Normal Distribution Curve in Excel within the Excel Questions forums, part of the Question Forums category; Does anybody know how from a set of data to be able to graph the typical "bell curve" to show ...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1

    Default

    Does anybody know how from a set of data to be able to graph the typical "bell curve" to show the distribution of the data, i.e. mean, std deviation, etc. ?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    California
    Posts
    105

    Default

    It's in the format data series X error bars and Y error bars, you can play with it from there to show what you want the STd dev to be and show.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526

    Default

    Hi.

    For a N(4,9) put the range in column A from -10 to +10 perhaps in incrememntal steps of 0.1 then copy =normdist(A2,4,3,false) function down colum B next to your range and then use the chart wizard to draw the graph.

    This is one way, but I'm sure there is a more elegant solution, perhaps with VBA. Are you looking for a VBA solution?

    RET79

    [ This Message was edited by: RET79 on 2002-05-14 10:43 ]

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040

    Default

    Hi,

    Suppose your raw data is in A1:A100

    in B1 type the following

    =NORMDIST(A1,AVERAGE($A$1:$A$100),STDEVP($A$1:$A$100),FALSE)

    copy down your list and graph the B1:B100 series.

    This should get you started.

    Bye,
    Jay

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526

    Default

    Ignore my contribution, use Jay's solution, I didn't read your question carefully enough, doh!

    RET79

  6. #6
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040

    Default

    On 2002-05-14 10:49, RET79 wrote:
    Ignore my contribution, use Jay's solution, I didn't read your question carefully enough, doh!

    RET79
    Don't take it back! I did the exact same thing you did when I verified that the curve would look right.

    The OP will come back to us with whatever else is needed, so all the suggestions were fine.

    Bye,
    Jay

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com