 Statistics and Excel. Mean and outliers. Got data? Let's get stuck into it with statistics and Excel. I mean we'll be using OneNote here but we'll still talk about Excel. You're not required to but if you have access to OneNote we're in the icon the left-hand side OneNote presentations 1416 mean and outlier tab we're also uploading transcripts to OneNote so that you can go to the view tab use the immersive reader tool changing the language if you so choose being able to read or listen to the transcript and multiple languages tying the transcripts into the video presentation using the timestamps. One note desktop version here data on the left-hand side our salary data that we are imagining for a corporation for example we're going to do some of our standard calculations on the data set such as the mean or the average the median the max the men quartile one quartile three and then we're gonna add an outlier in this case imagining that to be the CEO salary which is far higher than any other salary and then look at what changes with those standard calculations and what implications those changes may have when we're making decisions in the future in terms of what types of numbers do we want to be using to represent our data set for relevant decision-making all right so if we look at our data set on the left-hand side this is our salary data set we're going to be doing the average calculation these are just our formulas for the average calculations that we've seen in the prior presentations here's going to be our numbers that we would be calculating we've got the mean or the average which we could calculate using our formulas up here which means we would basically add up our data set and divide by the number of items within the data set if using excel we can use this trustee average function which would simply be equals average in order to calculate it scroll out of here a little bit so we can see this at one time then we're going to have the median remember that's the one that we're going to pick the one in the middle so if we sort it from the lowest to highest simply picking the one in the middle is the median and if we have Excel Excel can do that for us obviously we not we need to know what the difference is between a mean calculation and a median calculation and we'll see here that of course there are times when one will be more relevant than another and we have to pick the more relevant one in this case you can see that they're two are fairly close to each other and that would give us an indication in and of itself that there isn't a huge outlier possibly that's really skewing the mean if these two are very different from each other that might give us an indication that that there could be an outlier impact and if there is then we probably want to dig down deeper and see what's going on with it so then we have the maximum this is the largest number in the data set we can get that by just using the function equals max to pick that up and then we have the men that's going to be the lowest number in the data set which we can see right here is the 67 9 the highest number if I go down 84,000 was the 84,000 here we can get to the men which simply equals men calculation and then we've got quartile one which now we're taking like the middle point of that first quartile we're break we're basically breaking the data set taking it from top to bottom right and then breaking it up not just in the middle point but by quartiles and you can use in excel the quartile.exe you have to use one more argument a comma one to get the quartile one to calculate and then we have quartile three because we already have quartile two in the median and here's the calculation for that quartile three you just need a three at the end of it to be picking it up now if we were to do the average calculation using our formula we can sum up the entire all of our cells which would be quite tedious to do in a calculator but in excel we can recalculate this number the average 71 498 by summing everything up which is our most trusty function and excel the sum function and then we are going to divide that by the number of values meaning we can count the number of values now to not do that manually we can use a count function in excel equals count all of all this cells in this table it comes out to 51 and if we divide that out then we get to our average let's see if I pull out the trusty calculator just to check