Tremendeous amount of respect for people like you who do that.
I have a question by the way here it calculated that mode is 14, but the sample data is bimodal because there are also "9" does excel have a function to find all the modes? or is it coming later on? Thanks a lot!
Hello, your videos are so helpful. I love the way you teach, it has helped me so much watching your videos. Listening to my teacher in class is not fun but your way of teaching makes one want to learn. I can't thank you enough for your great works. You are great. Thank you thank you thank you.
I am super happy that they help -- that is why I put them out there. Remember to rate each one -- the more ratings, the easier it will be for others to find them also!!
Thank you so much! I've always been lost as to what exactly PERCENTILE meant. I've seen it in several text books and dealt with it coutless times. However some how the way you presented it here just made it click. And I thought you were just a master of Excel.
EXCELlent! Now you know what I think: Stats and Excel Are Fun!
Hey, if you like this statistics video, I have many more to come. I have 10 coming out today and then about 50 - 100 more coming out over the next 6 weeks!
Great Videos ExcellsFun
Tremendeous amount of respect for people like you who do that.
I have a question by the way here it calculated that mode is 14, but the sample data is bimodal because there are also "9" does excel have a function to find all the modes? or is it coming later on? Thanks a lot!
ChrisAdams1985 2 years ago
MODE does not handle bimodal or multimodal situcations! I do address it some point in future videos. But when I MUST see all MODEs I:
1) Advance Filter Unique List
2) COUNTIF to create Frequency Table
See these two videos for how to do this:
Excel Magic Trick 82: Advanced Filter Extract Unique Records
Excel Magic Trick 55: Frequency Tables COUNTIF PivotTables
or simply pivot table:
Excel Statistics 04: Frequency Pivot Table Chart Basics
ExcelIsFun 2 years ago
Hello, your videos are so helpful. I love the way you teach, it has helped me so much watching your videos. Listening to my teacher in class is not fun but your way of teaching makes one want to learn. I can't thank you enough for your great works. You are great. Thank you thank you thank you.
kayogita 2 years ago
I am super happy that they help -- that is why I put them out there. Remember to rate each one -- the more ratings, the easier it will be for others to find them also!!
ExcelIsFun 2 years ago
Thank you so much! I've always been lost as to what exactly PERCENTILE meant. I've seen it in several text books and dealt with it coutless times. However some how the way you presented it here just made it click. And I thought you were just a master of Excel.
Thank you again,
IncongruentBalance
IncongruentBalance 2 years ago
Dear IncongruentBalance,
EXCELlent! Now you know what I think: Stats and Excel Are Fun!
Hey, if you like this statistics video, I have many more to come. I have 10 coming out today and then about 50 - 100 more coming out over the next 6 weeks!
--excelisfun
ExcelIsFun 2 years ago