I used the Frequency function to analyze a set of real values with one
decimal place.
I think that the Frequency function was applied properly with the
Ctl+Shift+Enter, but there is a problem with the results:

Values Xj Frequency
96.3 96.3 1
96.4 96.4 0
96.7 96.7 3
96.7 96.8 1
96.8 96.9 0
96.9 97.0 1
97.0 97.1 1
97.1 97.2 3
97.1 97.3 3
97.1 97.4 1
97.2 97.5 5
97.2 97.6 2
97.2 97.7 4
97.3 97.8 3
97.4 97.9 7
97.4 98.0 5
97.4 98.1 11
97.4 98.2 3
97.4 98.3 10
97.5 98.4 5
97.5 98.5 9
97.6 98.6 3
97.6 98.7 10
97.6 98.8 8
97.6 98.9 10
97.7 99.0 2
97.7 99.1 5
97.7 99.2 3
97.8 99.3 3
97.8 99.4 2
97.8 99.5 2
97.8 99.9 2
97.8 100.0 1
97.8 100.8 1
97.8
97.9
97.9
97.9
97.9
97.9
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.1
98.1
98.1
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.3
98.3
98.3
98.3
98.3
98.4
98.4
98.4
98.4
98.4
98.4
98.4
98.4
98.4
98.5
98.5
98.5
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.7
98.7
98.7
98.7
98.7
98.7
98.7
98.7
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.9
98.9
99.0
99.0
99.0
99.0
99.0
99.1
99.1
99.1
99.2
99.2
99.2
99.3
99.3
99.4
99.4
99.5
99.9
100.0
100.8

Any help please.

Thanks,

Amar

assuming your data range A1:A131 header in row1
bin range B1:B35 header in row 1

Select C2:C35 then enter the formula below

=FREQUENCY(A2:A131,B2:B35)

ctrl+shift+enter, not just enter


"Amar" wrote:

I used the Frequency function to analyze a set of real values with one
decimal place.
I think that the Frequency function was applied properly with the
Ctl+Shift+Enter, but there is a problem with the results:

Values Xj Frequency
96.3 96.3 1
96.4 96.4 0
96.7 96.7 3
96.7 96.8 1
96.8 96.9 0
96.9 97.0 1
97.0 97.1 1
97.1 97.2 3
97.1 97.3 3
97.1 97.4 1
97.2 97.5 5
97.2 97.6 2
97.2 97.7 4
97.3 97.8 3
97.4 97.9 7
97.4 98.0 5
97.4 98.1 11
97.4 98.2 3
97.4 98.3 10
97.5 98.4 5
97.5 98.5 9
97.6 98.6 3
97.6 98.7 10
97.6 98.8 8
97.6 98.9 10
97.7 99.0 2
97.7 99.1 5
97.7 99.2 3
97.8 99.3 3
97.8 99.4 2
97.8 99.5 2
97.8 99.9 2
97.8 100.0 1
97.8 100.8 1
97.8
97.9
97.9
97.9
97.9
97.9
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.0
98.1
98.1
98.1
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.2
98.3
98.3
98.3
98.3
98.3
98.4
98.4
98.4
98.4
98.4
98.4
98.4
98.4
98.4
98.5
98.5
98.5
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.6
98.7
98.7
98.7
98.7
98.7
98.7
98.7
98.7
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.8
98.9
98.9
99.0
99.0
99.0
99.0
99.0
99.1
99.1
99.1
99.2
99.2
99.2
99.3
99.3
99.4
99.4
99.5
99.9
100.0
100.8

Any help please.

Thanks,

Amar