Help Please on Data Ranges: want to change "60% to 80%" top "60% to 95%"
Hello;
I am in need of some help. This is my first post, so I hope that I am doing this correctly.
I have a data set of percentages. Let's say the range is from 60% to 80%. I would like to expand the range so the range goes from 60% to 95%, and adjust each data point accordingly. I realize that this will cause a shift in Mean and standard deviation. In an ideal world, I would like to figure out 2 mathematical formulas for doing this two different ways.
1) Such that I can pick the upper limit and all of the data points adjust to the new range.
2) Such that I can choose the mean and all of the data points adjust accordingly.
So the result will be:
a) a wider range
b) the upper data points will have increased more than the lower data points
c) the lowest data point stays the same.
If anyone could please help me out, I would appreciate it.
Thanks.
Polar
Hello;
I am in need of some help. This is my first post, so I hope that I am doing this correctly.
I have a data set of percentages. Let's say the range is from 60% to 80%. I would like to expand the range so the range goes from 60% to 95%, and adjust each data point accordingly. I realize that this will cause a shift in Mean and standard deviation. In an ideal world, I would like to figure out 2 mathematical formulas for doing this two different ways.
1) Such that I can pick the upper limit and all of the data points adjust to the new range.
2) Such that I can choose the mean and all of the data points adjust accordingly.
So the result will be:
a) a wider range
b) the upper data points will have increased more than the lower data points
c) the lowest data point stays the same.
If anyone could please help me out, I would appreciate it.
Thanks.
Polar