{"id":17459,"date":"2023-04-18T19:28:45","date_gmt":"2023-04-18T13:58:45","guid":{"rendered":"http:\/\/www.sachdevajk.in\/2023\/04\/18\/relationship-of-spicejet-limited-with-nifty-50\/"},"modified":"2023-04-19T07:46:59","modified_gmt":"2023-04-19T02:16:59","slug":"relationship-of-spicejet-limited-with-nifty-50","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=17459","title":{"rendered":"Relationship of SpiceJet Limited with Nifty 50"},"content":{"rendered":"<p>Regression Analysis of Weekly Returns between NIFTY50 and SpiceJet Ltd.<\/p>\n<p>Title- Relationship of SpiceJet Limited with Nifty 50<br \/>\nAuthor- Siddhi R. Dhole<br \/>\nIntroduction- SpiceJet is an Indian budget airline headquartered in Gurgaon, Haryana. It is the second-largest airline in India by number of domestic passengers carried, with a market share of 13.6% as of March 2019. The airline operates 630 daily flights to 64 destinations, including 54 Indian and 15 international destinations from its bases at Delhi and Hyderabad.<br \/>\nObjectives- Calculation of Beta of Spicejet Limited &amp; its significance<br \/>\nLiterature review-<br \/>\n1.\tSurvivor Stocks<br \/>\nSurvivor stocks tend to be small-value stocks that exhibit high profitability and invest conservatively. Surprisingly, survivor stocks tend to be loser stocks with negative exposure to the momentum factor. Further the volatility of the survivor stocks portfolio is less exposed to tail risks and responds less to shocks in the innovation process. (Grobys, 2022)<br \/>\n2.\t Stock index<br \/>\nCointegrating relationships between each combination of series examined. The analysis reveals a higher level of causality than found in previous research. Bidirectional Granger causality for every index pairwise combination examined. (Jalbert, 2015)<br \/>\nData collection- The closing price data of Nifty50 and Spicejet Limited was taken from https:\/\/finance.yahoo.com (Yahoo Finance) for the time period 1ST APRIL 2022 to 31ST MARCH 2023.<br \/>\nFrom the available data, the closing rates of all the Fridays in the year was sorted to find out weekly returns for both Nifty as well as Spicejet Limited then the weekly returns were calculated for both.<br \/>\nWeekly return = (B3-B2)\/B2 *(100)<br \/>\nWhere B3 represent week closing price and B2 is previous week closing price.<br \/>\nOnce the data is calculated, weekly return column for NIFTY50 is considered as \u201cX\u201d variable and the weekly returns column for Spicejet Limited is considered as \u201cY\u201d variable.<br \/>\nData Analysis- Utilizing the Regression Add-on in Microsoft Excel Data Analytics tool below values was acquired<br \/>\nR Square = R^2 = 0.120664<br \/>\na = -1.124098841<br \/>\nb = 1.099202138<br \/>\nF = 6.449407676<br \/>\nP value = 0.014465934<br \/>\nN= 49<br \/>\nBelow expression shows the relationship model between Spicejet Limited and NIFTY 50 weekly returns:<br \/>\nWe can write the equation in the form of Y = a + b(X)<br \/>\nWhere, Y = Spicejet Ltd<br \/>\n             X = Nifty-50 Returns<br \/>\n            a = intercept and b = slope<br \/>\nSpicejet Ltd Weekly Return = -1.124098841 + 1.099202138*(NIFTY50 Weekly Return)\t                                                           (2.539568403)<br \/>\nConclusion- The above equation in the Data analysis explains us the relationship between X (Nifty-50 Returns) and Y (Spicejet Ltd).<br \/>\n If X rises by 1 unit, then Y will rise by 1.1 units and vice versa.<br \/>\nFigure in bracket just below the equation i.e. (2.539568403) is the value for t-stat for b for which the p-value is 0.014465934, which is less than 0.05 implies that b is not statistically significant at 5% significant level.<br \/>\nR2 is 0.120663782 which means 12% of Y is explained by X and remaining 88% is error.<br \/>\nThe value of F is 6.449407676 and the p-value for which is 0.014465934, which is less than 0.05, which means the overall model is statistically significant at 5% significant level or 95% confidence level.<br \/>\nAs Beta 1.099202 is greater than 1, the company is good for short-term investments.<br \/>\nReferences-<br \/>\n1.\tKlaus Grobys, 2022. &#8220;On Survivor Stocks in the S&amp;P 500 Stock Index,&#8221; JRFM, MDPI, vol. 15(2), pages 1-24, February.<\/p>\n<p>2.\tTerrance Jalbert, 2015. &#8220;Currency-Adjusted Stock Index Causality,&#8221; The International Journal of Business and Finance Research, The Institute for Business and Finance Research, vol. 9(5), pages 83-91.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regression Analysis of Weekly Returns between NIFTY50 and SpiceJet Ltd. Title- Relationship of SpiceJet Limited with Nifty 50 Author- Siddhi R. Dhole Introduction- SpiceJet is an Indian budget airline headquartered in Gurgaon, Haryana. It is the second-largest airline in India by number of domestic passengers carried, with a market share of 13.6% as of March&hellip; <a class=\"more-link\" href=\"http:\/\/www.sachdevajk.in\/?p=17459\">Continue reading <span class=\"screen-reader-text\">Relationship of SpiceJet Limited with Nifty 50<\/span><\/a><\/p>\n","protected":false},"author":112009,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-17459","post","type-post","status-publish","format-standard","hentry","category-investing","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/17459","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\/112009"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17459"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/17459\/revisions"}],"predecessor-version":[{"id":17519,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/17459\/revisions\/17519"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17459"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}