.Regression analysis of weekly returns between NIFTY50 and
\nPolycab India Limited.
\nAuthor: Priya Thakre MBA (Finance)<\/p>\n
Introduction:
\nPolycab is engaged in the business of manufacturing and selling wires and cables and fast moving electrical goods \u2018FMEG\u2019 under the \u2018POLYCAB\u2019 brand. Apart from wires and cables, they manufacture and sell FMEG products such as electric fans, LED lighting and luminaires, switches and switchgear, solar products and conduits & accessories. Their promoters collectively have more than four decades of experience among them. Company was incorporated as \u2018Polycab Wires Private Limited\u2019 on January 10, 1996 at Mumbai as a private limited company under the Companies Act, 1956.<\/p>\n
Objective:
\nTo understand the regression relationship between averages weekly returns of NIFTY50 and Polycab India Limited.<\/p>\n
Data Collection:
\nThe closing price data of Nifty50 and Polycab India Limited was taken from www.nseindia.com (National stock exchange) for the time period from 1st April 2021 to 31st March 2022.
\nFrom the available data, the closing rates of all the Fridays in the year was sorted to find out the weekly returns for both Nifty as well as Polycab India Limited. Then weekly return for both was calculated using Formula:
\nWeekly Return = ((C3-C2)\/C2) *100
\nWhere, C2 is Present week closing price and C1 is previous weeks closing price.
\nOnce the data is calculated, weekly return column for NIFTY50 is considered as X variable and the weekly returns column for Polycab India Limited is considered as Y variable.
\nThe Model and formulas used are:
\nY = a + bX
\nX\u207b = \u2211X\/N
\nY\u207b = \u2211Y\/N
\nx = X – X\u207b
\ny = Y – Y\u207b
\nb = \u2211xy\/ \u2211(x^2)
\na= Y\u207b – bX\u207b
\ne = Y – Y\u207b
\nVariance of error = ((\u03c3e) ^2\/\u2211x^2)
\nT stat for b = b\/ S.E of b
\nTSS = ESS +RSS
\nESS= (b^2) *(\u2211x^2)
\nRSS = \u2211e^2
\nR^2 = ESS\/ TSS
\nF= Mean ESS\/ Mean RSS<\/p>\n
Data Analysis:
\nUtilizing the regression Add-on in Microsoft Excel Data analytics tool below values were acquired:
\nR square= r^2 =0.267024
\nF= 15.30068
\nP value= 0.000329
\nBelow expression shows the relationship model between Polycab and NIFTY50 weekly returns.
\nPolycab Weekly Return = 0.909182-1.332442*(NIFTY50 Weekly Return)
\nY=B+AX
\nA=0.909182
\nB=1.332442
\nY=1.332442+0.909182X
\nt Stat=3.911<\/p>\n
Conclusion:
\nThe above equation tells us the relationship between x and y. If x rises by 1 unit, y will fall by 0.90 units and vise-versa. Figure in bracket that is 3.911 is the t stat for b. The p value for which 0.000329 is less than 0.05. Which means b is statistically significant at 5% level. R\u00b2 is 0.267 which means 26% of y is explained by x. F is 15.300 and the p value 0.000329 is less than 0.05. It means the over all model is statistically significant at 5% level.<\/p>\n","protected":false},"excerpt":{"rendered":"
.Regression analysis of weekly returns between NIFTY50 and Polycab India Limited. Author: Priya Thakre MBA (Finance) Introduction: Polycab is engaged in the business of manufacturing and selling wires and cables and fast moving electrical goods \u2018FMEG\u2019 under the \u2018POLYCAB\u2019 brand. Apart from wires and cables, they manufacture and sell FMEG products such as electric fans,… Continue reading regression analysisof weekly returns between NIFTY50 and Polycan India Limited.<\/span><\/a><\/p>\n","protected":false},"author":93395,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-16433","post","type-post","status-publish","format-standard","hentry","category-management","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16433","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\/93395"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16433"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16433\/revisions"}],"predecessor-version":[{"id":16441,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16433\/revisions\/16441"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16433"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}