Abbi is a final year student in OxfordUniversity doing her dissertation. After discussing with her supervisor, her research objective is to estimate the relationship between returns of stocks and...

Abbi is a final year student in OxfordUniversity doing her dissertation. After discussing with her supervisor, her research objective is to estimate the relationship between returns of stocks and level of risk of stocks (i.e. standard deviation of stock returns). Abbi is using primary data and secondary data for her research.

a). List 3 main sources to collect primary data and secondary data, respectively;

b)

1. Abbi collected the below data from Thomson Reuters Eikon of Tesco. How much is

• Arithmetic mean of the stock price?


• The median of the stock price?


• The monthly percentage change on 01/04/2020?

c). What is the best type of chart to represent the variable Tesco Stock Price?

d). In her dissertation, Abbi states that primary data is qualitative data. Is it correct? If not, how would you explain to Abbi?

Make calculations in excel and explain why did you choose this formula. Put explanations (answers) for each question. Thank you in advance.