Descriptive statistics to understand stock market performance

By Anushka Mathur on December 19, 2023

The stock price of a company reflects its financial performance in terms of capital value which is influenced by various economic and non-economic factors. Descriptive statistics aids in analysing stock performance for useful insights. A better understanding of the stock and market return trend will facilitate the allocation of financial sources to the most profitable investment opportunity. Thus, it is necessary to study fluctuations in the stock market to understand its behaviour (Shama and Sharma, 2019). However, before assessing the fluctuations in detail, there is also a requirement to condense the data set which contains a vast number of data points and observations.

Using descriptive statistics for stock examination

In contemporary times, a significant and ever-increasing amount of data is generated daily by various commercial, administrative, and scientific entities. This relentless growth is substantially expanding the sizes of databases. Statistical techniques have been employed to examine the nature, trend, variation, and distribution of such accumulating data.

Descriptive statistical techniques seek to furnish consolidated information, specifically by examining the average and dispersion of data. A measure of central tendency, dispersion, skewness, kurtosis, and correlation study are some of the conventional standards of descriptive statistics (Sarmento and Costa, 2017). It enables having basic information about the stocks by examining the returns and their volatility. Hence, descriptive analysis is commonly employed in stock market studies to conduct examinations of stock performance (Jagathi, 2019).

This study aims to examine the nature of stock and market data of companies from the energy and pharmaceutical sectors using descriptive analysis. Herein, Descriptive analysis was applied to abnormal return and average abnormal return to analyze the financial soundness of the companies under study and provide crucial insight. The descriptive measures used for the analysis were standard deviation, variance, min, max, skewness, and kurtosis.

Results of the descriptive analysis of the energy sector

MeanStd. deviationminmaxskewnesskurtosis
449.63620.37-44.281451.680.641.67
Table 1: Descriptive statistics for average abnormal return of the energy sector

The descriptive statistics for average abnormal return represent that on average the return for the energy sector is Rs. 449.63 witnessing huge deviation among the companies i.e. 620.37. The minimum average abnormal return is -44.28, while the maximum is 1451.68. The skewness value of the return is 0.64 showing positive skewness and slight deviation from symmetric distribution. Kurtosis value on the other hand is less than 3 representing that the curve of return is platkurtic i.e. with a flat top or the return values are spread. The descriptive statistics of average abnormal return shows that there is a huge variation in the total earns derived in the energy sector. Investing careful examination of each company is required to get more clarity.

The abnormal return provides the specific company-oriented details. Herein, the analysis reveals that the highest abnormal return could be derived from Bhel and Adani Power so these are the most profitable investments but the stocks also have the highest level of fluctuations with a standard deviation of more than 2000.

The lowest return is derived from Adani Green Energy and Kirloskar Ind as these have negative returns. Skewness reveals that for NHPC, NTPC, GVK Power, Power Gird, Ratan Power, and Reliance Power the level is approximately 0 therefore, the return of these stocks is symmetric.

Company NameMeanStd. deviationminmaxskewnesskurtosis
Bhel355.013370.69-6.6131976.99.3288.01
NHPC0.141.92-7.516.950.036.03
NTPC-0.012.67-7.476.610.062.97
S E Power0.612.5-4.129.540.554.1
Adani green energy-8.7751.34-357.3584.35-4.126.46
Adani Power202.712003.2-17.5198319.7496
Adani Transmission4.1740.78-228.85136.29-1.2414.92
Guj Ind Power-0.212.91-12.446.1-0.725.68
GVK Power0.391.69-2.84.880.33.4
Indian Energy Exchange-3.6313.24-72.3513.89-3.3715.94
Jaiprakash power0.12.51-11.557.17-1.379.29
Jsw Energy-2.2321.53-205.2416.15-8.6682.34
Kec International-0.089.26-21.1736.881.076.21
Kirloskar Ind-7.9572.91-545188.09-4.5236.34
Power grid-0.263.72-12.310.02-0.093.83
Promax power-1.12.69-3.222.580.531.46
Rattan Power0.522.66-11.618.87-0.367.14
Reliance Infra-1.8710.69-75.4125.53-4.0827.59
Reliance Power0.922.16-5.366.920.123.27
Tata Power-0.363.47-17.658.58-1.18.45
Thermax-5.9547.66-226.46192.98-0.610.54
Torrent Pharma-0.610.25-52.9235.34-1.1310.34
Table 2: Descriptive statistics for abnormal return of energy sector

The descriptive analysis reveals that only 2 companies in the energy sector offered the most returns which tend to provide benefits but these stocks due to high standard deviation also carry higher risks with them.

Results of the descriptive analysis of the pharma sector

GroupMeanStd. deviationminmaxskewnesskurtosis
1st group-547.591014.75-2748.13122.18-1.623.84
2nd group575.721207.69-55.122977.591.493.24
Table 3: Descriptive statistics of the average abnormal return of the pharma sector

In the descriptive analysis of the first pharmaceutical group, negative returns are observed, whereas the second group exhibits positive returns. The first group displays a higher standard deviation, indicating a wider spread of observations, whereas the second group has a comparatively lower standard deviation, signifying less spread of data. The skewness of the first group is negative, while that of the second group is positive. However, neither group’s skewness value is close to 0, suggesting a lack of symmetry.

