{"id":15993,"date":"2022-03-18T20:16:37","date_gmt":"2022-03-18T14:46:37","guid":{"rendered":"http:\/\/www.sachdevajk.in\/2022\/03\/18\/regression-analysis-of-axis-banks-stocks-weekly-performance-and-the-weekly-performance-of-nifty-50\/"},"modified":"2022-03-20T10:49:01","modified_gmt":"2022-03-20T05:19:01","slug":"regression-analysis-of-axis-banks-stocks-weekly-performance-and-the-weekly-performance-of-nifty-50","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=15993","title":{"rendered":"Regression analysis of Axis Bank&#8217;s stocks weekly performance and the weekly performance of NIFTY 50"},"content":{"rendered":"<p>Submitted by-Arjya Chandra<br \/>\nSAP ID-80012100761<\/p>\n<p>INTRODUCTION<\/p>\n<p>Axis Bank Limited, formerly known as UTI Bank (1993\u20132007), is an Indian banking and financial services company headquartered in Mumbai, Maharashtra. It sells financial services to large and mid-size companies, SMEs and retail businesses.<\/p>\n<p>As of 30 June 2016, 30.81% shares are owned by the promoters and the promoter group (United India Insurance Company Limited, Oriental Insurance Company Limited, National Insurance Company Limited, New India Assurance Company Ltd, GIC, LIC and UTI). The remaining 69.19% shares are owned by mutual funds, FIIs, banks, insurance companies, corporate bodies and individual investors.<\/p>\n<p>OBJECTIVE<\/p>\n<p>To calculate beta of the company and find its significance.<\/p>\n<p>DATA COLLECTION<\/p>\n<p>Data of index and equity were collected from https:\/\/www1.nseindia.com\/ and https:\/\/www.nseindia.com\/ respectively. Daily returns  from 1st March-2021 to 28 Feb-2022  were downloaded in excel format from these websites and it was sorted into weekly format. Then weekly returns were calculated for both index and equity and then regression analysis was done.<\/p>\n<p>DATA ANALYSIS<\/p>\n<p>Predicted Y = 0.055950625-0.225512786*X<br \/>\nN=46, R Square= 0.014500373, F= 0.647404<br \/>\nTstat  (beta) = -0.804614188<br \/>\nTstat (0.05,45)= 0.093938809<\/p>\n<p>The above regression equation tells us the relationship between X and Y. Where X is NIFTY\u2019s weekly returns and Y is Reliance Industries Ltd\u2019s weekly returns.<br \/>\nThe negative sign of Beta tells us the that there is no positive relationship between NIFTY and Axis bank\u2019s weekly returns.<br \/>\nFrom the equation, it can be seen that if X rises by 1 unit, Y will fall by 0.225512786 units.<br \/>\nT calculated is more that T tabulated which means, \u03b2 is statistically significant at 5% confidence level.<br \/>\nR^2 is 0.014500373 which means 1.45% of Y (Axis Bank) is explained by X. And the balance is explained by error.<br \/>\nF= 0.647404 <\/p>\n<p>CONCLUSION<\/p>\n<p>\u03b2 is not statistically significant in case of NIFTY and Axis Bank ltd. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Submitted by-Arjya Chandra SAP ID-80012100761 INTRODUCTION Axis Bank Limited, formerly known as UTI Bank (1993\u20132007), is an Indian banking and financial services company headquartered in Mumbai, Maharashtra. It sells financial services to large and mid-size companies, SMEs and retail businesses. As of 30 June 2016, 30.81% shares are owned by the promoters and the promoter&hellip; <a class=\"more-link\" href=\"http:\/\/www.sachdevajk.in\/?p=15993\">Continue reading <span class=\"screen-reader-text\">Regression analysis of Axis Bank&#8217;s stocks weekly performance and the weekly performance of NIFTY 50<\/span><\/a><\/p>\n","protected":false},"author":91463,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-15993","post","type-post","status-publish","format-standard","hentry","category-computing","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/15993","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\/91463"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15993"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/15993\/revisions"}],"predecessor-version":[{"id":16134,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/15993\/revisions\/16134"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15993"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}