How to Solve this problem by using Excel sheet and Excel Formula?

6. For the next problem, you can copy the table and put in your excel sheet and use excel functions to answer the questions. (See next page.) July-18 June-18 May-18 April-18 March-18 February-18 January-18 December-19 November-19 October-19 September-19 August 19 July-19 June-19 May-19 April-19 March-19 February-19 January-19 Stock A -1.5404% 3.4190% 2.1250% -0.5217% 4.4222% 3.3664% 2.8689% -5.3373% -0.5226% 1.9435% -0.8567% 2.3256% 2.1322% -3.8176% 2.9520% -1.4793% 4.5715% -3.6469% -5.7934% Stock B -2.9565% 7.4866% 4.8750% 0.4696% -0.7911% 1.8129% 2.4164% -8.6623% -2.4917% 14.3209% -2.3294% 5.0558% 4.9851% -0.5446% 3.1327% -0.0710% 2.2001% -8.1057% -1.1108% Determine the mean and standard deviation of the following portfolios using the template below that is to be pasted in your excel sheet: Expected return Variance Standard Dev Naoo 16. For the next problem, you can copy the table and put in your excel sheet and use excel functions to answer the questions. (See next page.) 9 Date July-18 June-18 May-18 April-18 March-18 February-18 January-18 December-19 November-19 October-19 September-19 August 19 July-19 June-19 May-19 April-19 March-19 February-19 January 19 Stock A -1.54% 3.42% 2.13% -0.52% 4.42% 3.37% 2.87% -5.34% -0.52% 1.9496 -0.86% 2.33% 2.13% -3.82% 2.95% -1.4896 4.57% -3.65% -5.79% Stock B -2.96% 7.49% 4.88% 0.4796 -0.79% 1.81% 2.4296 -8.66%6 -2.4996 14.32% -2.33% 5.0696 4.99% -0.54% 3.13% -0.07% 2.20% -8.11% -1.11% 169 170 171 172 173 174 175 177 180 181 182 183 Determine the mean and standard deviation of the following portfolios using the template below that is to be pasted in your excel sheet: Expected re Variance Standard Dev w 0.8 0.6 0.2 0.4 0.6 0.8 0.4 0.2 6. For the next problem, you can copy the table and put in your excel sheet and use excel functions to answer the questions. (See next page.) July-18 June-18 May-18 April-18 March-18 February-18 January-18 December-19 November-19 October-19 September-19 August 19 July-19 June-19 May-19 April-19 March-19 February-19 January-19 Stock A -1.5404% 3.4190% 2.1250% -0.5217% 4.4222% 3.3664% 2.8689% -5.3373% -0.5226% 1.9435% -0.8567% 2.3256% 2.1322% -3.8176% 2.9520% -1.4793% 4.5715% -3.6469% -5.7934% Stock B -2.9565% 7.4866% 4.8750% 0.4696% -0.7911% 1.8129% 2.4164% -8.6623% -2.4917% 14.3209% -2.3294% 5.0558% 4.9851% -0.5446% 3.1327% -0.0710% 2.2001% -8.1057% -1.1108% Determine the mean and standard deviation of the following portfolios using the template below that is to be pasted in your excel sheet: Expected return Variance Standard Dev Naoo 16. For the next problem, you can copy the table and put in your excel sheet and use excel functions to answer the questions. (See next page.) 9 Date July-18 June-18 May-18 April-18 March-18 February-18 January-18 December-19 November-19 October-19 September-19 August 19 July-19 June-19 May-19 April-19 March-19 February-19 January 19 Stock A -1.54% 3.42% 2.13% -0.52% 4.42% 3.37% 2.87% -5.34% -0.52% 1.9496 -0.86% 2.33% 2.13% -3.82% 2.95% -1.4896 4.57% -3.65% -5.79% Stock B -2.96% 7.49% 4.88% 0.4796 -0.79% 1.81% 2.4296 -8.66%6 -2.4996 14.32% -2.33% 5.0696 4.99% -0.54% 3.13% -0.07% 2.20% -8.11% -1.11% 169 170 171 172 173 174 175 177 180 181 182 183 Determine the mean and standard deviation of the following portfolios using the template below that is to be pasted in your excel sheet: Expected re Variance Standard Dev w 0.8 0.6 0.2 0.4 0.6 0.8 0.4 0.2