Frequency calculation issue

[ssubhash]

I pasted sample data below. I am using Histogram in Data Analysis section. The frequency count it shows is incorrect. Reports most values at 1.00 even though there are only a few between 0.75 and 1. Why is this hapening and how do I fix this issue? Total records are only 482 but freq shows twice as many

 

[AhoyNC]

This is what I get using your data.

Book1
	A	B	C	D	E	F	G
1	Score	Bin
2	0.486534	0		Bin	Frequency	Cumulative %
3	0.622	0.25		0	0	0.00%
4	0.634733	0.5		0.25	0	0.00%
5	0.63806	0.75		0.5	1	2.86%
6	0.6982	1		0.75	6	20.00%
7	0.722726	1.25		1	6	37.14%
8	0.749067	1.5		1.25	4	48.57%
9	0.818695	1.75		1.5	12	82.86%
10	0.833867	2		1.75	6	100.00%
11	0.840318	2.25		2	0	100.00%
12	0.851933	2.5		2.25	0	100.00%
13	0.883591	2.75		2.5	0	100.00%
14	0.917143	3		2.75	0	100.00%
15	1.039082	3.25		3	0	100.00%
16	1.081648	3.5		3.25	0	100.00%
17	1.171372	3.75		3.5	0	100.00%
18	1.214482	4		3.75	0	100.00%
19	1.252097	4.25		4	0	100.00%
20	1.301547	4.5		4.25	0	100.00%
21	1.30768	4.75		4.5	0	100.00%
22	1.325665	5		4.75	0	100.00%
23	1.383458			5	0	100.00%
24	1.40064			More	0	100.00%
25	1.442114
26	1.451165
27	1.470798
28	1.477916
29	1.48825
30	1.499764
31	1.56631
32	1.577756
33	1.591934
34	1.59353
35	1.629752
36	1.633186
37
Sheet4

 

[ssubhash]

This is what I get using your data.
View attachment 103926

Book1
	A	B	C	D	E	F	G
1	Score	Bin
2	0.486534	0		Bin	Frequency	Cumulative %
3	0.622	0.25		0	0	0.00%
4	0.634733	0.5		0.25	0	0.00%
5	0.63806	0.75		0.5	1	2.86%
6	0.6982	1		0.75	6	20.00%
7	0.722726	1.25		1	6	37.14%
8	0.749067	1.5		1.25	4	48.57%
9	0.818695	1.75		1.5	12	82.86%
10	0.833867	2		1.75	6	100.00%
11	0.840318	2.25		2	0	100.00%
12	0.851933	2.5		2.25	0	100.00%
13	0.883591	2.75		2.5	0	100.00%
14	0.917143	3		2.75	0	100.00%
15	1.039082	3.25		3	0	100.00%
16	1.081648	3.5		3.25	0	100.00%
17	1.171372	3.75		3.5	0	100.00%
18	1.214482	4		3.75	0	100.00%
19	1.252097	4.25		4	0	100.00%
20	1.301547	4.5		4.25	0	100.00%
21	1.30768	4.75		4.5	0	100.00%
22	1.325665	5		4.75	0	100.00%
23	1.383458			5	0	100.00%
24	1.40064			More	0	100.00%
25	1.442114
26	1.451165
27	1.470798
28	1.477916
29	1.48825
30	1.499764
31	1.56631
32	1.577756
33	1.591934
34	1.59353
35	1.629752
36	1.633186
37
Sheet4

interesting, may be something wrong with how data is getting into Excel. Will try saving into csv and try again. thank you for responding