00:01
In this problem, 29, we're going to be answering the question, which position in baseball pays the most? so you're supposed to think of yourself as a prospective baseball agent and you're looking for clients.
00:17
So you'd want to recruit the highest paid players as your clients.
00:22
So you're going to use this data to perform a study and identify which top paid players.
00:30
To pick, which positions to pick.
00:34
So you have a list of 24 top paid players for the 2004 season and their positions.
00:41
So we're going to use this to make that decision.
00:46
So first, we need to construct a frequency distribution of position.
00:54
So we only interested in the positions of the players and not the names of the players.
01:01
So we select the column for positions and we want also to make a summary of how many of each position do we have.
01:12
So we go to the insert tab and then select the pivot table and we have to ensure that column c is selected and then where to put the pivot table.
01:28
We can pick one of the cells here and then click okay.
01:34
So let's redo that.
01:36
For the table range, you select the whole column.
01:42
And for where to put the worksheet or the summary of the pivot table, we select one cell there and then we click okay.
02:22
Now, since we have the field for position, we need to drag it.
02:29
To the rows section and also drag it to the totals section.
02:36
Now we have a list or a summary showing the different positions and the frequencies for each of these positions.
02:44
So we look like that and paste it on the side so that we can use it.
02:49
So the first column is named position and column is named freepointee.
03:07
Next, we want to get the first column.
03:09
The relative frequency distribution...
