+ Reply to Thread
Results 1 to 3 of 3

Created bell curve, do not understand the curves i created

  1. #1
    Registered User
    Join Date
    03-20-2008
    Posts
    11

    Created bell curve, do not understand the curves i created

    Hello everyone,

    I was asked to create a bell curve in excel and i didn't know how to do it, so i googled it out and followed the instructions on MS's website.

    http://support.microsoft.com/kb/q213930/

    Here is the output:

    http://img99.imageshack.us/img99/217/bellcurveyz6.jpg

    You can't see it all, but Column A is the original data (it's 75 data points) and column D is random numbers generated from this data (it's 2000 data points).

    The blue curve seems to be the normal distribution. The other 2 curves, i have no idea what that is. Does anyone know which curve represents the actual data? Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    Looks like Pink line called Histogram Bin is based on the range G3:G10 as the Y values. X values a sequential 1,2,3 etc. Displayed on the Secondary axis. Point 8 drops to zero as the value "More" is being treated as zero.

    Yellow line Histogram Frequency also on the secondary axis is based on H3:H10
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-20-2008
    Posts
    11
    Quote Originally Posted by Andy Pope
    Looks like Pink line called Histogram Bin is based on the range G3:G10 as the Y values. X values a sequential 1,2,3 etc. Displayed on the Secondary axis. Point 8 drops to zero as the value "More" is being treated as zero.

    Yellow line Histogram Frequency also on the secondary axis is based on H3:H10
    Thanks, i think i figured it out

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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