+ Reply to Thread
Results 1 to 4 of 4

Histogram Trending with a Normal Curve

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    33

    Histogram Trending with a Normal Curve

    Hello

    Please show me how to create a histogram that is fitted with a normal distribution curve ("bell curve") in Excel. Probability density function please!

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,344

    Re: Histogram Trending with a Normal Curve

    As requested - please see attached.
    Attached Files Attached Files
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    07-02-2014
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    33

    Re: Histogram Trending with a Normal Curve

    Thank you for your response, sweep. Maybe I'm doing something wrong on your example, but I cannot get the probability to add up to 1 (100%). Do you have any suggestions?

    See attached. I'm on Excel 2010.
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,787

    Re: Histogram Trending with a Normal Curve

    You can modify formula in F2 (and copy down):
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    of course for such data as yours it still will be well below 1 because you draw only middle part of the frequency curve and probabilyty of large tails is missing, but see sample data in attached file - almost 1.
    Attached Files Attached Files
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Histogram Trending with a Normal Curve
    By IcyBricks in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-31-2015, 07:54 PM
  2. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  3. Replies: 4
    Last Post: 01-27-2007, 01:37 PM
  4. How to add a normal distribution to a histogram
    By AdamCPTD in forum Excel General
    Replies: 0
    Last Post: 07-14-2006, 09:40 AM

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