Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location

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.

[Munna-rw]

the way you put everything together what others resources don't is just so precise and clear, you have no idea.

[kenham]

I am lucky that I was able to find your website. I doing a finance major and all your videos are useful for me in my classes. These are the skills my employer will be looking for and I’ll have it all and more thanks to you.

[excelisfun]

Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location
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 quantitative 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.

[rizkyramdhany]

The Statistic that you teach is quite implementative in real life job. I'm glad to find this channel. Thanks

[vaniad]

Thanks for adding two ways of calculating the skewness. I have seen the sumproduct before, but never used it and in this formula for skewness it finally became clear to me how great that command is. Of course the skew command is there and it's easy, but it's always great to know what is happening behind the easier command.

[chinaprise]

you're awesome! i want to watch all your videos!

[ayanmitra]

Unable to download the excel file. The video is really good.

[oddnumber]

μ in greek called as "m" not mew