My Math Forum  

Go Back   My Math Forum > Science Forums > Computer Science

Computer Science Computer Science Forum


Reply
 
LinkBack Thread Tools Display Modes
May 22nd, 2012, 01: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?
tale is offline  
 
May 22nd, 2012, 01:56 PM   #2
Global Moderator
 
Joined: May 2007

Posts: 6,402
Thanks: 547

Re: Calculating a position in a range while limiting the ran

Your description is too vague.
mathman is offline  
May 22nd, 2012, 02: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.
tale is offline  
May 22nd, 2012, 05:50 PM   #4
Global Moderator
 
CRGreathouse's Avatar
 
Joined: Nov 2006
From: UTC -5

Posts: 16,046
Thanks: 937

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.
CRGreathouse is offline  
May 23rd, 2012, 06: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
tale is offline  
May 23rd, 2012, 06:16 AM   #6
Global Moderator
 
CRGreathouse's Avatar
 
Joined: Nov 2006
From: UTC -5

Posts: 16,046
Thanks: 937

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).
CRGreathouse is offline  
Reply

  My Math Forum > Science Forums > Computer Science

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 Domain and Range of fg(x)? please help zeeghaffar Calculus 6 May 19th, 2013 04:37 PM
Range of f(x) stuart clark Calculus 7 April 24th, 2011 01:01 PM
Range of y=3/(x^2+1)? basketball041520 Algebra 5 September 21st, 2010 10:54 AM
calculating relative position in 3d space S33K3R Algebra 15 August 28th, 2010 04:23 PM
range mia6 Advanced Statistics 0 September 25th, 2008 03:29 PM





Copyright © 2017 My Math Forum. All rights reserved.