Please do it in excel file and attach file in answer.

Financial Management and Application Lecture#3 and 4 Risk and Return on investment Q No. 1 Two stock prices for six days are given below. Price B 60 65 Price A 45 50 54 48 41 61 63 61 50 45) Calculate: 1. Average return of both stock 2. Standard deviation of each stock 3. Coefficient of Variation of each stock 4. Which stock is less risky based on Standard deviation? 5. Which stock you will select based on Coefficient of variation