Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Click here to open the spreadsheet - then open the Data worksheet. What is the standard deviation of a portfolio with 40% allocated to Walmart

image text in transcribed
image text in transcribed
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) Date WMT AMZN SP500 Portfolio >7>0/10 -0.700 -4.3049 -2.3412 -2.43703 1 4/30/18 -0.5732 8.2075 0.3836 3.81715 e 5/31/18 -6.1055 4.0539 2.4077 -1.0258 3 6/29/18 3.7679 4.3065 0.6155 4.0372 7/31/18 4.1798 4.5676 3.7215 4.3737 5 8/31/18 8.0578 13.2365 3.2583 10.64715 5 9/28/18 -2.0342 -0.4824 0.5692 -1.2583 10/31/18 6.7831 -20.2192 6.8352 -6.71805 3 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 1 2/28/19 3.2975 -4.5906 3.2108 -0.64655 3/29/19 -0.9433 8.5936 1.9432 3.82515 3 4/30/19 5.4445 8.1859 4.0489 6.8152 5/31/19 -0.8361 -7.8613 -6.3549 -4.3487 5 6/28/19 8.9215 6.6792 7.0477 7.80035 5 7/31/19 -0.0996 -1.4179 1.4373 -0.75875 - 8/30/19 4.0207 -4.8474 -1.584 -0.41335 3 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 1 12/31/19 0.2358 2.6122 3.0115 1.424 1/31/20 -3.6604 8.7064 -0.0439 2.523 3 2/28/20 -5.9481 -6.2214 -8.2321 -6.08475 . 3/31/20 5.9934 3.5021 -12.3512 -12.3512 4.74775 5 4/30/20 6.9794 26.89 12.8194 16.9347 5/29/20 2.5172 -1.2785 4.763 0.61935

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Money And Capital Markets

Authors: Peter Rose, Milton Marquis

10th Edition

0077235800, 9780077235802

More Books

Students also viewed these Finance questions

Question

5 What are the ongoing challenges for HRM?

Answered: 1 week ago

Question

4 What typifies the first and second waves of HRM?

Answered: 1 week ago