Finally, the kurtosis value for each of these exceeds 3, indicating a leptokurtic curve characterized by a higher concentration of values near the mean. The analysis indicates that investing in the second group is advantageous due to its positive return and lower risk, as reflected by a smaller standard deviation. However, the identification of suitable companies for investment necessitates individual assessments of each company.

In evaluating the performance of each company, the abnormal return highlights Morphen Labs as the most favourable, displaying a positive return. Conversely, all other companies either exhibit very low returns or negative ones. Despite Morphen Labs providing benefits, it also carries risks due to the presence of a high standard deviation. The skewness of companies such as Amrutanjan Health, AstraZeneca, Bajaj Healthcare, Biofilm Chemicals, Gland Pharma, Hagsonpal Pharma, Lupin, Manglam Drugs, Mankind Pharma, Windlass Biotech, IOL Chemicals, Ind-Swift Labs, Shilpa Medicare, Syngene, and Themis Medicare is close to 0, indicating a symmetric distribution of returns. Furthermore, the kurtosis value for each company is either less or more than 3, suggesting an absence of symmetry.

Company NameMeanStd. deviationminmaxskewnesskurtosis
Aarti Drugs-1.6025.27-86.09110.251.239.55
Abott India-26.98415.86-1302.771163.380.585.32
Alpha labs0.692.87-4.949.790.724.06
Ami organics-8.7547.50-192.5259.86-2.039.42
Amrutanjan health-1.8818.16-64.1346.75-0.364.95
Astrazeneca-5.4886.64-355.24223.43-0.327.52
Bajaj healthcare-4.3418.63-44.0956.940.284.26
Biocon-2.2110.57-43.9720.85-1.196.26
Biofil Chemicals1.653.72-14.8818.400.0013.69
Dr Reddys-19.24111.82-573.06258.08-1.4210.44
Gland Pharma2.8293.41-206.26264.310.423.99
GlaxoSmithKline-185.861379.84-10497.63378.05-7.3855.67
Gufic Biosciences-1.027.13-31.9720.30-0.877.79
Hikal0.2313.10-42.2460.361.019.16
Indico Remedies-0.5813.44-36.6074.461.9113.38
Ind-swift labs0.323.41-11.279.86-0.083.97
IOL Chemicals-4.3214.79-43.6939.990.073.75
ipca labs0.9142.41-172.99134.36-0.618.64
Jagsonpal Pharma1.925.42-18.8320.90-0.057.80
Jubilant pharmova0.3917.90-40.6094.822.0914.45
Kilitch Drugs37.35236.20-33.321512.136.1538.94
Kopran0.695.02-19.6814.56-0.886.84
Laurus labs3.2320.60-40.23106.482.0811.61
Lincoln Pharma-1.9711.81-43.9931.76-0.705.23
Lupin-2.7319.03-60.6956.25-0.134.21
Manglam Drugs1.464.20-10.3814.75-0.115.52
Mankind Pharma11.6034.34-18.9046.040.031.05
Medicamen-7.8639.17-304.1152.28-5.7844.44
Morepen labs668.206357.14-55.1560644.739.3889.00
Natco Pharm-4.8420.49-101.0761.44-0.887.97
Nectar Lifesciences0.692.62-5.0911.520.745.49
NGL Fine Chem-11.5056.40-307.08162.69-1.9012.15
Orchid Pharma-0.5810.36-42.8226.37-0.726.68
Pfizer4.5595.75-205.98382.981.356.75
Sanofi India-1125.968656.05-67620.52175.24-7.6159.00
Sequent Sc0.687.05-15.6529.461.306.86
Shilpa Medicare-0.0415.84-49.3552.400.194.60
Solara Active-1.9258.81-124.28414.413.5728.53
Suven Life Sc2.195.35-11.2724.931.418.28
Syngene-2.7011.66-33.0934.810.143.86
Themis Medicare0.2231.21-104.8093.95-0.365.76
Unichem labs-0.0710.19-28.7646.840.759.15
Windlass Biotech1.674.65-7.0411.250.192.47
Wockhardt-1.1118.65-112.7452.20-2.0017.71
Zim labs-4.3444.52-411.9621.08-8.8681.64
Table 4: Descriptive statistics of abnormal return for the pharma sector

Within the pharmaceutical sector, Morphen Labs stands out as the sole avenue for achieving higher abnormal returns, albeit accompanied by inherent risks.

Descriptive statistics of abnormal and average abnormal returns offer investors valuable insights into stock movements and help identify securities with the potential for higher returns. Summarized descriptions of company-wise abnormal returns facilitate comparisons among companies within the same industry, providing a snapshot of their respective performances. While the initial statistical tools provide meaningful information, there is a need for more detailed analysis using advanced statistical indices to explore the depth and relationships among observations in the dataset.

References

  • Jagathi, P. H. (2019) ‘Descriptive analysis of stock market investor’, ICTATCT Journal of Management studies, 05(03), pp. 1068–1072. doi: 10.21917/ijms.2019.0147.
  • Sarmento, R. and Costa, V. (2017) ‘Descriptive Analysis’, in Comparative Approaches to Using R and Python for Statistical Data Analysis, pp. 66–90. doi: 10.4018/978-1-68318-016-6.ch004.
  • Shama, R. P. and Sharma, A. (2019) ‘Statistical Analysis of Stock Prices of Selected Companies in Construction Industry’, Advances in Management, 12(1), pp. 39–47.

Discuss