{"id":23248,"date":"2025-12-20T22:59:36","date_gmt":"2025-12-20T17:29:36","guid":{"rendered":"http:\/\/www.sachdevajk.in\/?p=23248"},"modified":"2025-12-20T22:59:36","modified_gmt":"2025-12-20T17:29:36","slug":"relationship-of-nifty-50-with-airtel-ltd","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=23248","title":{"rendered":"Relationship of NIFTY 50 with AIRTEL LTD"},"content":{"rendered":"

Prepared By: <\/span><\/p>\n

AUTHOR: – Arshad Shaikh<\/span><\/p>\n

ROLL NO: – 021331025075<\/span><\/p>\n

BATCH: – Operations and Supply Chain Management<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

CONTENTS<\/span><\/b><\/p>\n

\u00a0<\/span><\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

Sl No<\/span><\/b><\/p>\n<\/td>\n

\n

Title<\/span><\/b><\/p>\n<\/td>\n

\n

Page No<\/span><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

Introduction<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

Objective<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

Data Collection<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

4<\/span><\/p>\n<\/td>\n

\n

Literature Review<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

5<\/span><\/p>\n<\/td>\n

\n

Data Analysis<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

6<\/span><\/p>\n<\/td>\n

\n

Conclusion<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

7<\/span><\/p>\n<\/td>\n

\n

References<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

1.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>INTRODUCTION<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Bharti Airtel Limited is one of India\u2019s leading multinational telecommunications companies, providing mobile, broadband, digital TV, and enterprise services.<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Founded in 1995 by Sunil Bharti Mittal, the company is headquartered in New Delhi, India..<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Airtel operates in India, South Asia, and several African countries, serving hundreds of millions of customers.<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>It is among the top telecom operators in India, known for strong network coverage, 4G\/5G services, and digital platforms like Airtel Payments Bank and Airtel Thanks.<\/span><\/p>\n

2.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>OBJECTIVE<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>To calculate \u03b2 of Airtel LTD and observe its significance.<\/span><\/p>\n

3.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>DATA COLLECTION<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Historical data of Airtel LTD and NIFTY50 index data (downloaded from NSE website for the period 01-Dec-24 to 30-Nov-2025).<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>The data was manipulated to get Friday closing prices.<\/span><\/p>\n

4.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>LITERATURE REVIEW<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Bharti Airtel Annual Report (2022) explains how the company\u2019s strategic focus on network expansion, digital services, and customer experience has strengthened its market position and supported long-term growth in the Indian telecom sector.<\/span><\/p>\n

5.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>DATA ANALYSIS<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Regression Equation: – Y = a + bx<\/span><\/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 <\/span>where: –<\/span><\/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\u00a0 <\/span>y = Weekly Return for Airtel LTD<\/span><\/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\u00a0 <\/span>x = Weekly Return for NIFTY<\/span><\/p>\n

This equation tells us that if weekly returns of NIFTY increases, then weekly return for Airtel LTD also increases.<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Number of Observations = 247<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>t-stat for \u03b2 = 0.3666<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>p-value = 0.54545 <\/span>\u00e8<\/span><\/span> This indicates that since the p-value is greater than 0.05, \u03b2 is not statistically significant, even at the 5% level.<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>R2<\/sup> = 0.0015 <\/span>\u00e8<\/span><\/span> This indicates that only about 0.15% of the variation in the weekly returns of Airtel LTD is explained by the weekly returns of NIFTY. The remaining 99.85% variation is due to other factors not included in the model.<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>F = 0.3666 Since the F-value is very low and statistically insignificant, the overall regression model is not statistically significant.<\/span><\/p>\n

6.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>CONCLUSION<\/span><\/p>\n

It is not suitable for short-term investment decisions based solely on market (NIFTY) rise.<\/span><\/p>\n

7.\u00a0\u00a0\u00a0 <\/span><\/span><\/span>REFERENCES<\/span><\/p>\n

1.\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Bharti Airtel Ltd. (2022). Annual Report of Bharti Airtel Limited<\/i>. Bharti Airtel Publications, New Delhi.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Prepared By: AUTHOR: – Arshad Shaikh ROLL NO: – 021331025075 BATCH: – Operations and Supply Chain Management \u00a0 \u00a0 CONTENTS \u00a0 Sl No Title Page No 1 Introduction 1 2 Objective 1 3 Data Collection 1 4 Literature Review 1 5 Data Analysis 1 6 Conclusion 1 7 References 1 \u00a0 \u00a0 1.\u00a0\u00a0\u00a0 INTRODUCTION \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0… Continue reading Relationship of NIFTY 50 with AIRTEL LTD<\/span><\/a><\/p>\n","protected":false},"author":139933,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-23248","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/23248","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\/139933"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23248"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/23248\/revisions"}],"predecessor-version":[{"id":23249,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/23248\/revisions\/23249"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23248"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}