Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank

[@excelisfun]

Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:24) Percentile where position is calculated with P%*(n+1)
2. (04:26) PERCENTILE.EXC function
3. (05:18) What percentile tells you
4. (06:09) QUARTILE.EXC function
5. (06:59) PERCENTILERANK.EXC function
6. (07:45) Median
7. (08:48) Quartile 1, 2, 3
8. (09:34) Quintiles
9. (10:03) Deciles
10. (10:24) Percentile rank for whole data set
11. (11:24) PERCENTILE.INC, QUARTILE.INC functions
12. (14:13) Five Number Summary
13. (14:40) Big Data Set to see that PERCENTILE.INC and PERCENTILE.EXC are very close if not exactly the same.
14. (16:29) Ranking. RANK,EQ and RANK.AVE functions
15. (18:46) ) PERCENTILERANK.INC function
16. (19:00) Data Ribbon Tab, Analysis group, Data Analysis, Rank and Percentile feature

[@pavankadam9242]

Great Video as always! Love the way it is divided in the description with timelines so that we can jump to the part we want! Thanks a lot for all your amazing Excel videos!!!

[@excelisfun]

You are welcome! Thanks for your Sub, and Thumbs Up on each video!

[@Chamchijjige]

Thank you very much sir.

[@excelisfun]

You are welcome very much : ) !!! : )

[@pphong]

Thanks!

[@excelisfun]

You are welcome, Phong P!!!!

[@Clifffffffffford]

Thanks

[@excelisfun]

You are welcome, clifford!

[@DIGITAL_COOKING]

this one needs a cup of cafe before the start :)

[@excelisfun]

Yes, there is a lot in this one : )

[@gameaspiring3358]

is this ungroup data only?