Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank
HTML-код
- Опубликовано: 22 янв 2015
- Download file: people.highline.edu/mgirvin/A...
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
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
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!!!
You are welcome! Thanks for your Sub, and Thumbs Up on each video!
this one needs a cup of cafe before the start :)
Yes, there is a lot in this one : )
Thanks!
You are welcome, Phong P!!!!
Thank you very much sir.
You are welcome very much : ) !!! : )
Thanks
You are welcome, clifford!
is this ungroup data only?