A Statistics Project

profileCallini47
frequency_distribution.xls
Home>Mathematics homework help>A Statistics Project

Frequency Distribution

Observation # Data Range Freq
Observation 1 3.15 Lower Upper Relative Cumulative Cum. Rel. 1.5 ~ 2 0.16
Observation 2 2.66 Limit Limit Frequency Frequency Frequency Frequency Data Data 2 ~ 2.5 0.32
Observation 3 3.95 1.5 < X < 2 4 16.0% 4 16.0% 0 >=1.5 <2 4 2.5 ~ 3 0.24
Observation 4 2.35 2 < X < 2.5 8 32.0% 12 48.0% 0 Data Data 3 ~ 3.5 0.16
Observation 5 1.76 2.5 < X < 3 6 24.0% 18 72.0% 0 >=2 <2.5 8 3.5 ~ 4 0.12
Observation 6 1.99 3 < X < 3.5 4 16.0% 22 88.0% 0 Data Data 0 0
Observation 7 2.22 3.5 < X < 4 3 12.0% 25 100.0% >=2.5 <3 6 0 0
Observation 8 3.76 < X < 0 0.0% 0 0.0% Data Data 0 0
Observation 9 2.87 < X < 0 0.0% 0 0.0% >=3 <3.5 4 0 0
Observation 10 2.85 < X < 0 0.0% 0 0.0% Data Data 0 0
Observation 11 2.55 < X < 0 0.0% 0 0.0% >=3.5 <4 3
Observation 12 2.31 < X < 0 0.0% 0 0.0% Data Data
Observation 13 1.59 25 100% >= < 0
Observation 14 2 sample size Data Data
Observation 15 2.43 >= < 0
Observation 16 3 Data Data
Observation 17 3.99 >= < 0
Observation 18 2.53 Data Data
Observation 19 1.85 >= < 0
Observation 20 2.15 Data Data
Observation 21 2.4 >= < 0
Observation 22 3.04
Observation 23 3.23
Observation 24 2.12
Observation 25 2.93
Observation 26
Observation 27
Observation 28
Observation 29
Observation 30
Observation 31
Observation 32
Observation 33 ©2007 DrJimMirabella.com
Observation 34
Observation 35
Observation 36
Observation 37
Observation 38
Observation 39
Observation 40
Observation 41
Observation 42
Observation 43
Observation 44
Observation 45
Observation 46
Observation 47
Observation 48
Observation 49
Observation 50
Observation 51
Observation 52
Observation 53
Observation 54
Observation 55
Observation 56
Observation 57
Observation 58
Observation 59
Observation 60
Observation 61
Observation 62
Observation 63
Observation 64
Observation 65
Observation 66
Observation 67
Observation 68
Observation 69
Observation 70
Observation 71
Observation 72
Observation 73
Observation 74
Observation 75
Observation 76
Observation 77
Observation 78
Observation 79
Observation 80
Observation 81
Observation 82
Observation 83
Observation 84
Observation 85
Observation 86
Observation 87
Observation 88
Observation 89
Observation 90
Observation 91
Observation 92
Observation 93
Observation 94
Observation 95
Observation 96
Observation 97
Observation 98
Observation 99
Observation 100
Observation 101
Observation 102
Observation 103
Observation 104
Observation 105
Observation 106
Observation 107
Observation 108
Observation 109
Observation 110
Observation 111
Observation 112
Observation 113
Observation 114
Observation 115
Observation 116
Observation 117
Observation 118
Observation 119
Observation 120
Observation 121
Observation 122
Observation 123
Observation 124
Observation 125
Observation 126
Observation 127
Observation 128
Observation 129
Observation 130
Observation 131
Observation 132
Observation 133
Observation 134
Observation 135
Observation 136
Observation 137
Observation 138
Observation 139
Observation 140
Observation 141
Observation 142
Observation 143
Observation 144
Observation 145
Observation 146
Observation 147
Observation 148
Observation 149
Observation 150
Observation 151
Observation 152
Observation 153
Observation 154
Observation 155
Observation 156
Observation 157
Observation 158
Observation 159
Observation 160
Observation 161
Observation 162
Observation 163
Observation 164
Observation 165
Observation 166
Observation 167
Observation 168
Observation 169
Observation 170
Observation 171
Observation 172
Observation 173
Observation 174
Observation 175
Observation 176
Observation 177
Observation 178
Observation 179
Observation 180
Observation 181
Observation 182
Observation 183
Observation 184
Observation 185
Observation 186
Observation 187
Observation 188
Observation 189
Observation 190
Observation 191
Observation 192
Observation 193
Observation 194
Observation 195
Observation 196
Observation 197
Observation 198
Observation 199
Observation 200
&A

Frequency Distribution
Freq
Histogram
Also known as "n"
Input the data values in this column. There is no need to sort the data.
Here you can enter identifiers for each observation, such as names or ids. This column is not tabulated in the results.
These are the lower limits of each range in which to tabulate frequencies. Values must be greater than or equal to this value to be counted here. The lower limit of each row should equal the upper limit of the prior row so there are no gaps and no overlaps. The first row should be low enough to capture the smallest value in the data set.
These are the upper limits of each range in which to tabulate frequencies. Values must be less than this value to be counted here. The differences from lower to upper limit of each row should be equal (although exceptions can be made in the first and last row to capture extreme values). The first row should be high enough to capture the largest value in the data set.
The FREQUENCY is the total occurrences of values in the data set that are between the lower and upper limits.
The RELATIVE FREQUENCY is the % of the data set in which the values in the chosen range appear. It is computed as the Frequency divided by the sample size.
This is the sample size (i.e., the number of values in the data set). If it doesn't match with the total in the data set, then some values were not included in this table and should be added or some were included more than once because of overlapping intervals capturing the same values.
The CUMULATIVE FREQUENCY tells you how many observations are in this range or lower. It is computed by adding the frequency totals of this row and all prior rows.
The CUMULATIVE RELATIVE FREQUENCY tells you the percent of total observations are in this range or lower. It is computed by adding the relative frequency totals of this row and all prior rows or by dividing this row's cumulative frequency by the sample size.