Simone is interested in three ASX-listed healthcare companies, Cochlear Ltd. (COH.AX), Ramsay Health Care Ltd. (RHC.AX) and Ansell Ltd. (ANN.AX). Her stock broker collected their year-end adjusted closing prices between 2003 and 2018 (see Stock Prices.xlsx in CloudDeakin Assessment Resources - Group Assignment folder), and Simone asks you to conduct some preliminary analysis.

a. Use EXCEL to calculate the expected return and standard deviation (risk) for these three common shares.