In this project, the
data set of five countries i.e. Indonesia, Malaysia, Philippines, Singapore,
and Thailand is analyzed by using statistical techniques. The data set of
Indonesia, Malaysia, Philippines, Singapore, and Thailand contains data on five
variables i.e. CO2 emissions (metric tons per capita), Energy use (kg of oil
equivalent per capita), GDP per capita (constant 2010 US$), Exports of goods
and services (% of GDP), and Imports of goods and services (% of GDP). The
dataset contains covers the time period 1971 to 2013 for each country of each
variable. The data analysis tool on excel is used to calculate mean, standard
error, median, mode, standard deviation, sample variance, kurtosis, skewness, range,
minimum, maximum, sum, count, largest (1), and smallest (1) of each variable
for each variable.
Data of Statistics Empirical
Indonesia Statistics Empirical
|
CO2 emissions
|
Energy use
|
GDP per capita
|
Exports
|
Imports
|
|
|
|
|
|
|
Mean
|
1.072747
|
570.736
|
1850.445
|
27.63172
|
24.17261
|
Standard Error
|
0.08126
|
30.12201
|
123.7693
|
0.985513
|
0.705805
|
Median
|
1.021663
|
574.3449
|
1865.476
|
26.31216
|
23.85266
|
Mode
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
Standard Deviation
|
0.532857
|
197.5233
|
811.6094
|
6.462439
|
4.628271
|
Sample Variance
|
0.283937
|
39015.44
|
658709.9
|
41.76311
|
21.42089
|
Kurtosis
|
-0.12634
|
-1.60501
|
-0.87767
|
4.874541
|
5.701641
|
Skewness
|
0.682145
|
0.040326
|
0.350982
|
1.564945
|
1.557366
|
Range
|
2.086509
|
569.6264
|
2883.299
|
37.93047
|
27.15525
|
Minimum
|
0.330621
|
297.2006
|
687.6322
|
15.03767
|
16.0628
|
Maximum
|
2.41713
|
866.827
|
3570.931
|
52.96814
|
43.21806
|
Sum
|
46.12813
|
24541.65
|
79569.13
|
1188.164
|
1039.422
|
Count
|
43
|
43
|
43
|
43
|
43
|
Largest(1)
|
2.41713
|
866.827
|
3570.931
|
52.96814
|
43.21806
|
Smallest(1)
|
0.330621
|
297.2006
|
687.6322
|
15.03767
|
16.0628
|
Confidence Level(95.0%)
|
0.163989
|
60.78868
|
249.7765
|
1.988845
|
1.424372
|
The above graph shows the
positive and increasing trend of GDP
Malaysia Statistics Empirical
|
CO2 emissions
|
Energy use
|
GDP per capita
|
Exports
|
Imports
|
|
|
|
|
|
|
Mean
|
4.213711
|
1589.735
|
5465.587
|
77.25645
|
68.91877
|
Standard Error
|
0.33854
|
120.1899
|
366.4943
|
3.908404
|
3.064366
|
Median
|
3.92082
|
1566.725
|
5080.532
|
75.98436
|
69.68235
|
Mode
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
Standard Deviation
|
2.219954
|
788.1381
|
2403.264
|
25.62912
|
20.09439
|
Sample Variance
|
4.928195
|
621161.6
|
5775678
|
656.8519
|
403.7847
|
Kurtosis
|
-1.48238
|
-1.35181
|
-1.20173
|
-1.28839
|
-1.40829
|
Skewness
|
0.260114
|
0.241196
|
0.308462
|
0.190069
|
-0.03103
|
Range
|
6.535277
|
2499.679
|
8027.948
|
85.12815
|
64.62498
|
Minimum
|
1.491451
|
520.1404
|
2036.859
|
36.18244
|
35.97238
|
Maximum
|
8.026727
|
3019.819
|
10064.81
|
121.3106
|
100.5974
|
Sum
|
181.1896
|
68358.59
|
235020.2
|
3322.027
|
2963.507
|
Count
|
43
|
43
|
43
|
43
|
43
|
Largest(1)
|
8.026727
|
3019.819
|
10064.81
|
121.3106
|
100.5974
|
Smallest(1)
|
1.491451
|
520.1404
|
2036.859
|
36.18244
|
35.97238
|
Confidence Level(95.0%)
|
0.683201
|
242.5531
|
739.6155
|
7.887479
|
6.184142
|
Philippines Statistics Empirical
|
CO2 emissions
|
Energy use
|
GDP per capita
|
Exports
|
Imports
|
|
|
|
|
|
|
Mean
|
0.793121
|
455.8078
|
1651.072
|
32.05365
|
35.79545
|
Standard Error
|
0.018223
|
3.842322
|
40.44439
|
1.538012
|
1.805367
|
Median
|
0.811216
|
451.776
|
1573.731
|
29.12977
|
33.28404
|
Mode
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
Standard Deviation
|
0.119499
|
25.19579
|
265.2116
|
10.08542
|
11.83858
|
Sample Variance
|
0.01428
|
634.8279
|
70337.19
|
101.7157
|
140.152
|
Kurtosis
|
-0.18509
|
-0.16738
|
1.15162
|
-1.15302
|
-1.0904
|
Skewness
|
-0.57324
|
0.404146
|
1.262931
|
0.516102
|
0.505758
|
Range
|
0.490509
|
106.6463
|
1134.166
|
32.04235
|
39.82453
|
Minimum
|
0.516329
|
406.4923
|
1287.607
|
19.32694
|
19.46931
|
Maximum
|
1.006839
|
513.1386
|
2421.773
|
51.36929
|
59.29384
|
Sum
|
34.10421
|
19599.74
|
70996.08
|
1378.307
|
1539.204
|
Count
|
43
|
43
|
43
|
43
|
43
|
Largest(1)
|
1.006839
|
513.1386
|
2421.773
|
51.36929
|
59.29384
|
Smallest(1)
|
0.516329
|
406.4923
|
1287.607
|
19.32694
|
19.46931
|
Confidence Level(95.0%)
|
0.036776
|
7.75412
|
81.62008
|
3.103834
|
3.643378
|
Singapore Statistics Empirical
|
CO2 emissions
|
Energy use
|
GDP per capita
|
Exports
|
Imports
|
|
|
|
|
|
|
Mean
|
11.66227
|
3807.411
|
25643.43
|
176.7918
|
167.3233
|
Standard Error
|
0.501133
|
250.6239
|
2002.385
|
4.291257
|
2.994075
|
Median
|
12.16662
|
4257.569
|
23898.9
|
177.1862
|
167.1041
|
Mode
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
Standard Deviation
|
3.286149
|
1643.451
|
13130.51
|
28.13965
|
19.63346
|
Sample Variance
|
10.79877
|
2700932
|
1.72E+08
|
791.8401
|
385.4728
|
Kurtosis
|
-0.29307
|
-1.2453
|
-1.11698
|
0.28272
|
0.164595
|
Skewness
|
0.006873
|
0.057149
|
0.319543
|
-0.29214
|
0.195351
|
Range
|
14.77615
|
6078.153
|
43307.33
|
123.4695
|
87.00408
|
Minimum
|
4.342606
|
1292.241
|
7160.512
|
106.7996
|
122.3836
|
Maximum
|
19.11876
|
7370.395
|
50467.84
|
230.269
|
209.3877
|
Sum
|
501.4777
|
163718.7
|
1102668
|
7602.05
|
7194.904
|
Count
|
43
|
43
|
43
|
43
|
43
|
Largest(1)
|
19.11876
|
7370.395
|
50467.84
|
230.269
|
209.3877
|
Smallest(1)
|
4.342606
|
1292.241
|
7160.512
|
106.7996
|
122.3836
|
Confidence Level(95.0%)
|
1.011327
|
505.7796
|
4040.975
|
8.660107
|
6.042287
|
Thailand Statistics Empirical
|
CO2 emissions
|
Energy use
|
GDP per capita
|
Exports
|
Imports
|
|
|
|
|
|
|
Mean
|
2.16398
|
935.678
|
2848.401
|
41.63836
|
41.80896
|
Standard Error
|
0.211087
|
77.21969
|
221.5373
|
3.035309
|
2.505818
|
Median
|
1.900554
|
840.1411
|
2876.624
|
36.81714
|
41.65044
|
Mode
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
#N/A
|
Standard Deviation
|
1.384189
|
506.3634
|
1452.717
|
19.90385
|
16.43175
|
Sample Variance
|
1.91598
|
256403.9
|
2110387
|
396.1632
|
270.0024
|
Kurtosis
|
-1.47179
|
-1.11526
|
-1.22476
|
-1.62427
|
-1.29374
|
Skewness
|
0.297562
|
0.497265
|
0.281084
|
0.267245
|
0.266017
|
Range
|
4.037434
|
1626.998
|
4665.841
|
55.42748
|
50.63826
|
Minimum
|
0.506996
|
360.5781
|
946.8499
|
15.98892
|
18.81291
|
Maximum
|
4.544431
|
1987.576
|
5612.691
|
71.4164
|
69.45117
|
Sum
|
93.05114
|
40234.15
|
122481.2
|
1790.449
|
1797.785
|
Count
|
43
|
43
|
43
|
43
|
43
|
Largest(1)
|
4.544431
|
1987.576
|
5612.691
|
71.4164
|
69.45117
|
Smallest(1)
|
0.506996
|
360.5781
|
946.8499
|
15.98892
|
18.81291
|
Confidence Level(95.0%)
|
0.425991
|
155.8356
|
447.0804
|
6.125501
|
5.056946
|
Analysis and Discussion Statistics
Empirical
From above analysis,
it can be seen that the means value of CO2 emissions in of Indonesia, Malaysia,
Philippines, Singapore, and Thailand is 1.072747, 4.213711, 0.793121, 11.66227,
and 2.16398 respectively. Singapore is contributing more to CO2 emissions as compare
to other countries and Philippines has lowest mean value. While on the other
hand, the mean value of energy uses in these country is 570.736, 1589.735, 455.8078,
3807.411, 935.678 respectively; it means the Singapore is consuming highest
energy as compare to Indonesia, Malaysia, Philippines, and Thailand while Philippines
has least energy use, the energy consumption is good enough in Malaysia as well
and Indonesia also has less energy use.
Furthermore, the means
value of GDP per capita in these countries is 1850.445,
5465.587, 1651.072, 25643.43, and 2848.401 respectively; the data shows that Singapore
has highest per capita GDP followed by Malaysia and Thailand while Philippines
has lowest GDP per capita after Indonesia. Now talking about exports, the mean
value of exports in these countries is 27.63172, 77.25645, 32.05365, 176.7918, and 41.63836 respectively; the exports is highest
in Singapore followed by Malaysia and Thailand, and Indonesia has lowest
exports in the country after Philippines. Last but not least, the mean value of
imports in these five countries is 24.17261, 68.91877, 35.79545, 167.3233, and 41.80896 respectively; the data shows the imports
are highest in Singapore followed by Malaysia and Thailand while Indonesia has
lowest imports after Philippines.
Conclusion on Statistics Empirical
In a nutshell, excel data analysis tool is used
in this paper to analyze the data set of five countries i.e. Indonesia,
Malaysia, Philippines, Singapore, and Thailand of five variables i.e. CO2 emissions
(metric tons per capita), Energy use (kg of oil equivalent per capita), GDP per
capita (constant 2010 US$), Exports of goods and services (% of GDP), and Imports
of goods and services (% of GDP). The dataset contains covers the time period
1971 to 2013 for each country of each variable. The analysis has shown that
Singapore is doing great in all of the aspects and it is emerging economy. Malaysia
and Thailand are also performing well after Singapore. The economic condition
of Philippines seems to be worse among these five countries and Indonesia is
also much far behind than Singapore, Thailand, and Malaysia. However, the
performance of Indonesia is little better than Philippine. In the case of imports
and exports, Indonesia falls behind Philippines and Philippines has bette