Monthly; Values for the Market Index and the Two Traded Shares. m -i; :31! IE! '- U'l (:1 '--l I D '3 _Ju '4 .- Ell-III- Ell-III. Ell-III- Ell-III- Ell-III- Ell-III- Ell-III- _ Ell-ll- Ell-II- El-I-I- Ell-ll- Ell-II- llllll Ell-ll- _ ElI-I-I Ell-ll- Ell-II- HUI-I.- Ell-l.- _ EI-I-I- "' \".5 1i? E 3.3.5.5 8 2E 55333-;8333 M _|. M _L -L _L _L _L _L _L _l. '- rm H w PF? we \"mw PE iiiiiiiiiiiiiii M P" In: Please make the fullewing calwlaune using the eiatiecal funcuns an Excel: 1. Convert the price data into returns on a month to month basis. You should have 23 returns for the market and the eve shares alter you complete this prooess. 2. Mean {expected} return and standard deviation for the stock market and the two cormanias 3. The oeetticient ot variation for the market and the tvro oomoenies. at. \"the oorrelation ceetticient oehveen News Media and HR Ftesouroes Ltd. 5. The standard deviation of returns tor a portfolio consisting of News Media Ltd and HR Resources Ltd {assume equal weightings}. ti. Beta ooet'licient oatmlation for both News Media and HR Resources Ltd. Please also produce an approximatelyI see word report that comments on the results calculated above. The report will need to rater to each statistic calmlated and intamret {not llmph' Willi your results} the result and make corrlparisons amongst the market index and the two corripantes. Your team is required to specicaltv address vrhat each statistic is actualhrr rnaasuring and its implicalidns from a risk and reborn viewpoint. You will also need to focus. on the impact of creating a portfolio of tare shares and the irnplioahons for risk reduction {You will need to provide some quantitative evidence of risk reduction}. Putnam-ore. the Beta of each EDITH"? needs to assessed and interpreted in the context of asset pricing. That is, what is the implication for risk and remired return and what irripect Iill-ill this have on the asset's price