please visit the spreadsheet link and complete Question 5 and 6 ( The stocks questions ) . Answer in a spreadsheet solution and share the link so I can view the formulas.

https://athabascaedu-my.sharepoint.com/:x:/g/personal/atayieb1_athabasca_edu/EWupILJO5dFPmZeQwdn0piwBkuK9cgsZVuxsjnYIcESjlQ?e=wnjnbY

MGSC301v8 Assignment 2 . . . fx Note: base your answer on calculating the average returns (of both stocks), standard V A B E G H K M N O P Q R S 1 Problem 2 2 An MGSC 301 student is comparing between two stocks to invest in: Stock A and Stock B. The following are the stock returns (in dollars) in the last 10 months (sample). UT A W Monthly Returns 6 Stock A Stock B 25) Compare both stocks in terms of risk and return. Which stock should the student invest in? 7 585 960 Note: ba your answer on calculating the average returns (of both stocks), standard deviations, and coefficient of variations of both stocks. 636 780 5 marks 504 750 10 080 150 675 825 12 525 385 13 765 855 14 885 255 15 585 360 16 510 780 Q6) Calculate the 80th percentile of stocks A and B. 2 marks 17 18 19 20 21 22 23 Problem 2 - 7 Marks Problem 3 - 4 Marks Problem 4 - 9 Marks Problem 5 - 12 Ma +