Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Classify records into percentiles? - Visokio Forums
Formulae: Classify records into percentiles?
  • jraja July 18, 2013 8:49AM
    I need to identify percentile values within buckets that I have created, how can I do this?
  • 2 Comments
  •     paola July 18, 2013 9:56AM
    Please see the attached file that enables you to use variable and change percentile calculations on the fly.
    Attachments
    		 PercentilesCalculation.iok 261K
    		Normal Distribution dataset.xlsx 810K
  •     paola July 18, 2013 10:02AM
    Formulas used :
     
    [RankHeight] = RANK([Height(Inches)])
     
     
    [BucketHeight] = ([Percentile]/100)*ALLRECORDCOUNT+.5
     
     
    [PercentileGroup]= 
    IF(([RankHeight]/[BucketHeight]-INTFLOOR( [RankHeight]/[BucketHeight]))=0,
     
    [RankHeight]/[BucketHeight],
     
    INTFLOOR( [RankHeight]/[BucketHeight])+1)      
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged