Are you trying to subset the data (filter outliers)? If so, manually or automatically?need help from mathematicians/statistics geniuses pls
i have a dataset
View attachment 1012782
and i want to exclude "special cases" (that is outside of a majority range) outlined in the boxes
so what i am left with is +6.59 to -6.52
what is that mathematical formula called? percentile? median? rank? weighted avg? distribution? variance? etc
TIA!!!!!
The simple way I can think of is to a add a column with =if(AND(A1>=lowerbound,A1<=upperbound),A1,"")
Not sure if you need to filter the column afterward or if your formulas skip blanks.