Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
How to create a histogram that updates when I filter the input ran | Excel Worksheet Functions | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel | |||
histogram, wrong input range | Excel Discussion (Misc queries) |