Problem Title:
To determine RELATIONSHIP OF Nifty and Sanofi India Ltd.
Author – Shikha Dhingra
INTRODUCTION OF COMPANY
Sanofi India Limited is one of the entities through which Sanofi operates in India. It was incorporated in May 1956 under the name Hoechst Fedco Pharma Private Limited. Over the years, its name was changed to Hoechst Pharmaceuticals Private Limited, Hoechst India Limited, Hoechst Marion Roussel Limited and Aventis Pharma Limited. Today, it employs more than 3,000 employees across India.
Sanofi, one of the world’s leading healthcare companies, and its 100% subsidiary – Hoechst GmbH, are the major shareholders of Sanofi India Limited and together hold 60.4% of its paid-up share capital.
OBJECTIVE
To calculate beta of company and find its significance
Data Collection:
Data was collected from the NSE Website which comprises of historic data for the past 1 year. The Friday of each week of the year was taken into consideration. The resultant was calculated and regression was performed on the data.
Data Analysis:
We know Y= a +bx1
Where b is the beta value.
H0 – Null Hypothesis
H1 – Alternate Hypothesis
If the beta coefficient is significant, the interpretation is that for every 1-unit increase in the predictor variable, the outcome variable will increase by the beta coefficient value.
Observations:
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.168458
R Square 0.028378
Adjusted R Square 0.006296
Standard Error 3.248514
Observations 46
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.279942 0.313935 0.89172 0.377394 0.35275 0.912637 0.35275 0.912637
X Variable 0.110235 0.097241 1.133626 0.26309 0.08574 0.306211 0.08574 0.306211
It was found that R Square is 2.8%, the regression Equation was found to be
Y= 0.2799+ 0.11023X
Here Beta value is 0.11023