TITLE :- Regression Analysis of Weekly Return between NIFTY 50 AND Nestle
India Ltd.
AUTHOR :- Nishi Shah
MBA MARKETING
INTRODUCTION:-
NESTLE India manufactures products of truly international quality under internationally
famous brand names such as NESCAFE, MAGGI, MILKYBAR, KIT KAT, BAR-ONE,
MILKMAID and NESTEA and in recent years the Company has also introduced
products of daily consumption and use such as NESTLE Milk, NESTLE SLIM Milk.
NESTLE India is a responsible organization and facilitates initiatives that help to
improve the quality of life in the communities where it operates.
OBJECTIVE:-
To understand the regression relationship between weekly returns of Nifty 50 and
Nestle India Ltd.
DATA COLLECTION:-
Data for this study of Nestle India Ltd. has been downloaded from
www.nseindia.com for both Nifty 50 and Nestle India Ltd. Returns where
calculated by using formula =(c3-c2)/c2*100. From available data closing price
and date were taken and others were deleted. Collected data from the time
period of 1st April 2021 to 31st March 2022.
DATA ANALYSIS:-
Regression data was calculated in the Excel tool from that we got below values.
X = 0.21877196
Y = -0.1115584
R Square = 0.05740693
F = 2.61883735
P value = 0.70935045
CONCLUSION:-
We conclude that F value is greater than table F value, so based on the above
equation Nestle India Ltd. is not a good company as it is a high risk