{"id":16504,"date":"2022-06-11T12:16:54","date_gmt":"2022-06-11T06:46:54","guid":{"rendered":"http:\/\/www.sachdevajk.in\/2022\/06\/11\/relationship-of-marico-ltd-with-nifty\/"},"modified":"2022-06-11T15:48:29","modified_gmt":"2022-06-11T10:18:29","slug":"relationship-of-marico-ltd-with-nifty","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=16504","title":{"rendered":"Relationship of Marico LTD with NIFTY"},"content":{"rendered":"<p>Author : Misbah Pathan<\/p>\n<p>Introduction:<br \/>\nMarico Limited is an Indian multinational consumer goods company providing consumer products and services in the areas of health, beauty, and wellness. It is one of India\u2019s leading consumer goods companies operating in the global beauty and wellness categories. The Company offers various brands in hair care, skin care, edible oils, healthy foods, hygiene, male grooming, fabric care, etc.<\/p>\n<p>Objective:<br \/>\nCalculate the Beta of Marico LTD and see its significance.<\/p>\n<p>Data Collection:<br \/>\nWe have downloaded the data of Marico Limited and Nifty-50 dated from 1st April 2021 to 31st March 2022 from the website of National Stock Exchange. The data for this period, Nifty equity is downloaded by CSV file. Firstly, we have taken the data and after deleting all the columns except date and closing stock we have added the weekday column in the data using weekday function of excel. Then we have added another column named as Return Column named as X for nifty and same Y for equity which will be regression.<\/p>\n<p>Data analysis:<br \/>\nEquation in the form of Y= a + b(X)<br \/>\nY= Marico Limited company (Equity)<br \/>\nX = Nifty- 50 Returns<br \/>\na = intercept and b = slope<br \/>\nHence the equation,<br \/>\nY = 0.98032252 + (0.29486375) X<br \/>\nMarico Returns = 0.98032252 + (0.29486375) *(Nifty 50 Returns) (189.0808)<br \/>\nN= 43, R2 = 0.03724 and F = 1.50852<\/p>\n<p>Conclusion:<br \/>\nThe above equation tells us the relationship between X &amp; Y.<br \/>\nIf x rises by 1 unit, y will fall by 0.98 and vice versa. The p value which is greater than 0.05 means be is statistically insignificant at the 5% level. R2 is 0.03724 which means 0.30% of y is explained by x. F is 1.50 for which the value is greater, meaning that the overall model is statistically insignificant at the 5% level.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Author : Misbah Pathan Introduction: Marico Limited is an Indian multinational consumer goods company providing consumer products and services in the areas of health, beauty, and wellness. It is one of India\u2019s leading consumer goods companies operating in the global beauty and wellness categories. The Company offers various brands in hair care, skin care, edible&hellip; <a class=\"more-link\" href=\"http:\/\/www.sachdevajk.in\/?p=16504\">Continue reading <span class=\"screen-reader-text\">Relationship of Marico LTD with NIFTY<\/span><\/a><\/p>\n","protected":false},"author":93379,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,37,38,61,9,39,12,10],"tags":[355],"class_list":["post-16504","post","type-post","status-publish","format-standard","hentry","category-business","category-economics","category-finance","category-legal-issues","category-management","category-marketing","category-sales","category-sales-marketing","tag-jdbims","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/users\/93379"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16504"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16504\/revisions"}],"predecessor-version":[{"id":16521,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16504\/revisions\/16521"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16504"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}