Histogram problem,,,

[febausa]

[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>

 

[oldbrewer]

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

 

[shg]

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]

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

 

[febausa]

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]

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]

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]

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