Data Analysis: [Economics] : CALCULATIONS Comparison of Profitability and Advantages in Telecommunication Industry in the United Kingdom for the past 5 years between Vodafone, BT, TalkTalk and Telecom Plus

We need to get assistance on the data analysis section and leave the data interpretation for the completion.  The data section in calculating the required details using the correlation coefficients in vain. 

Just these details

calculate Return on Equity

Current Ratio

Gearing Ratio

Asset TurnoverRatio

Gross Margin Ratio

Using 
pearson Correlation

Attached below are the details of the dissertation along with an excel file with the data of the company. If you require any information do let me know. The data in the excel sheet are the company’s fundamentals taken from http://sharestobeclosed.telegraph.co.uk/fundamentals/?epic=VODhttp://sharestobeclosed.telegraph.co.uk/fundamentals/?epic=TALKhttp://sharestobeclosed.telegraph.co.uk/fundamentals/?epic=BT.Ahttp://sharestobeclosed.telegraph.co.uk/fundamentals/?epic=TEP

……Also, please don’t forget the calculation of ratios in the excel sheet along with mean and standard deviation

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp