Excel Statistics 33: Measures Of Location

Learn about Mean, Median Mode, Percentile, Quartile, Percentile Rank and Rank. See the Excel functions; AVEARGE, MEDIAN, MODE, PERCENTILE, QUARTILE, PERCENTILERANK.

Chapter 03 Busn 210 Business and Economic Statistics and Excel Class. Descriptive Statistics Numerical Measures

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• AVEARGE
• MEDIAN
• MODE
• PERCENTILE
• QUARTILE
• PERCENTILERANK
• functions
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• community
• College

[ChrisAdams1985]

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!

[ExcelIsFun]

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

[kayogita]

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.

[ExcelIsFun]

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!!

[IncongruentBalance]

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

[ExcelIsFun]

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