Click here to open the spreadsheet - then open the "Data" worksheet What is the standard deviation of a portfolio with 40% allocated to Walmart and 60% allocated to Amazon over the 5 months in 2020? Answer in % terms w/o % sign and to 4 decimal places (1.2345) X Walmart and Amazon Monthly Returns (1).xlsx Fle Edit Insert Format Help @ Calibri BIUSA ON E K L M (x x) i=1 S = n-1 A B D 1 Walmart Return and Risk 2 Year Year Retum bar 3 2020 January 3.6604 6.0288 4 2020 Febuary -5.9481 224967 5 2020 March 5.9934 518174 Mean (ktsar -1.2050 7 n-1- 2 8 6.3381 9 Using Excel STDEV: 6.3381 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 Datan Wisma Standard Deviation Walmart Roan Didata Amon M 2 3 U Amazon 20 10 Amazon 0.0403, 3.9471 0 -10 -20 ainan Standard Devin Watum som Watch We Amonta M Click here to open the spreadsheet - then open the "Data" worksheet What is the standard deviation of a portfolio with 40% allocated to Walmart and 60% allocated to Amazon over the 5 months in 2020? Answer in % terms w/o % sign and to 4 decimal places (1.2345) X Walmart and Amazon Monthly Returns (1).xlsx Fle Edit Insert Format Help @ Calibri BIUSA ON E K L M (x x) i=1 S = n-1 A B D 1 Walmart Return and Risk 2 Year Year Retum bar 3 2020 January 3.6604 6.0288 4 2020 Febuary -5.9481 224967 5 2020 March 5.9934 518174 Mean (ktsar -1.2050 7 n-1- 2 8 6.3381 9 Using Excel STDEV: 6.3381 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 Datan Wisma Standard Deviation Walmart Roan Didata Amon M 2 3 U Amazon 20 10 Amazon 0.0403, 3.9471 0 -10 -20 ainan Standard Devin Watum som Watch We Amonta M