Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots Download files: people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Five Number Summary: Min, Quartile 1, Quartile 2, Quartile 3 and Max 2. (02:41) Box Plots: Visual Summary of the Five Number Summary. How to calculate numbers with Excel and draw chart on paper 3. (07:55) +/- 3 Standard Deviation Outliers 4. (08:37) ABS function to find outliers 5. (09:17) +/- 3 Standard Deviation Outliers, COUNTIFS to count TRUE values 6. (10:08) +/- 3 Standard Deviation Outliers, Conditional Formatting to highlight Outliers
I want to tell you a story. Last March I was making an interview and I exagerated a bit on my excel skills. I've actually never used a computer that much before (so late compared to my generations) but here I was applying in the internet e-commerce industry :) and I did have just discovered your videos and I was confident they where going to bring me to level just in time (I was 10 days from starting the internship). I didn't even have the time to practice but just watching was enough to be outstanding from the beginning. All the short cuts where amazing. I couldn't believe I would transform them into practice such amazingly. Everybody has always said I'm great at excell, that 's so funny and incredible. Thanks again.
I just wanted to let you know that you have taken me from feeling like I would never pass my statistics class to actually enjoying learning from your videos. Thanks. Do you teach macro and finance to?
You are welcome! Thanks for the Thumbs Up on all videos and Sub! No Macro, but I have a full class about Excel and Finance: ruclips.net/p/PL90E1F26C7B85E78F
Hello Mike, question here. Considering the first method of finding outliers - Max+Multiple*Range - I'm afraid none will fall outside the Max value, did I misunderstand something here?
Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:09) Five Number Summary: Min, Quartile 1, Quartile 2, Quartile 3 and Max
2. (02:41) Box Plots: Visual Summary of the Five Number Summary. How to calculate numbers with Excel and draw chart on paper
3. (07:55) +/- 3 Standard Deviation Outliers
4. (08:37) ABS function to find outliers
5. (09:17) +/- 3 Standard Deviation Outliers, COUNTIFS to count TRUE values
6. (10:08) +/- 3 Standard Deviation Outliers, Conditional Formatting to highlight Outliers
I'm so happy to see your videos. You're my excel bible! :) and of course I'm waiting for the next one! Thanks for all these beautiful presents!
I am glad that you like the videos!
I want to tell you a story. Last March I was making an interview and I exagerated a bit on my excel skills. I've actually never used a computer that much before (so late compared to my generations) but here I was applying in the internet e-commerce industry :) and I did have just discovered your videos and I was confident they where going to bring me to level just in time (I was 10 days from starting the internship). I didn't even have the time to practice but just watching was enough to be outstanding from the beginning. All the short cuts where amazing. I couldn't believe I would transform them into practice such amazingly. Everybody has always said I'm great at excell, that 's so funny and incredible. Thanks again.
***** , I love that story! Thanks for the cool story! I am glad that the videos help!
Thanks!
I just wanted to let you know that you have taken me from feeling like I would never pass my statistics class to actually enjoying learning from your videos. Thanks. Do you teach macro and finance to?
You are welcome! Thanks for the Thumbs Up on all videos and Sub!
No Macro, but I have a full class about Excel and Finance:
ruclips.net/p/PL90E1F26C7B85E78F
I'm starting to think this guy actually made Excel from the ground up.
Thanks for your kind words and for your support with your comment and Thumbs Up : )
Thanks
Regd :(3,4,5)
How do you consider +/- 3
I couldn't understand the concept behind it
Hello Mike, question here. Considering the first method of finding outliers - Max+Multiple*Range - I'm afraid none will fall outside the Max value, did I misunderstand something here?
None will be past MAX, but some may or may not be past the outlier line, just not in this data set.