Descriptive Statistics of Financial Data

Verified

Added on  2020/04/01

|6
|1003
|125
AI Summary
This solved assignment focuses on the descriptive analysis of key financial data points. It presents detailed statistical summaries for variables such as 'relativesize', 'control loss', and 'value'. Tables are provided showcasing various percentiles (1%, 5%, 10%, etc.), the smallest and largest observed values, mean, standard deviation, variance, skewness, and kurtosis. These descriptive statistics offer insights into the distribution and characteristics of each financial variable.
tabler-icon-diamond-filled.svg

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
Summary statistics of the data
In the first section the descriptive statistics of the variables included in the data has been shown. The
descriptive statistics results includes mean standard deviation, variance , Skewness and Kurtosis. Apart
from that the results for the different percentile and the smallest and largest values in different
percentile has also been shown.
Leverage
-------------------------------------------------------------
Percentiles Smallest
1% 0 0
5% 0 0
10% 0 0 Obs 4562
25% .0054873 0 Sum of Wgt. 4562
50% .054012 Mean 2.320501
Largest Std. Dev. 17.61297
75% .2991688 325.6679
90% 2.215389 362.2728 Variance 310.2166
95% 6.635238 485.7184 Skewness 17.94292
99% 43.7209 527.7961 Kurtosis 412.8319
Table 1 Descriptive statistics of leverage value
One of the independent variables included in the current study is leverage, which is one of most
popular financial ratio which show how much capital of the firm is debt and how much is from
equity. In this case the average leverage ratio is 2.32 with standard deviation of 17.61. The high
values of standard deviation suggest high variation in the data set. Similarly the values of
Skewness and Kurtosis are 17.94 and 412.83 respectively. Similarly the smallest value of
leverage is 0 and the largest value being 527 the leverage of 0 is for the private firms who do not
have debt or equity in their capital structure and rely on other sources to raise capital. On the
other hand the leverage of 527 shows that the company is dependent on debt only and the
proportion of equity are very low. This indicates poor financial health of the company.
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
cash pecentage
-------------------------------------------------------------
Percentiles Smallest
1% 0 0
5% 0 0
10% 0 0 Obs 4562
25% 0 0 Sum of Wgt. 4562
50% .0172589 Mean .090348
Largest Std. Dev. .1411692
75% .131409 .8162165
90% .2893042 .8486679 Variance .0199287
95% .4085303 .9423814 Skewness 2.037976
99% .6071016 .9633657 Kurtosis 7.307657
Table 2 Descriptive statistics for cash holding
Firm Size
-------------------------------------------------------------
Percentiles Smallest
1% 4.567011 2.511549
5% 5.515463 3.084476
10% 6.102142 3.165981 Obs 4562
25% 6.987612 3.197571 Sum of Wgt. 4562
50% 8.083081 Mean 8.315846
Largest Std. Dev. 1.9139
75% 9.419694 14.52453
Document Page
90% 10.86383 14.52453 Variance 3.663013
95% 11.81924 14.5658 Skewness .5687464
99% 13.66631 14.63344 Kurtosis 3.366057
Table 3 Descriptive statistics of firm size
ROA
-------------------------------------------------------------
Percentiles Smallest
1% .0091107 .0029066
5% .0178257 .0029066
10% .0280689 .0035714 Obs 4562
25% .0495321 .0038592 Sum of Wgt. 4562
50% .0835413 Mean .1028374
Largest Std. Dev. .0891551
75% .1328959 1.299745
90% .1915922 1.345899 Variance .0079486
95% .2355458 1.447988 Skewness 5.40242
99% .3851624 1.802059 Kurtosis 68.51874
Table 4 Descriptive statistics for Return on assets
Free Cash Flow
-------------------------------------------------------------
Percentiles Smallest
1% 0 0
5% .0081845 0
10% .0158699 0 Obs 3762
Document Page
25% .0264261 0 Sum of Wgt. 3762
50% .0423564 Mean .0590118
Largest Std. Dev. .0597903
75% .0681084 .5258346
90% .1161053 .5471613 Variance .0035749
95% .181362 .6603009 Skewness 3.292327
99% .3255287 .6603009 Kurtosis 19.21121
Table 5 Descriptive statistic of free cahsflow
Relative Size
-------------------------------------------------------------
Percentiles Smallest
1% 4.57e-06 0
5% .00004 0
10% .0001016 0 Obs 4562
25% .0003883 5.30e-07 Sum of Wgt. 4562
50% .0013139 Mean .0033366
Largest Std. Dev. .0067105
75% .0036925 .0865884
90% .007853 .0891441 Variance .000045
95% .0128244 .1411383 Skewness 8.293157
99% .0283229 .1545525 Kurtosis 127.8869
Table 6 Descriptive statistics of relativesize
Control Loss
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
-------------------------------------------------------------
Percentiles Smallest
1% 0 0
5% 0 0
10% 0 0 Obs 4562
25% 5.30e-07 0 Sum of Wgt. 4562
50% .0007504 Mean .0026029
Largest Std. Dev. .0059791
75% .0028192 .0767027
90% .0066042 .0891441 Variance .0000358
95% .0109733 .1411383 Skewness 9.804684
99% .0242488 .1545525 Kurtosis 184.4511
Table 7 Descriptive statistics of control loss variable
value
-------------------------------------------------------------
Percentiles Smallest
1% 2.26 1
5% 6 1
10% 11.05 1 Obs 5175
25% 30 1.01 Sum of Wgt. 5175
50% 106 Mean 726.1113
Largest Std. Dev. 3179.599
75% 355 58663.15
Document Page
90% 1230 62141.06 Variance 1.01e+07
95% 2800 67285.7 Skewness 12.31174
99% 11694.66 72671 Kurtosis 200.8953
Table 8 Descriptive statistics of value of transaction
chevron_up_icon
1 out of 6
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]