Excel 2010 Statistics #26: Measures of Central Tendency and Data Distribution
An overview of key statistical concepts in Excel 2010, including mean, median, mode, percentile, quartile, and percentile rank, with downloadable Excel files for practice.
excelisfun
13.5K views • Jul 7, 2011
About this video
Download Excel File #1: https://people.highline.edu/mgirvin/AllClasses/210Excel2010/Content/Ch03/Excel2010StatisticsCh03correct.xlsm
Download Excel File #2: https://people.highline.edu/mgirvin/AllClasses/210Excel2010/Content/Ch03/Excel2010StatisticsCh03SecondFile.xlsm
Download Excel File #3: https://people.highline.edu/mgirvin/AllClasses/210Excel2010/Content/Ch03/Excel2010StatisticsCh03ThirdFile.xlsm
1. Learn about locations measures: Mean, Median, Mode, Percentile, Quartile, PercentileRank
2. AVERAGE function
3. MEDIAN function
4. MODE.SNGL function
5. PERCENTILE.INC function
6. QUARTILE.INC
7. PERCENTILERANK.INC function
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin
Download Excel File #2: https://people.highline.edu/mgirvin/AllClasses/210Excel2010/Content/Ch03/Excel2010StatisticsCh03SecondFile.xlsm
Download Excel File #3: https://people.highline.edu/mgirvin/AllClasses/210Excel2010/Content/Ch03/Excel2010StatisticsCh03ThirdFile.xlsm
1. Learn about locations measures: Mean, Median, Mode, Percentile, Quartile, PercentileRank
2. AVERAGE function
3. MEDIAN function
4. MODE.SNGL function
5. PERCENTILE.INC function
6. QUARTILE.INC
7. PERCENTILERANK.INC function
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
13.5K
Likes
35
Duration
12:53
Published
Jul 7, 2011
User Reviews
3.9
(2) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
Trending Now