00:01
For this problem, i'll show how to do all of this in excel.
00:03
The first part is just copying everything into excel.
00:06
Then i'll go to data, text to columns, delimited, where we want the delimiter to be a space.
00:15
Now we have everything separated out into their own individual cells.
00:20
So what i'll do next is just to make this data easy to work with.
00:26
I'll select that.
00:28
Then it's down to the second element here and paste the data transposed.
00:36
So now it is a column rather than a row.
00:40
And then i'm going to select everything in that first row, delete it and put just data as my first row element.
00:50
It seems like that one there was a little bit messed up, but there, now we fixed it.
00:55
So now that i have my data, i'll select all of it and go to, let's see here, insert, pivot table, make a new one.
01:05
And i drag my data down to both rows and values.
01:09
Then i click on the sum of data there, value field settings, and change that to count.
01:14
So now we have the count of how many times each thing occurred.
01:18
Then i'll go to group.
01:21
We want to start at negative 10 and at 37.
01:24
Sure, we're going up by tens.
01:26
And so now, okay, so i'll...
01:30
Note that the the way that the classes are designated here are slightly different than what you're asked for in the problem.
01:40
So what i'll be doing is just keeping the frequencies, then writing the classes as requested for the problem...