In: Statistics and Probability
For the data set below, find the upper outlier boundary.
154 160 146 131 148 164 199 169 139 165
199 |
||
19 |
||
165 |
||
193.5 |
For the given data we first find the first and third quartiles
using Excel function Qurtile.Exc
Q1 = Quartile.exc(data, 1)
Q1 = 144.25
Q3 = Quartile.exc(data, 3)
Q3 = 166
Inter Quartile Range
IQR = Q3 - Q1
= 166 -
144.25
= 21.75
Upper outlier boundary is given by
Q3 + 1.5 * IQR
= 166 + 1.5 * 21.75
= 198.625
Upper outlier boundary is = 198.625
Hence, the observation 199 is an outlier as it is greater than 198.625