I was trying to find mean of this data set, I tried using AVERAGE, IQR and also T statistic, but was not able to get what would be the right mean of the data set below, can anyone please help how can I best find the mean. Thank you.
-36.64%
-47.15%
112.43%
-5.25%
35.08%
30.17%
38.05%
5.70%
-21.85%
-18.04%
2.73%
0.24%
8.36%
117.35%
-40.26%
-15.71%
-4.01%
6.24%
-57.36%
-18.74%
182.71%
-83.38%
CodePudding user response:
From what you write I believe you are looking for the trimmed or rather truncated mean, see
Formula in C1
:
=TRIMMEAN(A1:A22,0.2)
Here we excluded 20% of the outliers in our mean.