Submitted by- Devesh Hole
Roll no. 021230022796 (IFM BATCH)
Introduction-
Dr. Reddy’s Laboratories is an Indian multinational pharmaceutical company based in Hyderabad. The company was founded by Kallam Anji Reddy, who previously worked in the mentor institute Indian Drugs and Pharmaceuticals Limited.[2] Dr. Reddy’s manufactures and markets a wide range of pharmaceuticals in India and overseas. The company has over 190 medications, 60 active pharmaceutical ingredients (APIs) for drug manufacture, diagnostic kits, critical care, and biotechnology.
Data Collection
Data collection for the period starting from 1st January 2022 to 31st December 2022 has been downloaded from nse.com. Then Friday weekly Closing Prices have been calculated.
And weekly data of equity share of the chosen company has been regressed on weekly report of NIFTY50.
Data Analysis-
Regression Equation that was formed after the calculations is-
NIFTY 50 (Y) = -0.16615 +0.114055+error
B(T Stat) = -0.24712
N= 49, R2=0.001271, F= 0.061068, P Value =0.80587
Interpretation-
The equation mentioned above tells us about the relationship between Nifty50(x) value and Dr.Reddy’s Lab ltd (y) stock prices. The positive sign of coefficient x variable= -0.06485
states that there is a direct relation between nifty 50 and Dr.Reddy’s Lab. The correlation coefficient is -0.09401.
If the nifty 50 increase by 1 unit, the Dr.Reddy’s Lab stock will increase by 0.114055, directly related to each other
In these analysis t – stat of B is -0.24711 at 49 observations
P value is 0.805870, which is More than 0.05, means that b is in statistically insignificant at 5%. Even it is more than 0.01, b is insignificant at 1% level.
R2 = 0.001271, which means that .127% of Y (Dr.Reddy’s Lab) is explained by X (NIFTY), balance of 99.872% is error. Error is due to the variables which are not in the model.
F is 0.061068, the P value for which is 0.2083> 0.01, means overall the model is insignificant.
Conclusion-
The above equation tells us about the relationship between Dr.Reddy’s Lab Ltd.
Equity (y) and Nifty 50 (x). The positive sign means there is a direct relationship between them,
which means if Nifty 50 increases, then the equity price of Dr.Reddy’s Lab ltd. will also increase
P VALUE is more than 0.01 which is overall model is insignificant.