Saturday, October 22, 2016

Managing data - 2

Frequency tables for variables urbanrate and co2emissions:





Percentage of people in urban areas
urbanrate
Frequency
Percent
Cumulative
Frequency
Cumulative
Percent
Frequency Missing = 10
10.4
1
0.49
1
0.49
12.54
1
0.49
2
0.99
12.98
1
0.49
3
1.48
13.22
1
0.49
4
1.97
14.32
1
0.49
5
2.46
15.1
1
0.49
6
2.96
16.54
1
0.49
7
3.45
17
1
0.49
8
3.94
17.24
1
0.49
9
4.43
17.96
1
0.49
10
4.93
18.34
1
0.49
11
5.42
18.8
1
0.49
12
5.91
19.56
1
0.49
13
6.40
20.72
1
0.49
14
6.90
21.56
1
0.49
15
7.39
21.6
1
0.49
16
7.88
22.54
1
0.49
17
8.37
23
1
0.49
18
8.87
24.04
1
0.49
19
9.36
24.76
1
0.49
20
9.85
24.78
1
0.49
21
10.34
24.94
1
0.49
22
10.84
25.46
1
0.49
23
11.33
25.52
1
0.49
24
11.82
26.46
1
0.49
25
12.32
26.68
1
0.49
26
12.81
27.14
1
0.49
27
13.30
27.3
1
0.49
28
13.79
27.84
2
0.99
30
14.78
28.08
1
0.49
31
15.27
28.38
1
0.49
32
15.76
29.52
1
0.49
33
16.26
29.54
1
0.49
34
16.75
29.84
1
0.49
35
17.24
30.46
1
0.49
36
17.73
30.64
1
0.49
37
18.23
30.84
1
0.49
38
18.72
30.88
1
0.49
39
19.21
32.18
1
0.49
40
19.70
32.32
1
0.49
41
20.20
32.58
1
0.49
42
20.69
33.32
1
0.49
43
21.18
33.96
1
0.49
44
21.67
34.44
1
0.49
45
22.17
34.48
1
0.49
46
22.66
35.42
1
0.49
47
23.15
36.16
1
0.49
48
23.65
36.28
1
0.49
49
24.14
36.52
1
0.49
50
24.63
36.82
1
0.49
51
25.12
36.84
2
0.99
53
26.11
37.34
1
0.49
54
26.60
37.76
1
0.49
55
27.09
37.86
1
0.49
56
27.59
38.58
1
0.49
57
28.08
39.38
1
0.49
58
28.57
39.84
1
0.49
59
29.06
41
1
0.49
60
29.56
41.2
1
0.49
61
30.05
41.42
1
0.49
62
30.54
41.76
1
0.49
63
31.03
42
1
0.49
64
31.53
42.38
1
0.49
65
32.02
42.48
1
0.49
66
32.51
42.72
1
0.49
67
33.00
43.1
1
0.49
68
33.50
43.44
1
0.49
69
33.99
43.84
1
0.49
70
34.48
46.72
1
0.49
71
34.98
46.78
1
0.49
72
35.47
46.84
1
0.49
73
35.96
47.04
1
0.49
74
36.45
47.44
1
0.49
75
36.95
47.88
1
0.49
76
37.44
48.36
1
0.49
77
37.93
48.58
1
0.49
78
38.42
48.6
1
0.49
79
38.92
48.62
1
0.49
80
39.41
48.78
1
0.49
81
39.90
50.02
1
0.49
82
40.39
51.46
1
0.49
83
40.89
51.64
1
0.49
84
41.38
51.7
1
0.49
85
41.87
51.92
1
0.49
86
42.36
52.04
1
0.49
87
42.86
52.36
1
0.49
88
43.35
52.74
1
0.49
89
43.84
53.3
1
0.49
90
44.33
54.22
1
0.49
91
44.83
54.24
1
0.49
92
45.32
54.34
1
0.49
93
45.81
56.02
1
0.49
94
46.31
56.42
1
0.49
95
46.80
56.56
1
0.49
96
47.29
56.7
1
0.49
97
47.78
56.74
1
0.49
98
48.28
56.76
1
0.49
99
48.77
57.18
1
0.49
100
49.26
57.28
1
0.49
101
49.75
57.94
1
0.49
102
50.25
59.46
1
0.49
103
50.74
59.58
1
0.49
104
51.23
59.62
1
0.49
105
51.72
60.14
1
0.49
106
52.22
60.18
1
0.49
107
52.71
60.3
1
0.49
108
53.20
60.56
1
0.49
109
53.69
60.7
1
0.49
110
54.19
60.74
1
0.49
111
54.68
61
1
0.49
112
55.17
61.32
1
0.49
113
55.67
61.34
2
0.99
115
56.65
62.68
1
0.49
116
57.14
63.26
1
0.49
117
57.64
63.3
1
0.49
118
58.13
63.86
1
0.49
119
58.62
64.78
1
0.49
120
59.11
64.92
1
0.49
121
59.61
65.22
1
0.49
122
60.10
65.58
2
0.99
124
61.08
66.48
1
0.49
125
61.58
66.5
1
0.49
126
62.07
66.6
1
0.49
127
62.56
66.9
1
0.49
128
63.05
66.96
1
0.49
129
63.55
67.16
1
0.49
130
64.04
67.5
1
0.49
131
64.53
67.98
1
0.49
132
65.02
68.08
1
0.49
133
65.52
68.12
1
0.49
134
66.01
68.46
1
0.49
135
66.50
68.68
1
0.49
136
67.00
69.02
1
0.49
137
67.49
69.46
1
0.49
138
67.98
69.9
1
0.49
139
68.47
70.36
1
0.49
140
68.97
71.08
1
0.49
141
69.46
71.1
1
0.49
142
69.95
71.4
1
0.49
143
70.44
71.62
1
0.49
144
70.94
71.9
1
0.49
145
71.43
72.84
1
0.49
146
71.92
73.2
1
0.49
147
72.41
73.46
1
0.49
148
72.91
73.48
1
0.49
149
73.40
73.5
1
0.49
150
73.89
73.64
1
0.49
151
74.38
73.92
1
0.49
152
74.88
74.5
1
0.49
153
75.37
74.82
1
0.49
154
75.86
74.92
1
0.49
155
76.35
75.66
1
0.49
156
76.85
77.12
1
0.49
157
77.34
77.2
1
0.49
158
77.83
77.36
1
0.49
159
78.33
77.48
1
0.49
160
78.82
77.54
1
0.49
161
79.31
77.88
1
0.49
162
79.80
78.42
1
0.49
163
80.30
80.4
1
0.49
164
80.79
80.46
1
0.49
165
81.28
81.46
1
0.49
166
81.77
81.7
1
0.49
167
82.27
81.82
1
0.49
168
82.76
82.42
1
0.49
169
83.25
82.44
1
0.49
170
83.74
83.52
1
0.49
171
84.24
83.7
1
0.49
172
84.73
84.54
1
0.49
173
85.22
85.04
1
0.49
174
85.71
85.58
1
0.49
175
86.21
86.56
1
0.49
176
86.70
86.68
1
0.49
177
87.19
86.96
1
0.49
178
87.68
87.3
1
0.49
179
88.18
88.44
1
0.49
180
88.67
88.52
1
0.49
181
89.16
88.74
1
0.49
182
89.66
88.92
1
0.49
183
90.15
89.94
1
0.49
184
90.64
91.66
1
0.49
185
91.13
92
1
0.49
186
91.63
92.26
1
0.49
187
92.12
92.3
1
0.49
188
92.61
92.68
1
0.49
189
93.10
93.16
1
0.49
190
93.60
93.32
1
0.49
191
94.09
94.22
1
0.49
192
94.58
94.26
1
0.49
193
95.07
95.64
1
0.49
194
95.57
97.36
1
0.49
195
96.06
98.32
1
0.49
196
96.55
98.36
1
0.49
197
97.04
100
6
2.96
203
100.0




