Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
trying to see if there is a way I can do clustering based on the min and max of StdDev and Mean to split my data into 4 buckets
0 to min StdDev
min StdDev to Mean
Mean to Max Std
Max STD to highest Value.
Here is an example in math.. my main problem is I want to apply the logic based user selections..
https://www.easycalculation.com/statistics/standard-deviation.php
my expression was a mess.. I fixed it.
=if(myRandomNumber <= (avg(Total myRandomNumber) - Stdev(Total myRandomNumber) ), 1,
if(myRandomNumber <= avg(Total myRandomNumber) , 2,
if(myRandomNumber <= (avg(Total myRandomNumber) + Stdev(Total myRandomNumber) ), 3,4)))
I created the attached app to generate 200 numbers then I applied the logic I want.. you can see it in the chart but still not getting any results..
Used Expression:
=if(myRandomNumber <= (avg(Total myRandomNumber) - Stdev(Total myRandomNumber) ), 1,
if(myRandomNumber <= avg(Total myRandomNumber) , 2,
if(myRandomNumber <= (avg(Total myRandomNumber) + Stdev(myRandomNumber) ), 3,
if(myRandomNumber > (avg(Total myRandomNumber) + Stdev(Total myRandomNumber) ), 4
Any thoughts?
my expression was a mess.. I fixed it.
=if(myRandomNumber <= (avg(Total myRandomNumber) - Stdev(Total myRandomNumber) ), 1,
if(myRandomNumber <= avg(Total myRandomNumber) , 2,
if(myRandomNumber <= (avg(Total myRandomNumber) + Stdev(Total myRandomNumber) ), 3,4)))