+ Reply to Thread
Results 1 to 3 of 3

how create gaussian curve / bell curve for list of random numbers

  1. #1
    Registered User
    Join Date
    01-21-2015
    Location
    hyderabad
    MS-Off Ver
    2007
    Posts
    73

    how create gaussian curve / bell curve for list of random numbers

    Hi,

    In the attachment , there are random numbers in E column (Percentile column). Based on this column I want to create Gaussain Curve/Bell Curve. With out statistical method, pls give me the solution in simple way (Any formula?).

    thank you in advance
    Attached Files Attached Files
    Last edited by ajaypal.sp; 02-12-2015 at 10:31 AM. Reason: Attachment and explanation

  2. #2
    Registered User
    Join Date
    02-15-2015
    Location
    Joburg, South Africa
    MS-Off Ver
    2007
    Posts
    8

    Re: how create gaussian curve / bell curve for list of random numbers

    Hi Ajay,

    I have created simple formula as you requested.
    1) Created different buckets as elicited below based on percentile
    2) Rounded off the decimals for percentile
    3) Created a pivot to see how many people fits in each buckets
    4) created a chart (you can choose your own chart but base will remain unchanged if you are comfortable with the solution)
    Assumptions:
    Bell curve stands as:
    1-20
    21-80
    81- 100 (this you perhaps can choose to adjust based on your HR guidelines)

    Thanks

    Vishnu
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-21-2015
    Location
    hyderabad
    MS-Off Ver
    2007
    Posts
    73

    Re: how create gaussian curve / bell curve for list of random numbers

    HI tovishnu,

    Thanks for your reply. But I want bell curve in different way (not in frequency based). In my attachment there are 100 numbers in E (percentile) column. those number should be as data labels in Bell Curve graph. If you have any solution (not statistical method) Please share to me.

    Thanks in Advance.

+ 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. How to make a bell curve/statistical curve????
    By pittstonacl in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 10:49 AM
  2. [SOLVED] Create bell curve
    By Starkey in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-22-2013, 08:13 PM
  3. Random distribution of numbers to create Bell curve
    By squiggler47 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-13-2013, 09:39 AM
  4. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  5. How to create Bell Curve
    By Madan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-30-2009, 09:09 AM

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