Class Intervals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'd appreciate any information on how to split a column of data in Class Intervals. For example, if I have a column of data in time like:

22:52
4:29
19:36
0:02
5:24
3:04
3:33
6:19

I wanted to know if they can be categorized as lying between 0:01-0:30, 0:31-1:00, and so on. On trying to perform Histogram analysis and entering this class interval as the bin range, I receive a message saying that the bin should not have non-numeric values.

Thanks for any help!

ST
 
Hi ST

for the class array you only enter the upper (included) bound of each
class. So in your example your class array should look like
0:30
1:00
1:30

This used with the formula FREQUENCY will return an array of 4 values
1. values <=0:30
2. values >0:30 and <=1:00
3. values >1:00 and <=1:30
4. values > 1:30

Frank
 
Back
Top