
Elementary Math Fractions, Percentages, Word Problems, Equations, Inequations, Factorization, Expansion 
 LinkBack  Thread Tools  Display Modes 
January 10th, 2017, 09:05 AM  #1 
Newbie Joined: Jan 2017 From: London Posts: 2 Thanks: 0  Looking for a formula to work out new values based on changing the Max and Min of...
Hi, not sure if this is the best place to ask  please let me know if there's a more suitable forum. I've got an irregular range of values ranging from infinity to 1 (randomizes every time). I want to be able to set a new value for the max and min values, and adjust everything in the range so that they stay in position relative to each other. For example, let's say I have ten values. The lowest is 40 and the highest is 8. I decided I want to make the highest one 0 and the lowest 10. I need to increase the lowest by 30, but the highest by only 8. I then need to increase the numbers in between each by a unique value so that they are in the same position relatively (but over a much smaller range). Anyone able to offer any assistance? Thanks. Last edited by skipjack; January 10th, 2017 at 02:03 PM. 
January 10th, 2017, 01:55 PM  #2 
Senior Member Joined: Feb 2010 Posts: 583 Thanks: 80 
A simple linear transformation comes to mind. Make two points from the information and find the equation of the line. In your example, you want $\displaystyle 40$ to map to $\displaystyle 10$ and you want $\displaystyle 8$ to map to $\displaystyle 0$. So make two points $\displaystyle (40,10)$ and $\displaystyle (8,0)$. From these two, make an equation for a line. The slope is $\displaystyle \frac{010}{840} = \frac{10}{32} = 0.3125$. So an equation for the line is $\displaystyle y = 0.3125x + 2.5$ 
January 10th, 2017, 02:05 PM  #3 
Global Moderator Joined: Dec 2006 Posts: 16,191 Thanks: 1147 
Do the values have to be integers?

January 11th, 2017, 01:46 AM  #4 
Newbie Joined: Jan 2017 From: London Posts: 2 Thanks: 0 
mrtwhs  thanks for the formula! I shall put this into system today and see if it fits what I'm trying to do. skipjack  no it doesn't. in fact I doubt it would work with just integers. Thanks guys 

Tags 
based, changing, formula, forumula, max, min, values, work 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Changing the subject of a formula  adamfoley  Algebra  2  March 23rd, 2013 02:05 PM 
Changing Numbers To Prescribed Values Under Special Limitati  perry  Algebra  5  February 11th, 2013 07:35 AM 
formula for calculating an changing percentage  Leander  Applied Math  0  February 3rd, 2012 02:04 PM 
Changing the subject of a formula  poochie03  Algebra  1  September 10th, 2011 01:10 PM 
Changing the subject of a formula  chuckienz  Linear Algebra  1  May 6th, 2009 06:23 PM 