Thread: Using Frequency Function

Hi all,

I am working on excel 2007 with large data.
The data is in floating point format and also contains both negative and positive values.
I have to develop a frequency distribution table for this data. I have used the FREQUENCY() function in the excel, but not getting the exact result.

Can Any1 help me to solve this issue;

I have caluclated few things;
total observation: 457
No of classes : 9
highest value: 7.69
lowest value: -5.59
class width: 1.50
Bins_data: -4.09, -2.59, -1.09, 0.39, 1.89, 3.39, 4.89, 6.39, 7.89

data_array

0.00
0.17
-1.59
-0.18
0.66
-0.88
-1.14
1.41
-0.58
-1.67
4.42
-1.54
-1.73
-4.96
2.69
1.41
0.94
-4.13
-3.63
1.39
0.58
1.72
-3.60
1.78
-0.69
1.07
-0.55
1.82
0.86
1.51
-0.42
0.19
-0.62
-0.62
-1.68
1.83
0.67
1.30
2.14
-0.07
0.23
0.66
3.91
0.06
1.80
0.82
0.29
0.49
-1.22
0.27
-0.15
0.24
-1.07
1.12
1.61
0.44
-1.19
1.88
0.65
1.49
-0.36
0.41
1.07
0.44
0.44
-0.27
0.77
0.21
0.06
1.34
1.31
-0.61
-0.13
-1.00
5.98
2.80
1.64
-0.49
-2.77
-0.17
2.69
-2.81
2.01
-2.88
-1.04
-3.80
-4.22
7.69
1.00
2.17
-1.42
-1.76
0.16
-0.73
-1.59
-4.26
1.92
1.83
-0.62
-0.45
3.79
1.39
1.54
1.20
-0.31
-2.72
-1.96
-0.64
-2.46
3.01
1.20
0.30
2.13
2.91
1.73
0.81
-1.42
1.36
-1.05
-0.73
-0.86
0.60
-4.52
-1.81
-1.21
-0.62
0.68
4.04
-0.22
0.59
-0.90
-2.13
0.37
-0.51
-0.62
-1.73
2.57
0.93
1.88
0.36
-0.25
1.85
-1.18
-1.09
-0.33
1.79
0.03
0.40
-0.49
-0.62
0.64
-0.89
-3.55
0.64
-1.07
-0.59
1.75
0.44
-1.26
-0.10
-1.54
-2.39
1.23
-1.07
0.56
0.36
0.25
2.97
0.74
2.62
-0.37
1.98
0.06
0.13
1.38
0.38
0.81
2.35
-0.43
2.85
0.19
1.40
0.41
1.18
-0.40
-1.48
0.18
-1.26
-0.43
-1.37
3.70
0.09
0.01
1.68
0.44
1.08
0.54
0.72
4.11
1.04
-2.68
0.34
-0.33
-0.66
0.45
-0.26
-0.07
-0.84
-1.40
1.06
1.70
1.11
1.75
-0.36
0.47
-0.80
0.62
-0.43
-2.72
-0.32
-1.78
-0.36
2.64
-0.55
2.16
-1.48
1.97
0.06
0.59
-1.81
1.69
0.55
-0.22
0.85
-0.61
0.88
-0.39
0.25
0.35
-0.43
0.02
0.28
-0.20
0.50
0.62
0.30
-0.48
0.33
0.24
-0.06
-0.50
-0.34
2.17
0.52
0.82
-0.08
0.72
1.88
-0.24
0.81
0.37
0.81
-2.25
-0.53
-1.82
-1.79
3.28
1.17
0.72
-0.19
-2.07
0.96
1.68
-0.21
-0.26
0.89
1.55
0.94
0.83
-1.01
0.65
0.65
0.20
0.90
-1.33
-2.16
-3.41
1.18
0.08
1.54
1.45
-1.10
0.80
2.11
0.12
-1.29
0.11
-0.92
-1.65
1.53
0.45
-2.30
-4.46
1.40
-1.19
2.61
0.56
-0.59
1.70
1.90
-0.31
0.15
-0.66
-0.03
-1.13
-0.98
-0.67
-0.25
0.01
-0.89
-1.27
0.48
1.12
-1.10
-1.49
1.34
1.81
1.35
2.42
0.66
-0.73
-0.08
-0.97
0.97
-1.10
0.55
0.39
-0.81
-0.03
0.27
0.53
-0.64
-0.19
-1.75
-2.11
0.85
1.11
0.19
-1.56
-0.24
-0.66
1.38
-0.53
0.72
3.09
-0.67
0.17
-0.77
-1.57
-1.77
0.06
-0.23
-1.69
0.21
1.79
-1.71
-0.49
-1.51
-1.54
3.17
-0.83
2.67
-1.47
1.74
0.97
-0.36
0.49
2.26
1.80
0.67
1.55
0.70
-1.59
-0.07
1.21
-0.07
2.00
2.43
0.82
2.67
0.10
1.55
1.32
1.23
-2.68
-0.20
-0.34
1.61
-1.98
0.94
-3.87
-0.99
-5.46
5.89
-2.76
2.75
0.88
1.70
-0.76
-0.01
-3.78
-2.74
0.12
4.81
0.69
-0.65
2.64
1.67
0.01
-1.32
-0.99
-1.83
1.52
1.10
0.05
-1.73
0.65
1.23
1.22
0.94
1.92
2.78
0.44
-0.32
-2.50
0.62
-0.28
-0.97
-0.56
-1.62
-2.37
-1.76
-0.56
1.54
-0.23
-2.01
5.14
2.95
0.47
1.55
3.32
-0.48
0.54
-5.59
-0.83
-0.62
3.28


Your help appreciated.

Thanks,
Saleem