If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Histogram
Histogram range? if the bin goes as follows: 0, 5, 10, 15 how does excel
count that? is the 5 really 2.5 - 7.5? or is it anything between 0 and 10? This is really urgent!!! |
#2
|
|||
|
|||
A quick way to learn something like this is to make a small set of data
and test it. That's how I discovered your answer. The number returned for a bin is the number of values greater than the previous bin and less than or equal to the current bin (so for bin 5, it counts values 0 to =5). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ B. Scheiring wrote: Histogram range? if the bin goes as follows: 0, 5, 10, 15 how does excel count that? is the 5 really 2.5 - 7.5? or is it anything between 0 and 10? This is really urgent!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
trouble with histogram use | Beth_gis | General Discussion | 1 | August 14th, 2004 04:49 AM |
histogram to radar chart | David | Charts and Charting | 1 | May 8th, 2004 01:51 AM |
Help creating a Histogram | Jakkov | Charts and Charting | 2 | April 5th, 2004 02:10 PM |