Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location. and this video is uploaded by excelisfun at 2015-01-23T19:39:46-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [vy8-f4bbehw]
| Name | Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location |
| Video Uploader | Video From excelisfun |
| Upload Date | This Video Uploaded At 24-01-2015 03:39:46 |
| Video Discription | Download files: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch03/Excel2013StatisticsChapter03.xlsm Topics in this video: 1. (00:32) Introduction to averages as typical values that represent a single value that represents all the data points 2. (01:17) Introduction to Location 3. (03:55) Sample Statistics are point estimators for the population parameters 4. (05:28) Mean using AVERAGE function 5. (09:16) Median using sorting or the MEDIAN function 6. (15:54) Mode for Categorical data using COUNTIFS and MODE for quatitative data using MODE.SNGL. Discussion about Bi-modal and multiple modes and why using a PivotTable rather than MODE.SNGL is wise. 7. (21:42) Relationship between Mean, Median and Mode and skew. [vy8-f4bbehw] |
| Category | Education |
| Tags | Excel 2013 | Statistical Analysis | Excel Statistics | Highline College | Business and Economic Statistical Analysis | Busn 210 | Mike Girvin | excelisfun | Mike excelisfun Girvin | Data Analysis | Mean | Median | Mode | Averages | Typical Values | Measures of central location | Location | AVERAGE Function | MODE.SNGL Function | COUNTIFS function for MODE nominal or ordinal or categorical data | PivotTable for MODE | Mean Fairly represent its data points |
