Тёмный

How to Use the Outliers Function in Excel 

eHowTech
Подписаться 501 тыс.
Просмотров 137 тыс.
50% 1

See more: www.ehow.com/tech/

Хобби

Опубликовано:

 

27 янв 2016

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 41   
@Akzudil
@Akzudil 7 лет назад
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!!
@karmenyoung8574
@karmenyoung8574 8 лет назад
The easiest example and explanation I've seen yet. And Ive seen them all. Thx Mucho.
@ramihilwani1843
@ramihilwani1843 3 года назад
The easiest example and explanation I've seen yet. And I've seen them all. Thx alot
@BringMeThe0cean.
@BringMeThe0cean. 4 года назад
THANK YOU!!! you made it super simple and easy to follow!
@SaaVisha
@SaaVisha 5 лет назад
You are a darling
@teesy1981ify
@teesy1981ify 5 лет назад
I appreciate your videos a lot.
@excelgladiator944
@excelgladiator944 Год назад
Very educational this is exactly what i was looking for!
@christiankopet5891
@christiankopet5891 6 лет назад
Thank you so much, this really helped me out so much
@nwabuemele5887
@nwabuemele5887 3 года назад
wonderfully delivered, thanks alot for this video was really helpful
@Live_Life_Love000
@Live_Life_Love000 7 лет назад
Thanks a lot man...very clear and very helpful explanation...God Bless u
@wasayansari2343
@wasayansari2343 6 лет назад
Great JOB! Thanks a lot. That OR logic was dope :D
@2004sushi
@2004sushi 3 года назад
super easy with your explanation! thanks a lot!!!
@jaquelinerosales7303
@jaquelinerosales7303 6 лет назад
Thank you X a billion !!!!!!!!!!!!!!!!!!!!!! this seemed impossible until I came across this video !:)
@lemaianh5746
@lemaianh5746 6 лет назад
Very nice tutorial
@farhatahmed1785
@farhatahmed1785 6 лет назад
this was of great help thanks !!!!!!!!!!!!!!!!
@dllemm
@dllemm 7 лет назад
Great video! Tip: Press F4 for an absolute cell value (like $D$4)
@nikkibeigi9861
@nikkibeigi9861 5 лет назад
thanks a million times
@amandadavilaverardi5012
@amandadavilaverardi5012 4 года назад
Thank you so much! Very easy way of looking for outliers; great explanation!
@jackieoh6488
@jackieoh6488 5 лет назад
Thank you!!!!
@LiatrisKitty
@LiatrisKitty 3 года назад
Much better than my professor's video
@Ziplock9000
@Ziplock9000 6 лет назад
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?
@puspasharma4290
@puspasharma4290 6 лет назад
Thanks a lot. Why did you choose 1.5? is this constant value = D3+(1.5*D4) and D2-(1.5*D4)
@MrKZee
@MrKZee 5 лет назад
it's the statistical definition of an outlier - 1.5*interquartile range
@kimlturner
@kimlturner 5 лет назад
Awesome! Can you send me the paper that references this technique
@samkab677
@samkab677 6 лет назад
Does this work wether the data is normally distributed or nonnormally distributed ?
@acezhang8203
@acezhang8203 5 лет назад
didn't realize jack nicholson is teaching... great tutorial
@sevenhundred77_
@sevenhundred77_ 6 лет назад
great
@OPWJenniG
@OPWJenniG 7 лет назад
What article are you referencing? I am trying to do this to a large data set with multiple values to analyze.
@SpidermanX1
@SpidermanX1 5 лет назад
Perhaps this one: "Tukey, J. W. (1977). Exploratory data analysis. Reading, MA: AddisonWesley."
@finesse9602
@finesse9602 5 лет назад
Hi Jennifer! Did you ever get an answer to your questions? I have the same question.
@KhaLed-pb4pu
@KhaLed-pb4pu 4 года назад
Did you explain why 1.5? when calculating upper and lower bounds
@SalmaAmr95
@SalmaAmr95 Год назад
it's the statistical definition of an outlier - 1.5*interquartile range
@jeadanielleformilleza4655
@jeadanielleformilleza4655 4 месяца назад
Where did that 1.5 came from?
@InfoHowTO
@InfoHowTO 3 года назад
informative video ......#infohowto
@Azam_Pakistan
@Azam_Pakistan 6 лет назад
Very nice .Audio volume too low making it difficult to listen.
@humbertobarino578
@humbertobarino578 6 лет назад
I had the same problem unfortanely
@humbertobarino578
@humbertobarino578 6 лет назад
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 :)
@jasonaguirre9545
@jasonaguirre9545 5 лет назад
What does it mean if they all came out TRUE?
@wijaya4565
@wijaya4565 5 лет назад
Means there are no outliers
@MrKZee
@MrKZee 5 лет назад
overall this video requires knowledge of the basics, what the quortile
@santirsaid7811
@santirsaid7811 5 лет назад
Really usefull and practic, apart from the teacher being hot. Thumbs up
Далее
EXCEL PRO TIP: Outlier Detection
9:31
Просмотров 9 тыс.
Редакция. News: 125-я неделя
48:25
Просмотров 1,7 млн
Statistics - How to find outliers
4:45
Просмотров 914 тыс.
Excluding and Formatting Outliers in Excel Charts
5:42
How to Find Outliers with Excel
6:07
Просмотров 297 тыс.
Identifying and Highlighting Outliers in Excel
8:43
Просмотров 85 тыс.
Using Microsoft Excel to Determine Outliers
5:56
Просмотров 26 тыс.
How to Use VLOOKUP to Compare Two Lists
15:20
Просмотров 757 тыс.
Outlier detection with Excel
8:00
Просмотров 10 тыс.