Announcements
cancel
Showing results for
Did you mean:
Specialist II

## Clustering based on min and max of stdDev and Mean

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

1 Solution

Accepted Solutions
Specialist II
Author

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

2 Replies
Specialist II
Author

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?

Specialist II
Author

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

Community Browser