Testing for Outliers in Excel – Single Variable Sample

About this tutorial:

Video duration: 3:45
Example of how to use Excel to check for official outliers in a sample consisting of a single variable, e.g., several measurements of a singly quantity like pressure or voltage, etc. The modified Thompson tau technique is used.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

15 thoughts on “Testing for Outliers in Excel – Single Variable Sample

    Richard Piffer S de Campos

    (October 9, 2018 - 8:36 pm)

    Simply explained. Thank you

    Marcos Arantes

    (October 9, 2018 - 8:36 pm)

    Since the test is based on t-values, it requires the sample to be normally distributed, right?


    (October 9, 2018 - 8:36 pm)

    this really helped me. thx!

    Robert Chisena

    (October 9, 2018 - 8:36 pm)

    Hi Dr. Cimbala! I stumbled on your video by chance and recognized the notes from your class. Thanks for sharing, very helpful. Hope you are well! Robert '14

    marlon pereira

    (October 9, 2018 - 8:36 pm)

    you´re good man, thank you very much!!!

    Conor Laing

    (October 9, 2018 - 8:36 pm)

    How would you report your results if you had found an outlier?


    (October 9, 2018 - 8:36 pm)

    Why is this method viable? Sorry if this is bothersome but I am just intrigued.


    (October 9, 2018 - 8:36 pm)

    finally! an outlier test that will test an N=4 sample size.

    Amin Serehali

    (October 9, 2018 - 8:36 pm)

    thank you this is very helpful. Is there a way I can test multiple values at once instead of 1 value at a time?  thanks

    Nini Hu

    (October 9, 2018 - 8:36 pm)

    could you please show how to calculate tau in excel?

    Kevin Adkinson

    (October 9, 2018 - 8:36 pm)

    I thought you could only do a Dixon Q-test once on a single data set…. no?

    Thiago Vieira

    (October 9, 2018 - 8:36 pm)

    Thanks a lot! It was very useful. 🙂

    carolina urbina

    (October 9, 2018 - 8:36 pm)

    Does this apply for n=9000? Thank you.

    Kathleen Watts

    (October 9, 2018 - 8:36 pm)

    what if n is 705? The tau has 500 then goes to 1000.. what is the tau for n:705?

    Rohith Basu

    (October 9, 2018 - 8:36 pm)

    thank you sir

Leave a Reply

Your email address will not be published. Required fields are marked *