Outlier Tester Excel activity
Last updated 25 March 2013, created 08 July 2010, viewed 1,062
Used in the whole class setting, students' intuitions about what is likely to be an outlier
can be offered up through a range of different problems. This is a really simple but fun spreadsheet
that gives students a chance to explore the definition of an outlier that uses the IQR.
If we are gi More…ven the quartiles for the data, then a rough rule of thumb is: anything less than Q1 – 1.5(IQR) can be regarded as an outlier. anything greater than Q3 + 1.5(IQR) can be regarded as an outlier.