Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the question is attached, need help. Thanks in advance Name Class Id Section E-Mail Address Score 0/100 Problem Problem 1 Answer Correct Answer Score Full
the question is attached, need help. Thanks in advance
Name Class Id Section E-Mail Address Score 0/100 Problem Problem 1 Answer Correct Answer Score Full Score Comments Avg. Stdev WMT MS 0.0000 0.0000 0.0000 0.0000 IBM 0.0000 d Equally Weighted Portfolio StD 0.0000 10 Mean 0.0000 10 e Min. StD Portfolio StD 0.0000 7.5 Mean 0.0000 7.5 0.05 0.0000 0.07 0.0000 Portfolio 0.09 0.0000 Return at StD 0.12 0.0000 0.17 0.0000 Leave the picture on the worksheet 7.5 7.5 7.5 7.5 7.5 2.5 a DELL c Correlation between DELL and f g 5 5 15 Total Score 0.0 100 Sheet Name P1 P1 P1 P1 Sub Q. No. 2 2 3 3 P1 3 P1c 1 P1c 2 P1d 1 P1d 1 P1d P1d P1d P1d P1d 2 2 2 2 2 Stock Return Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 DELL -0.0517 -0.2000 0.0682 0.0106 0.0105 -0.0208 0.0638 0.0400 0.1539 -0.0250 -0.0171 -0.0261 0.0000 0.0179 0.0000 0.0702 -0.0082 0.0909 -0.0076 -0.0305 0.0551 0.0299 -0.0145 0.0809 -0.0476 0.0000 -0.0143 -0.1449 0.0678 0.0952 0.0725 -0.0270 0.0278 -0.0541 -0.0429 -0.0448 -0.0313 -0.0262 -0.0062 WMT 0.0208 0.0000 0.0408 0.1765 0.0000 0.0000 0.0333 0.0968 0.0588 0.0000 0.0000 0.0000 0.0556 0.1053 -0.0476 0.2250 0.0000 0.0000 0.0000 0.0306 0.0297 0.0385 -0.0463 0.0000 0.0388 -0.0094 0.0000 -0.0566 0.0600 0.0566 -0.0536 0.0094 -0.0280 0.0000 -0.0385 0.0500 0.0000 0.0000 -0.0286 MS -0.1607 0.0426 -0.0204 -0.0208 -0.1064 0.0238 0.0349 0.0112 0.0889 -0.0408 -0.0319 0.0989 -0.0200 -0.0816 0.0222 0.1087 0.2353 0.0794 -0.0441 0.1846 -0.1429 0.2121 -0.0250 -0.0641 0.2534 0.1803 0.0000 -0.1250 0.1905 -0.0667 0.0000 0.0571 -0.0946 0.0597 -0.0704 0.1136 -0.0204 0.0556 0.1184 IBM -0.1177 -0.2000 0.1667 0.1429 0.0000 -0.1563 0.0000 -0.1111 0.0000 -0.0417 0.1304 0.1154 0.1379 0.1212 0.0270 -0.0790 0.0857 0.1316 -0.0233 0.1429 -0.0417 0.0000 0.0217 -0.0638 0.0909 -0.0417 0.1739 0.0370 -0.0714 0.0577 0.0546 0.1724 0.1029 0.0667 0.0000 0.0750 -0.0233 0.0000 0.0595 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 0.0000 0.0500 0.0476 0.0000 -0.0303 0.0313 -0.0303 0.0938 0.0714 -0.0267 0.0137 0.0253 -0.0708 -0.0213 -0.0725 0.0234 0.0382 0.0294 -0.0286 0.0294 -0.0714 0.0615 0.0000 0.0000 0.0000 0.0000 -0.0435 0.0455 0.0145 0.0143 0.0000 -0.0141 0.0286 0.0000 -0.0069 -0.0210 0.0071 -0.0142 -0.0072 0.0145 0.0000 0.0571 0.0000 0.0196 0.0385 -0.0370 0.0000 0.0000 0.1154 -0.1379 0.0700 0.0467 -0.0357 0.0278 0.0451 -0.0431 0.0000 0.0000 -0.0315 0.0047 0.0093 -0.0184 0.0000 -0.0280 0.0000 0.0192 0.1321 -0.0917 0.1560 0.0318 0.0923 0.0704 0.0921 0.0181 0.0355 0.1200 0.0204 0.0600 -0.0236 -0.0531 0.1225 0.0909 -0.0125 -0.1646 -0.0152 -0.0769 0.1059 0.0213 -0.1146 0.0235 0.0575 -0.0435 0.0227 0.0333 -0.0538 0.0284 0.0276 0.0430 0.0309 0.0300 0.6602 0.0000 -0.0175 0.0655 0.0754 0.0390 0.1000 -0.0364 0.0283 -0.1468 0.0161 0.0159 -0.1667 -0.3813 0.0909 0.3704 -0.1351 -0.0430 0.0082 0.0850 0.0522 -0.0284 0.0073 -0.2083 -0.2082 -0.0578 -0.1595 0.2263 0.0238 -0.0225 0.1264 0.4082 0.3044 -0.0056 -0.1285 0.0385 -0.0988 -0.1370 0.0794 -0.1765 -0.0804 0.1845 -0.1066 -0.0275 -0.1887 -0.0116 -0.0118 -0.1191 0.0270 -0.1842 -0.0968 -0.1964 0.0222 0.0435 0.0417 0.0800 0.0556 0.0175 0.3793 -0.1000 -0.1944 0.0690 -0.0323 0.2000 0.0417 0.0400 -0.0385 -0.2800 0.0093 -0.5413 0.6600 -0.3494 83 84 85 86 87 88 89 90 91 92 93 94 95 96 0.0203 0.0199 0.0000 -0.0909 0.0000 0.0143 -0.0211 -0.0072 0.0217 -0.0071 -0.0857 0.0859 -0.0036 -0.0181 0.0167 0.0000 0.0164 -0.0968 -0.0179 -0.0546 0.0144 0.0190 0.0419 -0.0714 0.1466 -0.1111 0.0566 -0.1295 -0.0204 0.0326 0.0000 -0.1149 0.2987 0.2250 0.2327 -0.1987 0.2149 0.0476 -0.0390 -0.1351 -0.0781 -0.1271 0.0370 -0.1250 0.1429 0.2500 -0.0857 0.6875 0.0741 0.0345 0.2167 0.0069 -0.0816 0.2296 0.2048 -0.0400 DELL WMT MS IBM DELL WMT MS IBM Average Stdev DELL WMT MS IBM 1. The Excel sheet named \"P1\" has the monthly stock return of four Using the given data, answer the following questions. a. Find the Expected Return and Standard Deviation of each company values of DELL to the sheet \"Answer\". b. Using the tools menu and the data analysis, find the correlation ma and place the correlations between the DELL and the other stocks on c. Using the Macro functions developed in class, find the expected re of a portfolio in which the weight each stock is 0.25. Copy and past t of your Answer. If your answer file has no macros, there is no credit f correct. d. Using \"Solver\
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started