Question

In excel :

what is the outliers for these test score: 32,37,41,44,46,48,53,55,57,57,59,63,65,68,69,70,71,74,74,75,77,78,79,81,82,83,86,89,92,95,107 I need the Q1, q3, IQR, II,UL , Outliers numbers

Answer 1

By using excel we have to solve this question.

First, enter data into excel.

We have to find outliers from the given data set.

If any value outside ( Q1 - 1.5*IQR, Q3 + 1.5*IQR) this interval we say that this is outlier value.

Q1: First quartile

Q3: Third quartile

IQR: Interquartile range

By using excel we can find Q1 and Q3 easily.

First, enter data into excel.

Q1 = 56

(Using excel =QUARTILE(Select data,1))

Q3 = 80

(Using excel =QUARTILE(Select data,3))

IQR = Q3 - Q1 =80 - 56 = 24

Q1 - 1.5*IQR = 56 - 1.5*24 = 44

Q3 + 1.5*IQR = 80 + 1.5*24 = 116

Interval is (44 , 116) we have to check how many values beyond this interval.

There are 32, 37, 41 are outliers.