Frequency Missing = 10











CO2 emissions (in metric tons)
co2emissions
Frequency
Percent
Cumulative
Frequency
Cumulative
Percent
Frequency Missing = 13
132000
1
0.50
1
0.50
850666.66667
1
0.50
2
1.00
1045000
1
0.50
3
1.50
1111000
1
0.50
4
2.00
1206333.3333
1
0.50
5
2.50
1723333.3333
1
0.50
6
3.00
2251333.3333
1
0.50
7
3.50
2335666.6667
1
0.50
8
4.00
2368666.6667
1
0.50
9
4.50
2401666.6667
1
0.50
10
5.00
2907666.6667
1
0.50
11
5.50
2977333.3333
1
0.50
12
6.00
3659333.3333
1
0.50
13
6.50
4352333.3333
1
0.50
14
7.00
4774000
1
0.50
15
7.50
4814333.3333
1
0.50
16
8.00
5210333.3333
1
0.50
17
8.50
5214000
1
0.50
18
9.00
6024333.3333
1
0.50
19
9.50
7315000
1
0.50
20
10.00
7355333.3333
1
0.50
21
10.50
7388333.3333
1
0.50
22
11.00
7601000
1
0.50
23
11.50
7608333.3333
1
0.50
24
12.00
7813666.6667
1
0.50
25
12.50
8092333.3333
1
0.50
26
13.00
8231666.6667
1
0.50
27
13.50
8338000
1
0.50
28
14.00
8968666.6667
1
0.50
29
14.50
9155666.6667
1
0.50
30
15.00
14054333.333
1
0.50
31
15.50
14058000
1
0.50
32
16.00
14241333.333
1
0.50
33
16.50
16225000
1
0.50
34
17.00
16379000
1
0.50
35
17.50
17515666.667
1
0.50
36
18.00
19800000
1
0.50
37
18.50
20152000
1
0.50
38
19.00
20331666.667
1
0.50
39
19.50
20628666.667
1
0.50
40
20.00
21332666.667
1
0.50
41
20.50
21351000
1
0.50
42
21.00
22704000
1
0.50
43
21.50
23635333.333
1
0.50
44
22.00
26125000
1
0.50
45
22.50
26209333.333
1
0.50
46
23.00
28490000
1
0.50
47
23.50
29758666.667
1
0.50
48
24.00
30800000
1
0.50
49
24.50
32233666.667
1
0.50
50
25.00
35717000
1
0.50
51
25.50
35871000
1
0.50
52
26.00
36160666.667
1
0.50
53
26.50
37950000
1
0.50
54
27.00
38397333.333
1
0.50
55
27.50
38991333.333
1
0.50
56
28.00
40857666.667
1
0.50
57
28.50
45411666.667
1
0.50
58
29.00
45778333.333
1
0.50
59
29.50
46306333.333
1
0.50
60
30.00
46684000
1
0.50
61
30.50
49793333.333
1
0.50
62
31.00
51219666.667
1
0.50
63
31.50
52657000
1
0.50
64
32.00
55146666.667
1
0.50
65
32.50
56162333.333
1
0.50
66
33.00
56818666.667
1
0.50
67
33.50
59473333.333
1
0.50
68
34.00
62777000
1
0.50
69
34.50
69329333.333
1
0.50
70
35.00
73784333.333
1
0.50
71
35.50
75944000
1
0.50
72
36.00
78943333.333
1
0.50
73
36.50
81191000
1
0.50
74
37.00
86317000
1
0.50
75
37.50
87970666.667
1
0.50
76
38.00
88337333.333
1
0.50
77
38.50
90269666.667
1
0.50
78
39.00
92770333.333
1
0.50
79
39.50
95256333.333
1
0.50
80
40.00
100782000
1
0.50
81
40.50
102538333.33
1
0.50
82
41.00
104170000
1
0.50
83
41.50
107096000
1
0.50
84
42.00
109681000
1
0.50
85
42.50
119958666.67
1
0.50
86
43.00
125172666.67
1
0.50
87
43.50
125755666.67
1
0.50
88
44.00
127108666.67
1
0.50
89
44.50
131703000
1
0.50
90
45.00
132025666.67
1
0.50
91
45.50
137555000
1
0.50
92
46.00
143586666.67
1
0.50
93
46.50
148470666.67
1
0.50
94
47.00
149904333.33
1
0.50
95
47.50
168883000
1
0.50
96
48.00
169180000
1
0.50
97
48.50
170404666.67
1
0.50
98
49.00
170804333.33
1
0.50
99
49.50
183535000
1
0.50
100
50.00
188268666.67
1
0.50
101
50.50
214368000
1
0.50
102
51.00
223747333.33
1
0.50
103
51.50
225019666.67
1
0.50
104
52.00
226255333.33
1
0.50
105
52.50
228748666.67
1
0.50
106
53.00
234864666.67
1
0.50
107
53.50
236419333.33
1
0.50
108
54.00
242594000
1
0.50
109
54.50
248358000
1
0.50
110
55.00
253854333.33
1
0.50
111
55.50
254206333.33
1
0.50
112
56.00
254939666.67
1
0.50
113
56.50
275744333.33
1
0.50
114
57.00
277170666.67
1
0.50
115
57.50
283583666.67
1
0.50
116
58.00
300934333.33
1
0.50
117
58.50
310024000
1
0.50
118
59.00
322960000
1
0.50
119
59.50
340090666.67
1
0.50
120
60.00
377303666.67
1
0.50
121
60.50
428006333.33
1
0.50
122
61.00
446365333.33
1
0.50
123
61.50
487993000
1
0.50
124
62.00
503994333.33
1
0.50
125
62.50
511107666.67
1
0.50
126
63.00
525891666.67
1
0.50
127
63.50
531303666.67
1
0.50
128
64.00
590219666.67
1
0.50
129
64.50
590674333.33
1
0.50
130
65.00
592012666.67
1
0.50
131
65.50
598774000
1
0.50
132
66.00
692039333.33
1
0.50
133
66.50
811965000
1
0.50
134
67.00
953051000
1
0.50
135
67.50
999874333.33
1
0.50
136
68.00
1026813333.3
1
0.50
137
68.50
1146277000
1
0.50
138
69.00
1286670000
1
0.50
139
69.50
1321661000
1
0.50
140
70.00
1414031666.7
1
0.50
141
70.50
1425435000
1
0.50
142
71.00
1436893333.3
1
0.50
143
71.50
1548044666.7
1
0.50
144
72.00
1561079666.7
1
0.50
145
72.50
1633778666.7
1
0.50
146
73.00
1712755000
1
0.50
147
73.50
1718339333.3
1
0.50
148
74.00
1776016000
1
0.50
149
74.50
1839471333.3
1
0.50
150
75.00
1865922666.7
1
0.50
151
75.50
1962704333.3
1
0.50
152
76.00
2008116000
1
0.50
153
76.50
2269806000
1
0.50
154
77.00
2315698000
1
0.50
155
77.50
2329308666.7
1
0.50
156
78.00
2386820333.3
1
0.50
157
78.50
2406741333.3
1
0.50
158
79.00
2420300666.7
1
0.50
159
79.50
2421917666.7
1
0.50
160
80.00
2484925666.7
1
0.50
161
80.50
2670950333.3
1
0.50
162
81.00
2712915333.3
1
0.50
163
81.50
2932108666.7
1
0.50
164
82.00
3157700333.3
1
0.50
165
82.50
3341129000
1
0.50
166
83.00
3503877666.7
1
0.50
167
83.50
4200940333.3
1
0.50
168
84.00
4244009000
1
0.50
169
84.50
4286590000
1
0.50
170
85.00
4466084333.3
1
0.50
171
85.50
5248815000
1
0.50
172
86.00
5418886000
1
0.50
173
86.50
5584766000
1
0.50
174
87.00
5675629666.7
1
0.50
175
87.50
5872119000
1
0.50
176
88.00
5896388666.7
1
0.50
177
88.50
6710201666.7
1
0.50
178
89.00
7104137333.3
1
0.50
179
89.50
7861553333.3
1
0.50
180
90.00
9183548000
1
0.50
181
90.50
9483023000
1
0.50
182
91.00
9580226333.3
1
0.50
183
91.50
9666891666.7
1
0.50
184
92.00
10822529667
1
0.50
185
92.50
10897025333
1
0.50
186
93.00
12970092667
1
0.50
187
93.50
13304503667
1
0.50
188
94.00
14609848000
1
0.50
189
94.50
19000454000
1
0.50
190
95.00
23053598333
1
0.50
191
95.50
23404568000
1
0.50
192
96.00
24979045667
1
0.50
193
96.50
30391317000
1
0.50
194
97.00
33341634333
1
0.50
195
97.50
41229554667
1
0.50
196
98.00
46092214667
1
0.50
197
98.50
72524250333
1
0.50
198
99.00
101386215333
1
0.50
199
99.50
334220872333
1
0.50
200
100.00




Frequency Missing = 13





























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































No comments:

Post a Comment