can anyone please complete blank boxes? please show formulas used

Nm in 10 11 12 13 "Formula" means using cell addresses and math operators, such as +, -, etc. "Function" means a shortcut provided by an excel: "=Function(inputs)" AAPL GOOG Portfolio Returns 2010 12.0% -20.2% Part 2: For each year, compute the return on a portfolio that is -0.041 2010 2011 20.9% 34.2% 50% invested in AAPL and 50% In GOOG 0.2755 2011 2012 5.7% 18.7% 0.122 2012 2013 23.6% 28.9% 0.2625 2013 2014 18.8% 26.6% 2a. Compute the average return on the 50/50 portfolio 0.227 2014 2015 25.5% 17.4% b.compute the variance 0.2145 2015 2016 - 19.4% - 14.4% c. compute the standard deviation -0.169 2016 2017 -11.6% -8.5% d. compute the CAGR -0.1005 2017 2018 10.1% 0.089 2018 2019 -6.1% - 12.2% -0.0915 2019 2020 10.1% 14.5% 0.123 2020 Part 1 - compute the statistics below as indicated 0.082864 Average (mean) return on the portfolio MEAN 8.15% 8.43% Use any method you choose 0.025346 Variance of returns MEDIAN 10.10% 14.50% 0.159206 Std deviation of returns VARIANCE 0.0244 0.0405 compute the variance using your own formulas CAGR of portfolio VARIANCE 0.021962673 0.03690 compute the variance using the excel function VAR.S STD DEV 0.1482 0.1921 compute thesd as the square root of the variance STD DEV 0.148198086 0.1921 compute the sduuing the excel function STDEVS CAGR compute the compound average growth rate (CAGR) You can use any method you choose 7.7% 14 15 16 17 18 19 20 21 22 23 24 4. Compute the covariance and the correlation between AAPL and GOOG 25 Covariance 0.021263 0.746945 Correlation 26 27 S. Compute the expected return and std dev. of a portfolio that is 60% invested 28 in AAPL and 40% invested in GOOG. Use the formula from class. show your work, 29 Expected return 30 CAGR 31 variance of portfolio standard deviation 32 33 34 35 36 stats review problems +