# Histogram problem,,,

#### febausa

##### New Member
[h=1]I need help. the number 9 with frequency 0 is false . The "number more" 18, I don't understand? What means this?[/h]

 Number Frequency 1 13 2 13 3 12 4 10 5 12 6 11 7 22 8 20 9 0 10 17 11 19 12 12 13 15 14 15 15 10 16 9 17 17 18 15 19 11 20 8 21 11 22 10 23 12 24 10 25 16 26 7 27 14 28 17 29 13 30 12 31 12 32 13 33 13 34 15 35 14 36 11 37 17 38 18 39 11 40 13 41 14 42 6 43 14 44 10 45 13 46 15 47 11 48 14 49 9 50 8 51 11 52 12 53 20 54 13 55 16 56 16 57 9 58 21 59 10 More 18

<tbody style="border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased;">
</tbody>

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### oldbrewer

##### Well-known Member
I assume the frequencies are calculated - how are you calculating them eg countif(A1:A10000,9)

#### shg

##### MrExcel MVP
I need help. the number 9 with frequency 0 is false .
It means that there are no numbers in the list that are >8 (the next lower value) and <=9

I need help. the number 9 with frequency 0 is false . The "number more" 18, I don't understand? What means this?
It counts values that are >59.

#### oldbrewer

##### Well-known Member
It counts values that are >59. shg - is this because there is a limit on the number of bins?

#### febausa

##### New Member

ADVERTISEMENT

The frequencies was calculated with the data analysis, analysis tools (histogram). data not smallest than 1 or greater than 59.

Thank you for your help.

#### febausa

##### New Member
The frequencies was calculated with the data analysis, analysis tools (histogram). data not smallest than 1 or greater than 59.

Thank you for your help.

#### shg

##### MrExcel MVP
It counts values that are >59. shg - is this because there is a limit on the number of bins?
No; FREQUENCY returns an array one longer than the Bins array. The last element counts the number of values larger than the largest bin.

#### oldbrewer

##### Well-known Member
I learn something every day on here and it is great - many thanks shg.

Replies
1
Views
48
Replies
2
Views
134
Replies
0
Views
86
Replies
1
Views
53
Replies
3
Views
62

Threads
1,136,644
Messages
5,676,967
Members
419,665
Latest member
allsmilees2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back