topic Tighten a known distribution in Discussions

Tighten a known distribution

midori555tw — Tue, 02 Jul 2024 17:58:20 GMT

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!

Re: Tighten a known distribution

txnelson — Tue, 02 Jul 2024 19:46:25 GMT

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;