This three photos are one question Show the answer in excel sheet and show the function

L-learang System (Academic Exercise 3 (6 marks) The annual market share prices of ABC and TUN are reported in the below table HOC Share TUN Share 10 12 10 12 31/12/2014 31/12/2015 31/12/2016 31/12/2017 31/12/2018 31/12/2019 14 15 15 17 17 1) Calculate the average returns the variance and the standarden of returns of a portfolio compared by ABC and TUN shares under different proportions mark) Proportion of ABC in portfolio Portfolio variance Vari Portfolio standard deviation Portfolio mean LIR. Search for anything SOU Elemeng System Academid wames below (3 marks Proportion of ABC in portfolio Portfolio variance Var Portfolio standard Portfolio mean ERJ deviation -02 -01 096 109 2014 30% 30% 90% 100 FI Search for anything 90 100% 2) Plot the efficient frontier (1 marks) 3) Plot the price return of Stock ABCIX-ax-00 TUN y Report and interpret the slope of the tegression the value of the intercept and the squared of the regression (2 marks) L-learang System (Academic Exercise 3 (6 marks) The annual market share prices of ABC and TUN are reported in the below table HOC Share TUN Share 10 12 10 12 31/12/2014 31/12/2015 31/12/2016 31/12/2017 31/12/2018 31/12/2019 14 15 15 17 17 1) Calculate the average returns the variance and the standarden of returns of a portfolio compared by ABC and TUN shares under different proportions mark) Proportion of ABC in portfolio Portfolio variance Vari Portfolio standard deviation Portfolio mean LIR. Search for anything SOU Elemeng System Academid wames below (3 marks Proportion of ABC in portfolio Portfolio variance Var Portfolio standard Portfolio mean ERJ deviation -02 -01 096 109 2014 30% 30% 90% 100 FI Search for anything 90 100% 2) Plot the efficient frontier (1 marks) 3) Plot the price return of Stock ABCIX-ax-00 TUN y Report and interpret the slope of the tegression the value of the intercept and the squared of the regression (2 marks)