00:01
All right, so we are given some data, and the data is about the number of customers worked with at an auto body shop over a period of days.
00:10
And i took the data and put it into a spreadsheet and sorted it and put it into a column so it's easier to work with.
00:18
And then we're asked to determine whether the data could have come from a population that's normally distributed.
00:25
And so then the way we do that is to use this function.
00:31
But to use this function, we have to do something with our data, which is sort it and order it, which is what i did here, and then give it an index, which is the position in our list.
00:41
In this case, here's one, two, three, four, blah, blah, blah, all the way down to 25.
00:45
And then what we do, we want to make a normal probability plot, so we need to get some z scores from this data.
00:54
So how we do that is we take the index of the observed value, some index, one, two, three, all the way down the line.
01:03
Take the index minus .375 and divide that by n, which is how many observations there are, or data points there are, plus .25.
01:13
And that's going to give us what would be the area underneath the normal curve up to what would be the expected, where we'd expect that value.
01:23
So what that means is, do we flare like that.
01:30
There's our curve, normal distribution curve.
01:34
And so when we use this function on the data, so i just copied and pasted the formula all the way down the dataset, took that index minus .375 divided by 25 items plus .25 did that...