Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The attached text file has the 2017 monthly returns of Apple and Disney. Import it into Excel. Create an additional column that is 50% Apple's
The attached text file has the 2017 monthly returns of Apple and Disney. Import it into Excel. Create an additional column that is 50% Apple's return and 50% Disney's return (this would be the monthly return of a portfolio where your wealth is equally split between the two stocks.) Calculate the average monthly return of the portfolio and its standard deviation using the =average ( ) and =stdev.s( ) functions. While you are at it, compare these results to the average return and standard deviation of returns for the stocks individually. stock returns.txt portfoliostandarddeviation=3.4%permonthportfoliostandarddeviation=3.7%permonthportfoliostandarddeviation=4.2%permonthportfoliostandarddeviation=4.5%permonthportfoliostandarddeviation=4.9%permonth DateApple201701312017022820170331201704282017053120170630201707312017083120170929201710312017113020171229Disney4.77%13.36%4.87%0.01%6.78%5.72%3.27%10.69%6.02%9.68%2.04%1.52%6.17%0.51%3.00%1.95%6.63%1.57%4.20%7.94%2.60%0.77%7.17%3.37%
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