00:01
For this problem, we are told that we are a prospective baseball agent in search of clients, and that we would like to recruit the highest paid players as clients.
00:08
So we perform a study in which we identify the 24 top paid players for the 2004 season and their positions.
00:15
So we're first asked to construct a frequency distribution of position.
00:19
So what i've done here is i've gone through and just taken the first letter of each position and wrote them down, and i'll go specifically into how we create that frequency distribution in a second.
00:29
But let's say we have left field, actually i'll type these out fully, left field, third base.
00:38
Actually, i suppose i'll do left field, first base, shortstop, third base, center field, right field.
01:05
And i think that's everything.
01:08
I know nothing about baseball.
01:10
So hopefully i'm not missing anything.
01:13
Then in excel, it will be really easy.
01:17
We can do count if.
01:19
Then we want l through l.
01:22
The criteria.
01:23
Oh, actually, i can do this in an even easier way here.
01:28
I'll put, again, just the first letter of each one of the categories.
01:37
When i've done that, then for using the count if feature or function in excel, we can just select all the, that entire column, and then just select the element two above there.
01:58
So we have l matching, and we want to see, okay, how many ls.
02:02
The point of having the lfstpcr up there is that now i can just drag across and each cell will automatically grab the one up above.
02:14
Oh, there is one thing that's getting messed up.
02:18
When i drag from left to right, it is, that's a range is also getting messed up, but it'll, we can make them all look at the same range by putting dollar signs in front of the column specification there.
02:34
Now this should work.
02:36
There we go...