-
Title:
SD Social Networkers - Intro to Descriptive Statistics
-
Description:
-
>> I'm going to show you the answer to this, by doing it in a spreadsheet. You
-
could do all of these calculations, without any technology. And if you did that,
-
that's really great. It's always really good practice to calculate things
-
without using any technology, but just for the purposes of figuring out the
-
standard deviation, technology can really speed along this process. So I'm not
-
going to use any shortcuts here. We're going to do it exactly as we would if we
-
didn't have technology. So first we need to take the avearage of all of these,
-
we're going to sum them up. So we're taking the sume of all of these. I could
-
also just write equals a1 plus a2 plus a3 all the way to a10. And we'd get the
-
same thing. But why would we do that if we can simply write this. Now to take
-
the average all we do is divide by the number of values which is 10. So that's
-
just going to be 51,511.1. Alternatively, the nice thing about technology is we
-
can just do this. Take the sum, and divide by the total number. Do it all in 1
-
step. So now we have the average. Now we're going to subtract the average from
-
each 1 of these values. Not the opposite, where we subtract each of these values
-
from the mean. That's an important distinction. In this case, it doesn't matter
-
as much but in other statistical concepts that's an important distinction to
-
make. So we'll write equals A1 minus. The mean. So I'm subtracting the mean from
-
each of these values. Now I could just do the same thing here and write equals
-
a2 minus the mean but that would be tedious. We can just drag this down. When
-
you do that, remember that there has to be a little plus sign there. That means
-
you're successfully dragging it down. If you went like this, it won't do
-
anything. It'll just highlight the boxes. So here, we have the deviations from
-
the mean. Here, in the next column We're going to square each deviation. Equals
-
b1 squared. And again, we're going to drag it down. So we have the squared
-
deviations for each of these values. Now remember that the variance is the
-
average squared deviation. So we could just write. Average of c1 to c10. But I
-
want to make sure we go through all the other steps in between. So let's again
-
practice calculating the average just for clarity's sake. So the variants then
-
would be the sum of c1 to c10. Remember that's how you start out taking the
-
average, and then divide by 10. So here's the variance, and then the standard
-
deviation is simply the square root of the variance. So we'll write equals SQRT.
-
That's the shortcut for square root. And then we can just see C13. So we know
-
that the standard deviation is 6557.16 approximately. Now I want to point out
-
something really important before we finish this solution video. Here I simply
-
said equals square root of this cell C13. Whereas here, I wrote out the
-
whole average. The reason for that is because say I had but this all here, A13.
-
Then, when we drag it down, we don't get the right deviations. And we can double
-
click on it, and see what it did. Here, it took A4 minus A16, whereas here it
-
took A1 minus A13, which is what we wanted. But we want it to always stay A13,
-
which is why we have to make sure this is a constant. And the way to make sure
-
it's a constant is by just writing it. Notice also that all of these values
-
changed when these values changed because all these values are dependent of
-
these values So when we change it back we should again get the correct standard
-
deviation.