Clustering based on min and max of stdDev and Mean

[alec1982]

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

[alec1982]

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?

[alec1982 · Accepted solution]

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)))