00:02
Different problems so i'm going to do number two and number three so number two is about the price of an ordinary 25 piece shares of mancoe plc quoted on the stock exchange at the close of the business on successive fridays is tabulated below so it is these numbers that are here and it what it wanted you to do is make a box plot.
00:30
So if i highlight all the numbers, then i'm in excel, and i click box and whiskers.
00:39
And so, let me just, i'm going to make this a little bit bigger, so it's easier to see.
00:48
And so it starts at a little above 140.
00:53
And so my number, my highest number, and i'm just going to just going, and i'm through the list is 142 and my lowest number appears to be a little bit over 100 which is approximately 111 and so 105 sorry 105 is my lowest number and then my highest number again is 142 as you can see and so so as far as an outlier goes, i do not believe that there is an outlier.
01:37
If you look at the distribution of this, it's pretty even.
01:40
So there is no outliers.
01:47
And so i'm just going to write this for number one.
01:51
We drew the box plot.
01:54
And there is no outlier.
01:58
And i'm going to make this a little bit bigger so that you can see.
02:04
Okay.
02:06
And make my words a little bit bigger.
02:08
There we go.
02:09
So there is no outlier.
02:11
And number two, without the outlier, if any, calculate the mean and the standard deviation.
02:18
So to get the mean of this data is, so for the mean of the data, i'm going to highlight all of the numbers.
02:29
And i'm going to go to average.
02:35
And actually, nope, it should be the 124, but i want to put it over here.
02:43
Here.
02:45
So auto sum average.
02:48
Here we go...
