Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel answer would be appreciated! 3 Here are the percentage returns on two stocks. 2.22 points Digital Cheese 15% -4 Month January February March April
Excel answer would be appreciated!
3 Here are the percentage returns on two stocks. 2.22 points Digital Cheese 15% -4 Month January February March April May June July August o w wivu do Executive Fruit 7% 2 5 13 1 5 un UIN -1 a-1. Calculate the monthly variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 1 decimal places.) Answer is complete but not entirely correct. Digital Cheese 20.8 X 4.6 x Variance Executive Fruit 15.3 X Standard deviation % 3.9 a-2. Which stock is the riskier if held on its own? Digital Cheese Executive Fruit b. Now calculate the variance and standard deviation of the returns on a portfolio that invests an equal amount each month in the two stocks. (Do not round intermediate calculations. Round your answers to 1 decimal places.) Variance Standard deviation % c. Is the variance more or less than half way between the variance of the two individual stocks? more than the 50%-50% less than the 50%-50%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