+ Reply to Thread
Results 1 to 7 of 7

Dip in Bell Curve

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    Dip in Bell Curve

    Hi
    I have an excel sheet where I am trying to create Bell Curve, but I see there is a dip in curve at top.
    Can you please check why there is dip in bell curve and how I can fix it.
    please help.
    Regards
    Attached Files Attached Files
    Last edited by NonStopLeo; 12-06-2020 at 11:30 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Dip in Bell Curve

    It's flat because you have chosen 4 consecutive values that are equal to each other. If you know the mean and standard deviation for which you want to generate a normal distribution, it's easy. Rather then me explaining it, take a look, here (for example):

    https://trumpexcel.com/bell-curve/
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 11-28-2020 at 04:44 AM.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Dip in Bell Curve

    Please put number 5-10 for change Standard Deviation
    then H5

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    Re: Dip in Bell Curve

    Quote Originally Posted by Bo_Ry View Post
    Please put number 5-10 for change Standard Deviation
    then H5

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Thanks Bo_Ry, appreciate your help.

  5. #5
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    Re: Dip in Bell Curve

    Quote Originally Posted by Bo_Ry View Post
    Please put number 5-10 for change Standard Deviation
    then H5

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dear Bo_Ry
    Can you please help me to fix Front Loaded curve. it is not showing smooth.
    Thanks in advance.
    Attached Files Attached Files

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Dip in Bell Curve

    Please try

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The curve is from NORM.DIST function, No need to add data in the curve type sheet
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    Re: Dip in Bell Curve

    Quote Originally Posted by Bo_Ry View Post
    Please try

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The curve is from NORM.DIST function, No need to add data in the curve type sheet
    Once again Bundle of Thanks Sir.

+ 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. Help with Bell Curve
    By itshere in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2015, 01:34 PM
  2. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  3. How to make a bell curve/statistical curve????
    By pittstonacl in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 10:49 AM
  4. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  5. Bell Curve
    By Gre in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-09-2011, 04:24 AM
  6. Bell curve
    By alykins in forum Excel General
    Replies: 10
    Last Post: 05-27-2011, 12:56 PM
  7. Bell Curve
    By Todd Nelson in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 01:05 PM

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