Tighten a known distribution

[#1]

Hi all,

I have a known distribution and base on available information I predict the variation is going to tighten 30% for the distribution in future. Is there a way to get the tightened distribution maintaining the sample size with tighter variation?

TIA!

[#2 · Accepted solution]

A real simple way would be to apply the below formula to a new column

As Constant( m = Col Mean( :Your original column ) );
(:Your original column - m) * 0.7 + m;