Lower fence = Q1 = QUARTILE.INC(A1:E6,1) = 43
Upper fence = Q3 = QUARTILE.INC(A1:E6,3) = 58
IQR = Q3 - Q1 = 58 - 43 = 15
Number of outliers = 12 (i.e. there are 12 data points which lies outside the IQR)
Hope this answers your query!
Consider the following data set: 58 42.5 67.8 58 46.2 60.8 47.7 55.8 23.5 43 47.7...