Histogram Actual Results Do Not Match Expected Results - Why?

1. I am working on histograms and have the following data in cells D2:D26 (these are calculated values):-


























The above is:-

1 lot of 14

3 lots of 15

4 lots of 16

4 lots of 17

3 lots of 18

5 lots of 19

3 lots of 20

2 lots of 21

Total number of lots 25.

2. In cells G2:G5 I have the following bins:-





3. If I set up a histogram my expected results are:-

Bin 5 Frequency 0

Bin 10 Frequency 1

Bin 15 Frequency 19

Bin 20 Frequency 5

4. The actual results are:-

Bin 5 Frequency 0

Bin 10 Frequency 0

Bin 15 Frequency 2

Bin 20 Frequency 19

More 4

Why do the actual results not match the expected results?

Thanks in advance for any replies.


I get this:

Bin Frequency
5 0
10 0
15 4
20 19
More 2

The frequency for 15 is the number of entries >10 and <=15, i.e. 1+3=4

The frequency for 20 is the number of entries >15 and <=20, i.e. 4+4+3+5+3=19

The frequency for More is the number of entries >20, i.e. 2

Hans, thanks for the reply.

You don't say which version you have tested in.

Why don't my results agree with yours? shouldn't they be the same?

Great inter-Guru challenge.


Don't get it.


I have re-tested this today and EXCEL seems to be shunting everything down 1 bin.

I tested in Excel 2010 SP1.

The results of using Histogram from the Analysis ToolPak add-in correspond exactly to those of the FREQUENCY function with the same data and bins, and to the description in the Excel help of how the bins work in both Histogram and FREQUENCY.

I have no idea why you get different results.

Category:Office Time:2013-10-24 Views:0

Related post

  • Actual Result Does Not Match Expected Result - Why Not? 2014-11-12

    I have a Workbook with the following:- 1. In a Worksheet called:- Purchase_my_version -at cell:- E13 =SUM(E5:E12) This produces a correct result of:- 1,062,551.06 2. In the same Worksheet at cell:- N13 - I type in an amount of:- 1,062,551.06 3. Still

  • number of php query results does not match terminal results from Oracle's Toad 2011-06-01

    I got the fix but I need the explanation why and leaving this as a references for other people: The Problem is we got this view, say A, that is built upon another view B. If you do a select * from view A, you get say 37 records. Great, now if you run

  • Why doesn't String.match() produce expected results when a global flag is present? 2013-07-28

    This question already has an answer here: JavaScript regular expressions and sub-matches 1 answer I was trying this match '/links/51f5382e7b7993e335000015'.match(/^\/links\/([0-9a-f]{24})$/g) and got: ['/links/51f5382e7b7993e335000015'] while I was e

  • XSLT apply-template with mode - Incorrect result with no matching mode 2010-08-26

    Here's a simple case. Here's my XML: <?xml version="1.0" encoding="utf-8" ?> <dogs> <dog type="Labrador"> <Name>Doggy</Name> </dog> <dog type="Batard"> <Name>Unknown</Name> </dog> </dogs

  • Look Around does not deliver expected result with .net 2010-10-19

    I want to use a look-ahead regex for replacement with the System.Text.RegularExpression.Replace(...) method. Now I am wondering what's wrong. Look at this example code: string input = "stackoverflow"; string replacement = "#"; var pattern1 = "(?=[a-z

  • preg_match not returning expected results 2010-11-15

    I'm attempting to use regexp to parse a search string that from time to time may contain special syntax. The syntax im looking for is [special keyword : value] and i want each match put into an array. Keep in mind that the search string will contain

  • C# Unit Testing: Why must the expected result be included in the test name? 2010-11-23

    If the expected result of the method being tested exists in the official documentation of the method, then indicating the expected result in the test names would be redundant. In fact, if the purpose is to document the method, then the documentation

  • Not getting expected results with RLIKE in MySQL 2011-01-20

    I'm using the next query: SELECT id,module,pk,label,value FROM traducciones WHERE module='paginas' AND label='slug' AND value RLIKE '(tests)(-\d+)?' The expected result will be only select: tests tests-1 tests-2 tests-N The problem is that I'm gettin

  • Query not returning expected results 2011-09-02

    I'm trying to select all my areas and join the deals for those areas... this query is returning 0 results when I have verified that I have data to match what I'm expecting to get... does anyone see anything obviously wrong? SELECT deal.*, area.id AS

Copyright (C) pcaskme.com, All Rights Reserved.

processed in 0.348 (s). 13 q(s)