+ Reply to Thread
Results 1 to 11 of 11

Bell curve

  1. 05-26-2011, 04:03 PM #1
    alykins
    alykins is offline
    Registered User
    Join Date
    05-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Bell curve

    Hi, heres the situation
    I am actually programming an asp.net project and need to insert an excel file for the following...
    i am doing a standard bell curve for autism scores. I then need to have an input to overlay a vertical line function that will display at x= entered value (this will move a bar along the bell curve to display to the user where their score falls...
    i have been doing multiple searches for generating a bell curve in excel, but all the "how-to's" I've found have been for pre2010 (the current platform I am running)
    Can anyone help with this? I have no clue where to begin and have used excel a handful of times

    Edit: I have added the supplied bell curve image
    Attached Files Attached Files
    Last edited by alykins; 05-27-2011 at 11:23 AM.
    Reply With QuoteRegister To Reply
  2. 05-26-2011, 04:04 PM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Bell curve

    Do you mean something to have X=MAX(value)?
    Reply With QuoteRegister To Reply
  3. 05-26-2011, 04:08 PM #3
    alykins
    alykins is offline
    Registered User
    Join Date
    05-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Bell curve

    not sure lol, I have edited and attached to my first post- you responded in between time... does that clarify?
    Also should note that my math background is not Stats
    Reply With QuoteRegister To Reply
  4. 05-26-2011, 04:46 PM #4
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Bell curve

    Would be better if you could excel example with your input and desired output...

    From docx is slightly harder to get a clue
    Reply With QuoteRegister To Reply
  5. 05-26-2011, 05:15 PM #5
    alykins
    alykins is offline
    Registered User
    Join Date
    05-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Bell curve

    problem is i dont really know... I have never encountered this before and this is the info that was given to me...
    I'm more than willing to do the research and figure out how to incorporate this into my clients page, but she does not have a mathematical function for the curve and it is based on a "standard bell curve" set by the national psyc board or something... So I dont really have access to the data they pull from either...
    totally stuck...
    my other work around would be to make an image of this and then overlay a line that gets draw, but then that creates a whole new mess of problems such as browser rendering, or varied sizes when viewing...
    ?
    it doesn't seem like it should be that hard.... like i said i have little-no experience with excel, but drawing a curve is drawing a curve isnt it? it doesnt need to have actual data, just a functional curve that i can set a scale on it (say 1-100 where each digit represents a percentile) and then move a line on that curve...
    essentially graph
    Fx="user entered variable" (even though x=# isnt a function) and
    Fx="whatever the formula is for a bell curve"
    the max height is arbitrary for my application, it just needs to be high enough so that the lines approaching the x-axis asymptotically are able to be read.
    is all this making sense?
    Reply With QuoteRegister To Reply
  6. 05-26-2011, 05:56 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bell curve 

    Please Login or Register  to view this content.
    The formula in C5 and down gives the cumulative distribution function:

    =NORMDIST(B5, 100, $C$2, TRUE)

    D5 and down is the probability density function:

    =NORMDIST(B5, 100, $C$2, FALSE)

    The standard deviation value in C2 was selected to make the CDF 2.2% at Score = 70.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  7. 05-26-2011, 09:19 PM #7
    alykins
    alykins is offline
    Registered User
    Join Date
    05-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Bell curve

    I don't understand how to graph this...
    Reply With QuoteRegister To Reply
  8. 05-26-2011, 09:23 PM #8
    alykins
    alykins is offline
    Registered User
    Join Date
    05-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Bell curve

    I'm trying to do (what I think) this will do http://support.microsoft.com/kb/213930
    but I don't know how to "navigate" excel 2010 and every article I've found on doing this is written with very similar instructions... I hate how MS changes every flippin user interface all.the.time.
    anyways.... I can't find any "how to's" written for excel 2010
    Reply With QuoteRegister To Reply
  9. 05-27-2011, 12:43 AM #9
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bell curve

    I don't have Excel 2010, but would be surprised if instructions for earlier versions don't work.

    Plot the PDF versus score as an xy scatter plot.
    Reply With QuoteRegister To Reply
  10. 05-27-2011, 11:22 AM #10
    alykins
    alykins is offline
    Registered User
    Join Date
    05-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Bell curve

    thanx! that worked! I dont doubt that you can do the same things in 2010 as earlier, its just less intuitive and the "how-to's" tell you step by step and they dont match up... for instance I cannot find a way to generate the random number... anyways... thank you!
    Reply With QuoteRegister To Reply
  11. 05-27-2011, 12:56 PM #11
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bell curve

    =RAND() generates a random number [0..1) in every version of Excel.

    =RANBETWEEN(num1, num2) generates a random number between the two whole numbers num1 and num2, num1<=num2.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1