Data1.xlsx 8KB 3. | | I. I I. . You have been given the following share prices of 4 companies. Please use the information below to answer the questions that follow: Date Share1 Shore Share-3 Shore4 28-Sep-20 R 65.00 R 23,00 R 123.00 R 21.00 29-Sep-20 R 66.00 R 24.00 R 121.00 R 13.00 m-m \"m -m 06-Oct-20 R 53.00 R 25.00 R 139.00 R 37.00 most-20R 74.00..- mm- --m Share 1 Share 2 Share 3 Share 4 Calculate R R R R | | | average share price for each share What is | | | arithmetic % 96 95 % growth rate for each share? What is the | | | geometric % IND % % growth rate for each share? What is R R R R the expected share price on the next trading day? Calculate volatility | | | in \"share prices" (standard deviation) Hint: Treat the data as a population and not a sample for this question. You mayr use the attached spreadsheet for the data. Which share should you invest in based on returns? Share Which share should you invest in for the lowest risk? Share