00:01
Okay, in this question, we're given the percentage of adults who have completed high school in all the 50 states in d .c.
00:09
Very interesting.
00:10
I wonder where your state compares, huh? so, and you might stop and scratch your head and go, i see all those words there.
00:18
Is this quantitative data? can i do a range in standard deviation on this? but yes, yes, you can because you don't actually need to know those names of the same.
00:30
States we're not sorting by that by those words they could have just given you that list of numbers that's really all we're interested in we don't really care which state they go to we're just curious about all these numbers describing graduation rates in america okay so we can calculate the range of standard deviation i'm using excel you might be using something different but it is difficult to import these large data sets into a lot of other software or online statistical calculators.
01:07
So you may find that a spreadsheet is the easiest.
01:10
In excel, there is no range command because they'd use the word range in excel to describe, you know, like this, we would call this b2 to b9.
01:24
And we say that the range of values, okay? so they don't have a formula with that name, so it's cause no confusion.
01:30
So we're going to type in the formula.
01:32
We want this equal the max minus the min.
01:35
That's how we find the range, right? so i do the max, and instead of actually typing in the range and saying i want, or, you know, the ring the values of b2 to goodness gracious, i'd have to scroll to the bottom to find out how much data there is.
01:49
Excel allows you do a little shortcut to say, i want all the numbers in that column, please, okay? and it's smart enough to know to leave out the word, okay? so there's a different command if you want to include the word.
01:58
So max minus men, right? same thing, all that column.
02:04
And there's my range of values.
02:07
Interesting.
02:07
So not too huge.
02:09
You know, not like a 50 % difference between the state with the highest graduation rate and the state with the lowest graduation.
02:16
There's less than 20, less than 15.
02:18
Interesting...