BY-Nishant Tahiliani
ROLL NO -13093
SECTION – A
MODULE – QUANTITATIVE TECHNIQUES
PROF. –JAIRAJ GUPTA
SUBMISSION DATE – 2ND AUG 2012 ACKNOWLEDGEMENT
I would like to acknowledge some of the many people who have helped with this project. Mr. salim jamadar who is the librarian of isb&m college. He helped me in taking proper utilisation of the books. Mr. jairaj gupta helped me to in making my assessment in stata and microsoft excel he gave me his time as well as expert statistical consultants. I would also like to thank bhavana shwaramani who edited my project.
EXECUTIVE SUMMARY
In this assignment I have done the comparative study of stock prices of tata communications ltd and bharti airtel ltd. And presented them in graphical form also with the help of Microsoft excel and stata. I have made the descriptive study of the stock prices of both the companies and found out the mean, median ,mode ,skewness , kurtosis , standard deviation ,and some other annalysis. and thus made a deep study into the monthly returns of both the companies.
In order to understand the monthly returns in a better way we should 1st know about the companies. BHARTI AIRTEL is one of the world’s leading providers of telecommunication services with presence in 19 countries including India & South Asia and Africa. The Company served an aggregate of 220.9 million customers as on March 31, 2011.
TATA COMMUNICATION is a leading global provider of a new world of communications. Tata Global network includes one of the most advanced technology which is used by them.
While doing this project and compiring the performance of both the companies i have seen that both the companies are running in profit and can fetch adequate amount of returns to the investors but as we compare each and every aspect deeply I can say that bharti airtel ltd is better than tata communications ltd.
Bibliography: DOANE, P.D and SEWARD, E.L 2010.Applied Statistics in Business and Economics. New Delhi: McGraw. Wikipedia.2012.Bharti Airtel [online]. [Accessed 30 July 2012]. Available From: http://en.wikipedia.org/wiki/Bharti_Airtel Wikipedia.2012.Tata Communication [online]. [Accessed 30 July 2012]. Available From: http://en.wikipedia.org/wiki/Tata_Communications Yahoo Finance.2012. Bharti Airtel Ltd. (BHARTIART.NS) [online]. Accessed 30 July 2012]. Available From: http://in.finance.yahoo.com/q?s=BHARTIART.NS&ql=1 Yahoo Finance.2012. Tata Communications Ltd. (TATACOMM.NS) [online]. [Accessed 30 July 2012]. Available From: http://in.finance.yahoo.com/q?s=TATACOMM.NS Bharti Airtel.2012.Bharti Airtel ltd. [online]. Accessed 30 July 2012]. Available From: http://www.airtel.in/wps/wcm/connect/about+bharti+airtel/bharti+airtel/about+bharti+airtel/ Tata Communications.2012.Tata Communications Ltd. [online]. Accessed 30 July 2012]. Available From: http://www.tatacommunications.com/about/overview.asp