{"id":19481,"date":"2023-12-27T19:49:36","date_gmt":"2023-12-27T14:19:36","guid":{"rendered":"http:\/\/www.sachdevajk.in\/?p=19481"},"modified":"2023-12-27T19:49:36","modified_gmt":"2023-12-27T14:19:36","slug":"relationship-of-bhartiairtel-with-nifty50","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=19481","title":{"rendered":"Relationship of BhartiAirtel with Nifty50"},"content":{"rendered":"

Relation between Nifty and Bharti Airtel<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

AUTHOR: <\/strong>–<\/strong> Aritra Das<\/p>\n

Introduction: – <\/strong><\/p>\n

Bharti Airtel Limited, also known as Airtel, is\u00a0a multinational telecommunications company based in New Delhi.\u00a0It operates in 18 countries across South Asia and Africa, as well as the Channel Islands.\u00a0<\/p>\n

Airtel is Asia’s leading integrated telecom services provider with operations in India and Sri Lanka.\u00a0It provides 5G, 4G, and LTE Advanced services all over India.\u00a0<\/p>\n

Airtel offers a range of products and services, including voice, data, collaboration, cloud, data centers, security, IoT, network integration, managed services, enterprise mobility, and digital media.\u00a0<\/p>\n

Airtel was incorporated on July 7, 1995, and is the flagship company of Bharti Enterprises.\u00a0<\/p>\n

\u00a0<\/p>\n

Objective: – <\/strong><\/p>\n

To Calculate Beta(\u03b2) and its significance of the equity stock of Bharti Airtel.<\/strong><\/p>\n

\u00a0<\/p>\n

Reviews: –<\/strong><\/p>\n

Katrina and Aamir Emerged Most Downloaded Celebrities Among Airtel Users<\/p>\n

According to a 2023 Gartner review,\u00a0Airtel is a market leader in mobile and internet networks, with great customer support.\u00a0However, another review from March 2023 says that the 4G network is unstable, with speeds that fluctuate between too fast and too slow.\u00a0The reviewer also says that Airtel is not cost-effective.\u00a0<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

\u00a0<\/p>\n

Data Collection: –<\/strong><\/p>\n

Data was downloaded from nseindia.com and yahoo finance.com for 01\/11\/2022 to 31\/10\/2023 for Nifty as well as for Bharti Airtel. Weekly return of Nifty is termed as \u201cX\u201d and weekly return of NMDC is termed as \u201cY\u201d. Besides that, a few other things written in this report are taken from other websites and its information is provided in references. All the columns were deleted for both the sheets except date and closing price and the Friday closing price were found for both. Returns for X and Y were calculated, X being Nifty and Y being Bharti Airtel. Finally, data analysis was done.<\/p>\n

Data Analysis: –<\/strong><\/p>\n

The regression equation has the form:<\/p>\n

Y = a + b*X<\/p>\n

Where, Y is the dependent variable,<\/p>\n

\u00a0 X is the independent variable,<\/p>\n

\u00a0 a is the intercept,<\/p>\n

\u00a0 b is the slope.<\/p>\n

In our case Bharti Airtel is the dependent variable and Nifty50 is the independent variable.<\/p>\n

Intercept, a = 0.166455848<\/p>\n

Slope, b = 0.762406924<\/p>\n

R Square = 0.284228932<\/p>\n

So, the regression equation is given by-<\/p>\n

Y (Bharti Airtel) = 0.166+0.762*X (Nifty)<\/strong><\/p>\n

Interpretation:<\/strong><\/p>\n

\u00a0The above equation shows the relation between Nifty50 and Bharti Airtel.<\/p>\n

Return of Airtel is dependent variable and return of Nifty50 is independent variable.<\/p>\n

The positive (+) sign means if Nifty50 rises by 1 unit then share price of Airtel will also rise by 0.762 and vice-versa.<\/p>\n

\u00a0t-stat for b (coefficient of Y) is = 4.320 and the p-value is = 0.00.<\/p>\n

No. of Observations are 49.<\/p>\n

R square is 0.284 which means 28% of variances are explained by Nifty.<\/p>\n

Hence. the standard error is 173% . This is happened due to the variable which are not in the model.<\/p>\n

Here F is 18.66345317 and the P value is 0.00 which means overall model is statistically significant .<\/p>\n

\u00a0<\/strong><\/p>\n

Conclusion: –<\/strong><\/p>\n

Beta is 0.762407, which is Less than 1, it means Bharti Airtel is good for Long-term investment.<\/p>\n

\u00a0<\/p>\n

Reference: –<\/strong><\/p>\n

https:\/\/www.nseindia.com\/<\/a><\/p>\n

https:\/\/finance.yahoo.com\/<\/a><\/p>\n

https:\/\/www.airtel.com\/<\/a><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

Relation between Nifty and Bharti Airtel \u00a0 AUTHOR: – Aritra Das Introduction: – Bharti Airtel Limited, also known as Airtel, is\u00a0a multinational telecommunications company based in New Delhi.\u00a0It operates in 18 countries across South Asia and Africa, as well as the Channel Islands.\u00a0 Airtel is Asia’s leading integrated telecom services provider with operations in India… Continue reading Relationship of BhartiAirtel with Nifty50<\/span><\/a><\/p>\n","protected":false},"author":139145,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[1871,56],"class_list":["post-19481","post","type-post","status-publish","format-standard","hentry","category-business","tag-bhartiaritel","tag-nifty-50","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/19481","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\/139145"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19481"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/19481\/revisions"}],"predecessor-version":[{"id":19482,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/19481\/revisions\/19482"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19481"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}