Data Collection and Descriptive Analysis of Coca Cola's Carbon Emission Data from 2011-2017

Data collection
For the current research the data has been collected for Coca Cola company which are located in
the different countries for the time period 2011- 2017. A separate excel sheet has been prepared
for the data. The data cleaning process are performed in excel such as the missing value, deleting
the variables not required for the analysis etc. Once the data was cleaned it was imported into
SPSS for further analysis. The categorical variables were coded in SPSS.
Data analysis (descriptive)
As shown in Table 1, the descriptive statistics for the continuous variable includes the median,
mean, mode, minimum, maximum, standard deviation, Skewness and the Kurtosis. The table
below shows the results of the descriptive statistics for the continuous variable included in the
data set. The mean value of the first variable is 62.58 and the standard deviation for the mean is
230.37 which suggests that values are far from the mean as there is high variability in the data
set. Higher standard deviation infer higher variation in the data set and vice a versa. The results
for the other variables can also be interpred in the similar way. The minimum and maximum
values are also given. For the first variable the minimum is 5 and the maximum is 999, which
also infer high variation in the data set(Bryman, A. and Bell, 2011; Saunders, Lewis, &
Thornhill, 2009).
Statistics
CC11.1 CC11.3 CC11.5 C1 CC11.5 C2 CC11.5 C3
N Valid 36 36 36 36 36
Missing 0 0 0 0 0
Mean 62.5833 229580.6286 347633.1811 177270.9172 171046.7917
Median 5.0000 999.0000 999.0000 999.0000 999.0000
Mode 5.00 999.00 999.00 999.00 999.00
Std. Deviation 230.37093 460014.8856
5
1062861.274
74
378705.7726
3
984598.0349
0
Variance 53070.764 21161369501
7.061
11296740893
46.597
14341806222
5.159
96943329032
3.077
Skewness 4.049 2.183 4.869 2.526 5.997
Std. Error of
Skewness
.393 .393 .393 .393 .393
Minimum 5.00 999.00 999.00 999.00 .00
Maximum 999.00 1702060.00 6105629.00 1474765.00 5913631.00
Percentiles
25 5.0000 999.0000 999.0000 999.0000 999.0000
50 5.0000 999.0000 999.0000 999.0000 999.0000
75 10.0000 278048.4700 192057.9300 179205.1800 999.0000

Statistics
CC11.5 C4 CC12.2 C5 CC12.2 C6
N Valid 36 36 36
Missing 0 0 0
Mean 1022.5694 10.1772 55.2222
Median 999.0000 6.8400 -1.0000
Mode 999.00 .00a -1.00
Std. Deviation 1578.06826 11.06356 232.14861
Variance 2490299.445 122.402 53892.978
Skewness 5.385 2.099 4.051
Std. Error of
Skewness
.393 .393 .393
Minimum .00 .00 -1.00
Maximum 9931.00 51.00 999.00
Percentiles
25 499.5000 2.1275 -1.0000
50 999.0000 6.8400 -1.0000
75 999.0000 15.0750 1.0000
a. Multiple modes exist. The smallest value is shown
Furthermore the C12. 2 C6 is the dependent variable which is the percentage change in the
carbon emission for the firms included in the data set. The results show that the average change
is 55 % whereas the median is -1. This show high difference in the two central tendencies. This
is may be because of extreme values in the data set. The mean is affected by the extreme values
whereas the median is not. The minimum value for the same is -1, which indicates decrease of 1
% from the previous year.
Histograms
The skewness of the variables in the data set has been measured by the histogram and the figures
are shown below.

For this variable, it is less skewed or the value of skewness is negative. The variable is not
normally distributed.

In case of this variable also the histogram suggests a left skewed data or most of the data points
are to the left of the average value.