Title: Relationship of Cipla Limited Company with Nifty-50<\/p>\n
Author – Chanchal Suresh Sambare <\/p>\n
Introduction
\n
\nCipla is a leading pharmaceutical from India with presence across the world. It was established in 1935 as Chemical Industrial & Pharmaceutical Laboratories Ltd and changed to its current name in 1984. The company has a vast portfolio with more than 1,500 products in the market.
\nCipla Limited is an Indian multinational pharmaceutical company, headquartered in Mumbai, India. Cipla primarily develops medicines to treat respiratory, cardiovascular disease, arthritis, diabetes, weight control and depression; other medical conditions
\nCipla sells active pharmaceutical ingredients to other manufacturers as well as pharmaceutical and personal care products,[21] including escitalopram oxalate (anti-depressant), lamivudine, and fluticasone propionate.[4] They are the world’s largest manufacturer of antiretroviral drugs.<\/p>\n
Objective
\n
\nCalculate the Beta of the \u201cCipla Company\u201d and see its significance.<\/p>\n
Data collection
\n
\nWe have downloaded the data of Cipla 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 column 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
\nData analysis
\n
\nEquation in the form of Y= a + b(X)
\n
\nY= Cipla Limited company (Equity)
\n
\nX = Nifty- 50 Returns
\n
\na = intercept and b = slope
\n
\nHence the equation,
\n
\nY = 0.27571 + (-0.09261) X
\n
\nCipla Returns = 0.27571+(-0.09261) *(Nifty 50 Returns)
\n \t\t\t (-0.36479)
\n
\nN= 44, R2 = 0.0031 and F = 0.1331<\/p>\n
Conclusion
\n
\nThe above equation tells us the relationship between X & Y. IF X rises by 1 unit, Y will fall by (-0.0926) and vice versa given figure (-0.3647) is the t stat for b. The p-value for which is (0.7170) which is greater than 0.05 which means b is statistically insignificant at 5% level. R^2 is (0.0031) which means 0.31% of y is explained by X. F is (0.1331) and p value for which is (0.7170) which is greater than 0.05 it means overall model is statistically insignificant at 5 % level. <\/p>\n","protected":false},"excerpt":{"rendered":"
Title: Relationship of Cipla Limited Company with Nifty-50 Author – Chanchal Suresh Sambare Introduction Cipla is a leading pharmaceutical from India with presence across the world. It was established in 1935 as Chemical Industrial & Pharmaceutical Laboratories Ltd and changed to its current name in 1984. The company has a vast portfolio with more than… Continue reading Relationship of Cipla limited company with Nifty-50<\/span><\/a><\/p>\n","protected":false},"author":93220,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[355],"class_list":["post-16395","post","type-post","status-publish","format-standard","hentry","category-management","tag-jdbims","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16395","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\/93220"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16395"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16395\/revisions"}],"predecessor-version":[{"id":16460,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16395\/revisions\/16460"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16395"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}