Excel Histogram -- Incorrect Bins

  • Thread starter Thread starter Eric Anderson
  • Start date Start date
E

Eric Anderson

I am using the Histogram tool in Excel 2004 for Mac -- I am finding that
Excel is shifting all my data one bin to the right.

For example, with data...

2,2,2,7,7,7

and bin range selected as 0,5,10

I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in bin
5 (between five and ten).

Excel is RETURNING a histogram with nothing in the zero bin, and 3 items
each in the 5 bin and the 10 bin.

This is driving my bonkers! I can't find a solution...can somebody please
help?
 
Eric Anderson -
I am using the Histogram tool in Excel 2004 for Mac -- I am finding that
Excel is shifting all my data one bin to the right.
Click to expand...
For example, with data...
2,2,2,7,7,7
and bin range selected as 0,5,10
I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in bin 5
(between five and ten).
Excel is RETURNING a histogram with nothing in the zero bin, and 3 items
each in the 5 bin and the 10 bin.
This is driving my bonkers! I can't find a solution...can somebody please
help? <

An Excel "bin" is the inclusive upper bound for a interval.

That is, your bin value 5 has the corresponding frequency for values
strictly greater than 0 and less than or equal to 5.

- Mike Middleton

www.mikemiddleton.com
 
Back
Top