please help. second picture is the row headings, the third photo is the last 5 months. thank you

Question 1 1 pts 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) ... AT&T 3:34 PM 33% Done Walmart and Amazon Monthly Re... Data Walmart Standard Deviation Date WMT 1/29/10 -0.0374 2/26/10 1.1978 3/31/10 3.4097 4/30/10 -3.5252 5/31/10 -5.1987 6/30/10 -4.9248 7/30/10 6.4905 8/31/10 -1.4704 9/30/10 6.7411 10/29/10 1.2145 11/30/10 -0.1477 12/31/10 0.2577 1/31/11 3.9681 2/28/11 -7.2945 3/31/11 0.8286 4/29/11 5.6292 5/31/11 1.101 6/30/11 -3.7668 7/29/11 -0.8092 8/31/11 1.6715 9/30/11 -2.4253 10/31/11 9.2871 11/30/11 3.8434 12/30/11 2.093 1/31/12 2.6774 2/29/12 -3.7158 3/30/12 4.2773 4/30/12 -3.7418 5/31/12 12.4821 6/29/12 5.9253 7/31/12 6.7556 8/31/12 -1.9369 9/28/12 1.6529 AMZN SP500 Portfolio -6.7722 -3.5971 -3.4048 -5.5897 3.0956 -2.19595 14.6706 6.0347 9.04015 0.9796 1.578 -1.2728 -8.4902 -7.9848 -6.84445 - 12.9125 -5.2355 -8.91865 7.8986 7.0059 7.19455 5.8868 -4.5147 2.2082 25.8191 8.924 16.2801 5.2018 3.8048 3.20815 6.1551 0.012 3.0037 2.6226 6.6837 1.44015 -5.7556 2.3697 -0.89375 2.1516 3.4251 -2.57145 3.9471 0.0403 2.38785 8.7048 2.9607 7.167 0.4494 -1.1323 0.7752 3.9656 -1.667 0.0994 8.8171 -2.0341 4.00395 -3.2761 -5.433 -0.8023 0.4646 -7.0296 -0.98035 -1.2579 10.9292 4.0146 -9.9386 -0.222 -3.0476 -9.9797 1.021 -3.94335 12.3281 4.4812 7.50275 -7.5859 4.3242 -5.65085 12.6996 3.2853 8.48845 14.5129 -0.6283 5.38555 -8.1889 -6.0099 2.1466 7.2519 4.1204 6.5886 2.1677 1.3886 4.46165 6.4166 2.2542 2.23985 2.4369 2.5839 2.0449 33% ... AT&T 3:34 PM Done Walmart and Amazon Monthly Re... 5/31/17 5.2443 7.5276 1.4072 6.38595 6/30/17 -3.715 -2.6764 0.6241 -3.1957 7/31/17 5.695 2.0434 2.0562 3.8692 8/31/17 -1.7904 -0.7269 0.3061 -1.25865 9/29/17 0.0897 -1.9631 2.0628 -0.9367 10/31/17 11.7353 14.9717 2.3334 13.3535 11/30/17 11.3618 6.4662 3.0671 8.914 12/29/17 2.0985 -0.6187 1.1047 0.7399 1/31/18 7.9494 24.0639 5.7232 16.00665 2/28/18 -15.5629 4.2429 -3.686 -5.66 3/30/18 -0.5708 -4.3049 -2.5412 -2.43785 4/30/18 -0.5732 8.2075 0.3836 3.81715 5/31/18 -6.1055 4.0539 2.4077 -1.0258 6/29/18 3.7679 4.3065 0.6155 4.0372 7/31/18 4.1798 4.5676 3.7215 4.3737 8/31/18 8.0578 13.2365 3.2583 10.64715 9/28/18 -2.0342 -0.4824 0.5692 -1.2583 10/31/18 6.7831 -20.2192 -6.8352 -6.71805 11/30/18 -2.6227 5.7672 2.0375 1.57225 12/31/18 -4.0849 - 11.135 -9.0332 -7.60995 1/31/19 2.8771 14.4317 8.0134 8.6544 2/28/19 3.2975 -4.5906 3.2108 -0.64655 3/29/19 -0.9433 8.5936 1.9432 3.82515 4/30/19 5.4445 8.1859 4.0489 6.8152 5/31/19 -0.8361 -7.8613 -6.3549 -4.3487 6/28/19 8.9215 6.6792 7.0477 7.80035 7/31/19 -0.0996 -1.4179 1.4373 -0.75875 8/30/19 4.0207 -4.8474 -1.584 -0.41335 9/30/19 3.8684 -2.2733 1.8711 0.79755 10/31/19 -1.1965 2.3475 2.1657 0.5755 11/29/19 1.5606 1.3587 3.63 1.45965 12/31/19 0.2358 2.6122 3.0115 1.424 1/31/20 -3.6604 8.7064 -0.0439 2.523 2/28/20 -5.9481 -6.2214 -8.2321 -6.08475 3/31/20 5.9934 3.5021 -12.3512 4.74775 4/30/20 6.9794 26.89 12.8194 16.9347 5/29/20 2.5172 -1.2785 4.763 0.61935 NA Question 1 1 pts 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) ... AT&T 3:34 PM 33% Done Walmart and Amazon Monthly Re... Data Walmart Standard Deviation Date WMT 1/29/10 -0.0374 2/26/10 1.1978 3/31/10 3.4097 4/30/10 -3.5252 5/31/10 -5.1987 6/30/10 -4.9248 7/30/10 6.4905 8/31/10 -1.4704 9/30/10 6.7411 10/29/10 1.2145 11/30/10 -0.1477 12/31/10 0.2577 1/31/11 3.9681 2/28/11 -7.2945 3/31/11 0.8286 4/29/11 5.6292 5/31/11 1.101 6/30/11 -3.7668 7/29/11 -0.8092 8/31/11 1.6715 9/30/11 -2.4253 10/31/11 9.2871 11/30/11 3.8434 12/30/11 2.093 1/31/12 2.6774 2/29/12 -3.7158 3/30/12 4.2773 4/30/12 -3.7418 5/31/12 12.4821 6/29/12 5.9253 7/31/12 6.7556 8/31/12 -1.9369 9/28/12 1.6529 AMZN SP500 Portfolio -6.7722 -3.5971 -3.4048 -5.5897 3.0956 -2.19595 14.6706 6.0347 9.04015 0.9796 1.578 -1.2728 -8.4902 -7.9848 -6.84445 - 12.9125 -5.2355 -8.91865 7.8986 7.0059 7.19455 5.8868 -4.5147 2.2082 25.8191 8.924 16.2801 5.2018 3.8048 3.20815 6.1551 0.012 3.0037 2.6226 6.6837 1.44015 -5.7556 2.3697 -0.89375 2.1516 3.4251 -2.57145 3.9471 0.0403 2.38785 8.7048 2.9607 7.167 0.4494 -1.1323 0.7752 3.9656 -1.667 0.0994 8.8171 -2.0341 4.00395 -3.2761 -5.433 -0.8023 0.4646 -7.0296 -0.98035 -1.2579 10.9292 4.0146 -9.9386 -0.222 -3.0476 -9.9797 1.021 -3.94335 12.3281 4.4812 7.50275 -7.5859 4.3242 -5.65085 12.6996 3.2853 8.48845 14.5129 -0.6283 5.38555 -8.1889 -6.0099 2.1466 7.2519 4.1204 6.5886 2.1677 1.3886 4.46165 6.4166 2.2542 2.23985 2.4369 2.5839 2.0449 33% ... AT&T 3:34 PM Done Walmart and Amazon Monthly Re... 5/31/17 5.2443 7.5276 1.4072 6.38595 6/30/17 -3.715 -2.6764 0.6241 -3.1957 7/31/17 5.695 2.0434 2.0562 3.8692 8/31/17 -1.7904 -0.7269 0.3061 -1.25865 9/29/17 0.0897 -1.9631 2.0628 -0.9367 10/31/17 11.7353 14.9717 2.3334 13.3535 11/30/17 11.3618 6.4662 3.0671 8.914 12/29/17 2.0985 -0.6187 1.1047 0.7399 1/31/18 7.9494 24.0639 5.7232 16.00665 2/28/18 -15.5629 4.2429 -3.686 -5.66 3/30/18 -0.5708 -4.3049 -2.5412 -2.43785 4/30/18 -0.5732 8.2075 0.3836 3.81715 5/31/18 -6.1055 4.0539 2.4077 -1.0258 6/29/18 3.7679 4.3065 0.6155 4.0372 7/31/18 4.1798 4.5676 3.7215 4.3737 8/31/18 8.0578 13.2365 3.2583 10.64715 9/28/18 -2.0342 -0.4824 0.5692 -1.2583 10/31/18 6.7831 -20.2192 -6.8352 -6.71805 11/30/18 -2.6227 5.7672 2.0375 1.57225 12/31/18 -4.0849 - 11.135 -9.0332 -7.60995 1/31/19 2.8771 14.4317 8.0134 8.6544 2/28/19 3.2975 -4.5906 3.2108 -0.64655 3/29/19 -0.9433 8.5936 1.9432 3.82515 4/30/19 5.4445 8.1859 4.0489 6.8152 5/31/19 -0.8361 -7.8613 -6.3549 -4.3487 6/28/19 8.9215 6.6792 7.0477 7.80035 7/31/19 -0.0996 -1.4179 1.4373 -0.75875 8/30/19 4.0207 -4.8474 -1.584 -0.41335 9/30/19 3.8684 -2.2733 1.8711 0.79755 10/31/19 -1.1965 2.3475 2.1657 0.5755 11/29/19 1.5606 1.3587 3.63 1.45965 12/31/19 0.2358 2.6122 3.0115 1.424 1/31/20 -3.6604 8.7064 -0.0439 2.523 2/28/20 -5.9481 -6.2214 -8.2321 -6.08475 3/31/20 5.9934 3.5021 -12.3512 4.74775 4/30/20 6.9794 26.89 12.8194 16.9347 5/29/20 2.5172 -1.2785 4.763 0.61935 NA