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

Download files: people.highline.edu/mgirvin/A...
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.

[@user-fc7li3mg3p]

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

[@kenham5324]

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.

[@rizkyramdhany4549]

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

[@excelisfun]

You are welcome!

[@chinaprise]

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

[@excelisfun]

Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location
Download files: people.highline.edu/mgirvin/excelisfun.htm
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.

[@mustafaal-dabbagh6105]

Hi excel fun NINJA MASTER
i want to sincerely thank you for all the effort that you are doing saving everyone's day through MS excel.
i started as beginner user& now i am showing off my excel skills among my friends because of you, so Many thanks & God bless you.
I am a civil engineer from Iraq
i want your advise about the best video to follow, because there lots of videos that its not in my area of interest ( like finance, marketing, etc ).
kindly advise me to get the best experience through your playlist videos. (like Excel compare/merge two list, excel naming formating, etc...) which groups are useful for me as you may see.
many thanks & regards

[@excelisfun]

To learn Excel you follow these two playlists:
ruclips.net/p/PL3FBEE51974F03CCF
ruclips.net/p/PLrRPvpgDmw0nh4BBxqjcsnbB4ME4JjzfJ

[@mustafaal-dabbagh6105]

many thanks & regards

[@vaniad25]

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.

[@excelisfun]

That is great that you want to know the why - that's what makes us smart : ) Thanks for your support!!!

[@pphong]

Thanks!

[@Clifffffffffford]

Thanks

[@oddnumber8149]

μ in greek called as "m" not mew

[@ayanmitra6841]

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

[@excelisfun]

I just checked the server is working : )

[@ayanmitra6841]

@@excelisfun Might be cause of my Internet. I will try to download again tomorrow. Thank you :D