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 take a look at measures of spread as well as discuss the alternatives for calculating them. We will be calculating quartiles, interquartile range, semi interquartile range, and standard deviation.

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 the preceding section we looked at some averages in relation to statistical samples. And in this section we’re going to look at measures of spread.

Now in order to do an analysis of a statistical sample or indeed to do a comparison with another statistical sample it’s pretty much always necessary not only to have some kind of averages to give you an idea of how big or how long or how many of something are associated with that sample but also to have a good idea of how spread out the values are, how much variation is there in this sample.

Now in statistics in general there are quite a few very useful measures of spread and we’re going to look at the main ones in this section and we’re going to look at alternatives for calculating them in Excel 2016.
Now as part of that I’m going to need to explain one or two statistical concepts and terms. But I’m going to do that in a pretty straightforward kind of way, I hope. So if you’re not very comfortable with statistics I think you should still have a pretty good idea of what’s going on in this section.

So what I’ve done already is to calculate the median number of enquiries and policies. And you may recall the way that we calculate the median is that we put, for example, the number of enquiries per month in numerical order, not in order of month, numerical order. And we looked for the one that’s in the middle. If there are two in the middle, so we’ve got an even size sample, we take the average of the middle two.

Now if you did that with the contents of column B, B4 downwards, you would find that the median is 574. But of course we used the Median function in Excel 2016 to do that for us.
Now I also mentioned at that time that apart from taking that middle value we could identify the quartiles. And the quartiles lead us to a very good measure of spread. So what I’m going to do now is to calculate the quartiles for the number of enquiries and the number of policies.

I also mentioned earlier on that there are actually two quartile functions. Now there’s Quartile.INC and Quartile.EXC. And in a moment I’m going to explain the difference between those. I mentioned it earlier but I’m going to give you a very quick demonstration of it in this section.

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