How to Use the Outliers Function in Excel

See more: www.ehow.com/tech/

[@karmenyoung8574]

The easiest example and explanation I've seen yet. And Ive seen them all. Thx Mucho.

[@Akzudil]

THANK YOU I OWE YOU MY LIFE!! I have a test about this tomorrow and I have no idea what would I do without this video thank you so much!!

[@ramihilwani1843]

The easiest example and explanation I've seen yet. And I've seen them all. Thx alot

[@BringMeThe0cean.]

THANK YOU!!! you made it super simple and easy to follow!

[@teesy1981ify]

I appreciate your videos a lot.

[@SaaVisha]

You are a darling

[@excelgladiator944]

Very educational this is exactly what i was looking for!

[@Live_Life_Love000]

Thanks a lot man...very clear and very helpful explanation...God Bless u

[@wasayansari2343]

Great JOB!
Thanks a lot.
That OR logic was dope :D

[@christiankopet5891]

Thank you so much, this really helped me out so much

[@nwabuemele5887]

wonderfully delivered, thanks alot for this video was really helpful

[@dllemm]

Great video! Tip: Press F4 for an absolute cell value (like $D$4)

[@2004sushi]

super easy with your explanation! thanks a lot!!!

[@jaquelinerosales7303]

Thank you X a billion !!!!!!!!!!!!!!!!!!!!!! this seemed impossible until I came across this video !:)

[@lemaianh5746]

Very nice tutorial

[@nikkibeigi9861]

thanks a million times

[@amandadavilaverardi5012]

Thank you so much! Very easy way of looking for outliers; great explanation!

[@farhatahmed1785]

this was of great help thanks !!!!!!!!!!!!!!!!

[@Ziplock9000]

Is there no spreadsheet function to directly calc UB and LB without doing the earlier steps, after all, they all all derived from the same data range?

[@LiatrisKitty]

Much better than my professor's video

[@samkab677]

Does this work wether the data is normally distributed or nonnormally distributed ?

[@jackieoh6488]

Thank you!!!!

[@kimlturner]

Awesome! Can you send me the paper that references this technique

[@puspasharma4290]

Thanks a lot. Why did you choose 1.5? is this constant value = D3+(1.5*D4) and D2-(1.5*D4)

[@MrKZee]

it's the statistical definition of an outlier - 1.5*interquartile range

[@acezhang8203]

didn't realize jack nicholson is teaching... great tutorial

[@jeadanielleformilleza4655]

Where did that 1.5 came from?

[@KhaLed-pb4pu]

Did you explain why 1.5? when calculating upper and lower bounds

[@SalmaAmr95]

it's the statistical definition of an outlier - 1.5*interquartile range

[@OPWJenniG]

What article are you referencing? I am trying to do this to a large data set with multiple values to analyze.

[@SpidermanX1]

Perhaps this one: "Tukey, J. W. (1977). Exploratory data analysis. Reading, MA: AddisonWesley."

[@finesse9602]

Hi Jennifer! Did you ever get an answer to your questions? I have the same question.

[@sevenhundred77_]

great

[@InfoHowTO]

informative video ......#infohowto

[@Azam_Pakistan]

Very nice .Audio volume too low making it difficult to listen.

[@humbertobarino578]

I had the same problem unfortanely

[@jasonaguirre9545]

What does it mean if they all came out TRUE?

[@wijaya4565]

Means there are no outliers

[@MrKZee]

overall this video requires knowledge of the basics, what the quortile

[@humbertobarino578]

Unfortanely the audio is too slow, what can be problem to students how has a other language as native.. But, is not a big problem at all, just a tip :)

[@santirsaid7811]

Really usefull and practic, apart from the teacher being hot. Thumbs up