PLEASE POST EXCEL FORMULAS

Given the data table of year end stock returns below, please fill in the apporpriate information in the ora boxes fo each asset. Please use population statistics when answering for var and std dev. Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Average Variance Std. Dev. Stock A 5.30% 5.90% 2.00% 2.70% 4.00% 5.80% Stock B 3.10% 3.00% 2.70% 2.20% 5.50% 3.30% Stock C 5.00% 3.00% 5.50% 2.80% 4.90% 2.30% Stock D 5.70% 5.00% 3.80% 4.20% 4.50% 5.40% Stock E 4.70% 4.30% 3.80% 3.40% 2.30% 4.50% Stock F 2.50% 10.00% 3.90% 5.70% 1.00% 2.00% Given the data table of year end stock returns below, please fill in the apporpriate information in the oran boxes fo each asset Stock A 11.0% 8.0% 6.0% -6.0% -7.6% 8.0% 6.0% 7.0% 4.3% -5.3% -9.0% Stock B 0.5% -6.0% 5.0% 3.0% 2.0% 7.0% 8.3% 6.5% 9.7% 3.2% -2.0% 3.4% 6.8% 6.7% 5.1% 3.2% 4.6% 9.0% 5.4% 7.2% 1.5% 3.6% 9.8% 6.4% 0.8% Correlation