Class Intervals

F

Failed to Excel

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
 
F

Frank Kabel

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
 
Top