+ Reply to Thread
Results 1 to 5 of 5

Thread: [Excel] Help needed with converting data to bell curve

  1. #1
    Points: 1,458, Level: 21
    Level completed: 58%, Points required for next Level: 42

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    [Excel] Help needed with converting data to bell curve




    Hi, I am looking to draw the following graph in my attachment (please see attached PDF).

    I tried converting them into histogram and then into a bell curve, but couldn't get it to work, because I don't understand terms such as "bin range". Can someone enlighten me on whether I need to convert the data into a histogram first then into a separate bell curve? If so, could someone show me how I should do it? Many thanks

    PS - I understand that the graph I am looking for should be a normal distribution (I'm guessing it's not a standard normal distribution graph as the graph I am looking for is not one with 0 in the middle). Please kindly advise me... Thank you very much!
    Attached Images

  2. #2
    TS Contributor
    Points: 5,839, Level: 49
    Level completed: 45%, Points required for next Level: 111

    Location
    Nottingham
    Posts
    682
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: [Excel] Help needed with converting data to bell curve

    have you tried the graph type "Area"?

  3. #3
    Points: 1,458, Level: 21
    Level completed: 58%, Points required for next Level: 42

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: [Excel] Help needed with converting data to bell curve

    Quote Originally Posted by Masteras View Post
    have you tried the graph type "Area"?
    Hi Masteras, thanks, that's a very useful graph type that I've never used before
    However for the current data on hand, with data ranging from 2 - 100,000, the graph barely reflects the lower figures, and hence i was wondering if i had to translate the data into histograms...

    If there is no other way out than to do a histogram, how do i do it, and are there any rules for it?

    Thanks!

  4. #4
    TS Contributor
    Points: 5,839, Level: 49
    Level completed: 45%, Points required for next Level: 111

    Location
    Nottingham
    Posts
    682
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: [Excel] Help needed with converting data to bell curve

    a ok, i see. yes, you can create bins yourself. there is a rule of thumb of how mabny bins you create based on your sample. But keep in mind it is better to have the same width. Call them classes idf not bins if you like it more. but then youhave to count the number of data within each bin seperately. Then do a bar chart with the bars stacked one ritght next to the other. but i have not tried this myself, plus it is too tiring, time consuming. how about use spss?

  5. #5
    TS Contributor
    Points: 23,042, Level: 93
    Level completed: 70%, Points required for next Level: 308
    Awards:
    Downloads
    gianmarco's Avatar
    Location
    Italy
    Posts
    1,088
    Thanks
    176
    Thanked 219 Times in 160 Posts

    Re: [Excel] Help needed with converting data to bell curve


    Hi!

    If you are looking for a way to get a frequency histogram in Excel, may be this video can be of some use

    http://www.youtube.com/watch?v=x8ePdM9LquM

    Regards
    Gm

+ Reply to Thread

           




Similar Threads

  1. Creating a Bell Curve with 3 performance parameters
    By AB101010 in forum Statistics
    Replies: 0
    Last Post: 05-17-2010, 09:28 AM
  2. Replies: 3
    Last Post: 01-17-2010, 06:58 PM
  3. bell curve question
    By cpp_coder in forum Statistical Research
    Replies: 10
    Last Post: 05-30-2008, 11:15 AM
  4. Replies: 5
    Last Post: 05-22-2008, 10:07 PM
  5. Marks on a bell curve
    By UofA in forum General Discussion
    Replies: 1
    Last Post: 11-12-2005, 12:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats