ROLL NO -13093
SECTION – A
MODULE – QUANTITATIVE TECHNIQUES
PROF. –JAIRAJ GUPTA
SUBMISSION DATE – 2ND AUG 2012
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.
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.
In this project I have used Microsoft excel and stata and did a comparative study of two big companies i.e. TATA COMMUNICATIONS LTD. and BHARTI AIRTEL LTD. Tata communications, is India's largest telecommunicationcompany in international long distance,enterprise data and internet services. Part of the Tata Group, Tata Communications is based in Mumbai and has operations in over 80 cities spread across 40 countries. Through its subsidiary Tyco Global Network , it is also one of the world's largest submarine cable bandwidth providers and has the world's largest network of submarine cables. Bharti airtel ltd on the other hand is is a leading Indian telecommunication service provider through three strategic business units namely Mobile Services, Broadband & Telephone Services and Enterprise Services. The company has started with providing mobile service to single circle entity and now it grown to offer services to all 23 telecom circles of India. One of the largest integrated private telecom service providers with an all India mobile footprint, through a combination of organic and inorganic growth. I have collected the data from yahoo finance and the calculated the monthly returns using that data and then found out various descriptive analysis and made the histogram for the better understanding of a lay man. I have simplified various data and gave the comparative performance of the two companies. In this project I found mean, median, standard deviation, kurtosis, skewness, variance, range of both the companies and did the analytical study and found out that the mean of bharti airtel is more than that of tata communications which means that the average return of bharti airtel is more and the standard deviation is also less in bharti airtel so, the mean of bharti airtel is more accurate i.e. it will not deviate more as compared to tata communications. Thus my project showed that both the companies give good returns but if we take into...