I have a table with 3 columns X, Y and Z with n rows.

The range of the data is 0-255. But I wished to scale the values such that the range becomes from -p to +q (where I decide p and q). I randomly came upon a conversion like this one:

enter image description here

on this site. I don't remember which matrix exactly did I use.

Now this is how it changed the range (Blue: Initial range, Orange: New Range, Ignore the Grey one)

Blue: Initial range,  Orange: New Range, Ignore the Grey one

How can I control this process of changing the range?

  • $\begingroup$ This answer to another question might address your issue. $\endgroup$
    – deemel
    Jan 21, 2020 at 16:14
  • $\begingroup$ @deemel Neither Normalization nor Standardization can scale the entire range into a custom range. Thanks btw $\endgroup$
    – Pe Dro
    Jan 21, 2020 at 16:41
  • 1
    $\begingroup$ On the contrary, both can do it. The duplicate explicitly answers the question (see stats.stackexchange.com/a/70808/919)--but you can find a large number of other (equivalent) answers here, too. $\endgroup$
    – whuber
    Jan 21, 2020 at 16:56


Browse other questions tagged or ask your own question.