View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jake Jake is offline
external usenet poster
 
Posts: 83
Default histogram is counting input data wrong

The histogram analysis is automatically grouping fish lengths into the next
larger bin-class (For example: 20 is considered part of the 20-bin; 21 and
24 are included in the 30 bin). From what I understand it is supposed to
group into the bin of equal or greater size, up to the next bin-class.

Ex. Fish Lengths (20 cm, 21, 24, 30, 32, 40)

Bin is (20, 30, 40, 50)

What it is doing: Frequencies (20 is 1; 30 is 3; 40 is 2, and 50 is 0)
What it should be doing: Freqs (20 is 3; 30 is 2; 40 is 1; and 50 is 0)

Please help!