First post, let's hope you don't laugh.
I have a program that does 1,000 trials to calculate two values, a score and the std deviation of that score.
So now I have two columns of values
The first column ranges from about 1.4 to -0.8 and the second standard deviation column is generally between 0.08 and 0.3
I want to normalize scores to fall between 0 and 1. There are formulas on the net to do this and it's easy.
My question is, how can I also scale the stddev column in the exact same way so that I don't have to recalculate them?