Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2010
    Location
    Minnesota
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Needing to Ranks Standard Deviation

    Iím hoping someone can help me with my newest rank issue.
    Iím trying to get a rank my standard deviation so it will be a number below 1, the numbers I'm trying to rank are below.
    Example:
    Code:
    Rank1: 1+DCount("*","[Table1]","[Standers deviation]<" & [Standers deviation])
    What happends when I run the formula above all my ranks comeout to "1"
    -0.346475955413238
    -0.393008929311432
    -0.313430681489258
    0
    -0.408248290463863
    -0.39972826427894
    -0.379339734056029
    -0.123600171413157
    -0.365864893089862
    -0.183973875868388
    -0.371230105706986
    -0.262369301094045
    -0.321886521586874
    -0.391106441996541
    -0.137470711646278
    -0.124342264640857
    -0.228627545996961
    -0.314589973831583
    -0.217890019842972
    -0.271519018007927
    -0.251561710306367
    -0.249946076975505
    -0.269279732015007
    Thanks for all your help
    Last edited by WendellB; 2011-01-18 at 15:26. Reason: To correct the quote tag at the end of the numbers

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    DCount() is a function which does exactly that - so it counts the number, and always returns an integer. If you want to calculate a standard deviation you should use the DStDev() function.
    Last edited by WendellB; 2011-01-18 at 15:25.
    Wendell

Posting Permissions

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