+ Reply to Thread
Results 1 to 3 of 3

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.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Histogram Trending with a Normal Curve

    Double Post
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Histogram Trending with a Normal Curve

    With such a generic question, I'm not sure exactly what you need help with. In the spirit of "divide and conquer", I would suggest that you break up the process into several steps:

    1) Count frequencies using COUNTIF() or FREQUENCY() function, if needed. (list of available Excel functions which link to help files: https://support.office.com/en-US/art...rs=en-US&ad=US )
    2) Compute mean (AVERAGE()) and standard deviation (STDEV()).
    3) Use step 2 to compute normal distribution (use NORMDIST() or NORM.DIST() function) at same "bins" as used in 1
    4) Generate column + line combination chart using the result of 1 and 3: https://support.office.com/en-us/art...0-EC33F588243F

    What steps do you need help with?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  2. Replies: 4
    Last Post: 01-27-2007, 01:37 PM
  3. 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
  4. Fit bell curve to histogram
    By cwinters in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-13-2005, 10:05 PM

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