00:01
So for this problem, what i'm going to do is show how to format the frequency distribution that we're looking for here in excel really quickly and easily.
00:09
So the first thing that i've done is i've copied all of the data down into excel just by hand, unfortunately.
00:15
Now i'm going to select my data.
00:20
Go to insert, pivot table, put it on a new worksheet.
00:25
Now i have my data.
00:27
I am going to drag the data down to both rows and over to.
00:32
To values.
00:35
Now we can see that for the values it's displaying some of data.
00:38
What i'll do instead is go to value field settings.
00:41
We want to count.
00:43
Then we can see that we have way too many bins, so to speak here.
00:47
So i'm going to go to the, or to right click, go to group.
00:52
We want to start at five, that's right, and at 29, and we want our bin width to be five.
00:59
So now we can see we have our bins and and we have our frequencies.
01:06
So i'm just going to copy and paste the data directly...