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:
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)
How can I control this process of changing the range?