Finance Questions

Paper instructions:

ANSWER THE QUESTIONS.

Using the data in the Excel file “Weekly Prices” answer the following questions:

A) Compute the historical average, standard deviation, and coefficient of variation of (i) Telstra Corporation Limited (TLS), (ii) Warrnambool Cheese and Butter Factory Company (WCB) and (iii) the Australian Ordinaries Index (AORD), respectively.

B) On different graphs, plot the time-series of weekly prices and returns of TLS, WCB, and AORD, respectively.

***The Excel file has been uploaded***