 My Math Forum Calculating a position in a range while limiting the range
 User Name Remember Me? Password

 Computer Science Computer Science Forum

 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. (100-40)/(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 one-off 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 ,

calculating position in range

Click on a term to search for related topics.
 Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Similar Threads Thread Thread Starter Forum Replies Last Post S33K3R Algebra 16 June 9th, 2019 06:49 PM zeeghaffar Calculus 6 May 19th, 2013 03:37 PM stuart clark Calculus 7 April 24th, 2011 12:01 PM basketball041520 Algebra 5 September 21st, 2010 09:54 AM mia6 Advanced Statistics 0 September 25th, 2008 02:29 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top      