
Computer Science Computer Science Forum 
 LinkBack  Thread Tools  Display Modes 
May 22nd, 2012, 12:33 PM  #1 
Newbie Joined: May 2012 Posts: 3 Thanks: 0  Calculating a position in a range while limiting the range
Hello I am calculating a position of a values within the range in order to apply the weight to it The idea behind the process is to put all of the values on the same level by flatten them and them multiplying it with the weight. This works fine but I have an issue where 90 % of the values are in the range of 1  1000 but there is one value which is 10000 which raises the ceiling. how can I limit the ceiling to where 90% of the values are? 
May 22nd, 2012, 12:56 PM  #2 
Global Moderator Joined: May 2007 Posts: 6,835 Thanks: 733  Re: Calculating a position in a range while limiting the ran
Your description is too vague.

May 22nd, 2012, 01:25 PM  #3 
Newbie Joined: May 2012 Posts: 3 Thanks: 0  Re: Calculating a position in a range while limiting the ran
OK let me try again: The idea behind the process is to put all of the values on the same level by flatten them and them multiplying it with the weight. Here is the formula: Descending: [Order] when Desc then MaxPrice  isNull(Price, MaxPrice) / MaxPrice  MinPrice Ascending (isNull(Price , MinPrice)  MinPrice)/(MaxPrice MinPrice) Lets say that you have a price range of 1 – 100 and a product price is 40 Asc ( 40  1) / (100  1) = 0.39 Desc. (10040)/(100  1)= 0.60 Meaning when sorting ascending value 40 is in the 39th percentile, or when sorting descending value 40 is in the 60th percentile. This value is then multiplied by a weight of .4 The issue is when the maximum value is an oneoff lats say 10,000 the scale of this column is then thrown off. I want to limit the maximum value to that of the 90% of the members essentially eliminating the one offs. 
May 22nd, 2012, 04:50 PM  #4 
Global Moderator Joined: Nov 2006 From: UTC 5 Posts: 16,046 Thanks: 938 Math Focus: Number theory, computational mathematics, combinatorics, FOM, symbolic logic, TCS, algorithms  Re: Calculating a position in a range while limiting the ran
So what's the question? You have the formulas already, just plug the 90th percentile in.

May 23rd, 2012, 05:14 AM  #5 
Newbie Joined: May 2012 Posts: 3 Thanks: 0  Re: Calculating a position in a range while limiting the ran
How do I calculate the maximum value of 90% of all values

May 23rd, 2012, 05:16 AM  #6 
Global Moderator Joined: Nov 2006 From: UTC 5 Posts: 16,046 Thanks: 938 Math Focus: Number theory, computational mathematics, combinatorics, FOM, symbolic logic, TCS, algorithms  Re: Calculating a position in a range while limiting the ran
Sort the values, pick the one at the 90th percentile. So if there are 1000 entries, sort them and then pick #100 (or #900, depending on which way you sort).


Tags 
calculating, limiting, position, range 
Search tags for this page 
Click on a term to search for related topics.

Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
calculating relative position in 3d space  S33K3R  Algebra  16  June 9th, 2019 06:49 PM 
Calculating Domain and Range of fg(x)? please help  zeeghaffar  Calculus  6  May 19th, 2013 03:37 PM 
Range of f(x)  stuart clark  Calculus  7  April 24th, 2011 12:01 PM 
Range of y=3/(x^2+1)?  basketball041520  Algebra  5  September 21st, 2010 09:54 AM 
range  mia6  Advanced Statistics  0  September 25th, 2008 02:29 PM 