Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

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

Advanced Financial Accounting

Authors: Richard Lewis, David Pendrill

7th Edition

0273658492, 978-0273658498

More Books

Students also viewed these Finance questions