Normal Distribution Curve in Excel

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Normal Distribution Curve in Excel

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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