Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will cover the basic statistical functions, particularly the descriptive functions which you can use to describe a set of results or enable you to compare one sample with another sample.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016 Advanced.
In this and the next few sections we’re going to look at the use of Statistical functions.

Now Statistical functions are amongst the most numerous in Excel 2016 and many of them are used in relation to pretty complex statistics. And because this isn’t a specialized course in statistics I’m really going to look mainly at the most commonly used and in some senses most basic statistical functions. But if you do have an advanced knowledge of statistics and if you need to use statistical functions you’ll find that the ones that are provided in Excel 2016 are a pretty powerful set nowadays. I’m looking at the Excel 2016 Help page here and if I just scroll down the list of Statistical functions you’ll see just how many of them there are. As usual the ones that have been introduced in the current version are marked with 2016. And there’s a batch there related to forecasting.

Now in my coverage of statistical functions I’m really going to divide the functions and their use into three main groups. First of all we’re going to look at the descriptive functions. These are the functions that you can use to describe a set of results, normally one or more samples of results, and where you’re looking at statistics that in some way typify those results or represent those results or enable you to compare, for example one sample with another sample.

The second set of functions are the ones that are used for prediction or forecasting, and that includes these new functions that you can see here. And then the third set are the set that are used for statistical inference. And these are functions where based on a sample you want to infer something about, for example, the population that the sample comes from. These are often functions that are used in scientific research, opinion polls and so on.

Now one point to bear in mind is that as I mentioned just now this is a very long list of functions. And a couple of functions here, Quartile.EXE and Quartile.INC. We saw the use of Quartile.INC earlier in the course. Don’t forget there is also a function Quartile. And in fact there are quite a few statistical functions that are still available in Excel 2016 that have been superseded by the ones listed here.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.