Correlation is calculated using CORREL function in Excel
Correlation is -0.2329
Year Stock X Stock Y unanswered 5.00% 7.00% not submitted 10.00% 18.00% 6.00% 20.00% 0.00% 11.00%...
Year Stock X Stock Y unanswered 5.00% 7.00% not_submitted 10.00% 18.00% 20.00% 6.00% 4 0.00% 11.00% What is the standard deviation of Stock Y? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924)
Stock X Stock Y Year # 6 unanswered 5.00% 1 7.00% not_submitted 2 10.00% 18.00% 6.00% 3 20.00% 11.00% 4 0.00% What is the standard deviation of the returns of Stock X? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924)
Stock X Year Stock Y unanswered 8.00% -16.00% not_submitted 12.00% 2 -5.00% 14.00% 0.00% 4 4.00% 5.00% What is the covariance of the returns of Stock X with the returns of Stock Y? Submit Answer format: Number: Round to: 6 decimal places.
" Year Stock X Stock Y 1 9.00% -6.00% 2 -8.00% 11.00% 3 18.00% 2.00% 4 3.00% 5.00% What is the covariance of the returns of Stock X with the returns of Stock Y?" Round to 6 decimal places please.
Year Stock X Stock Y 8.00% -16.00% -5.00% 12.00% 14.00% 0.00% 4.00% 5.00% What is the standard deviation of Stock Y? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))
Year Stock X Stock Y 8.00% -16.00% -5.00% 12.00% 14.00% 0.00% 4 4.00% 5.00% What is the standard deviation of the returns of Stock X? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))
Suppose you deposit $1,058.00 into an account 5.00 years from today that earns 11.00%. It will be worth $1,853.00 years from today. unanswered not_submitted Submit Attempts Remaining: Infinity Answer format: Number: Round to: 2 decimal places. Assume the real rate of interest is 4.00% and the inflation rate is 6.00%. What is the value today of receiving 10,012.00 in 13.00 years? unanswered not_submitted Submit Attempts Remaining: Infinity Answer format: Currency: Round to: 2 decimal places.
A stock has an expected return of 18.00%. The risk-free rate is 2.44% and the market risk premium is 6.20%. What is the ß of the stock? unanswered Submit not submitted Answer format: Number: Round to: 2 decimal places.
An investor is looking at a stock that has four possible values in the next year. The probabilities and returns are shown below. OUTCOME: Probability Return Strong Economy 0.24 25.00% Good Economy 0.26 10.00% Poor Economy 0.32 0.00% Recession 0.18 -11.00% What is the standard deviation of these returns based on the probabilities? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924)) #10 A...
Last year, a fund manager invested in three companies: Allen Dynamics, Bosh Heating, and Creole Plumbing. Below, the results for his investment are shown: # of shares purchased Price per share in 2017 Price per share in 2018 Allen Dynamics 100.00 $10.00 $11.00 Bosh Heating 50.00 $16.00 $18.00 Creole Plumbing 200.00 $5.00 $5.75 What is the value of his portfolio at the end of 2018? Submit Answer format: Currency: Round to: 2 decimal places. #8 An investor is looking at...