re-scaling data

[arianfar.a]

I have a column of values with the range of 0 to 1000 (scale is between 0 and 1000). How can I re-scale them to become between -0.15 to 0.45?

Thanks in advance

 

[RSXchin]

before I fathom how to do this... Why?

Oh yeah. Welcome to the forums.
most people are more helpful, I swear. But it's 00:30 here, and I have insomnia.

 

[RSXchin]

try this

=(A1*0.0006)-0.15

 

[arianfar.a]

Re: re-scaling data
<hr style="color:#FFFFFF; background-color:#FFFFFF" size="1"> try this
Code:

=(A1*0.0006)-0.15
Thanx for the reply. How did you find the function to re-scale the data? Could you pls elaborate? Because when I re-scale them, most points fall out of the scale (-0.15-0.45).


</pre>

 

[RSXchin]

what numbers do you have, and what do you expect them to be?

 

[littleiitin]

Use this formula

=((A1-Min1)*(Max2-Min2)/(Max1-Min1))+Min2

where A1= Value in Cell A1
Min1=0
Max1=1000

Min2=-.15
Max2=.45

 

[RSXchin]

deleted

 

[RSXchin]

Use this formula

=((A1-Min1)*(Max2-Min2)/(Max1-Min1))+Min2

where A1= Value in Cell A1
Min1=0
Max1=1000

Min2=-.15
Max2=.45

with your formula, 1000= 15.6 which is well out of the range
with my formula, 1000 = 0.45 as he said it should've

 

[arianfar.a]

Thnak littleltlin,
it's same as RSXchin's formula but in details. Is there any way to prove it, i.e. to be logically accepted for re-scaling? I mean from where this formula comes?

Thanks a lot,

 

[littleiitin]

Actually not.

I have used this one: and it is Giving correct answer:

"B1"=((A1-0)*(0.45-(-0.15))/(1000-0))+(-0.15)

"B1001"=((A1001-0)*(0.45-(-0.15))/(1000-0))+(-0.15)


This is generic formula and can be used for any scaling problem.