Question: Please solve in excel (will give thumbs up) #1 Year Stock X 1 11.00% 2 -7.00% 3 18.00% 4 7.00% What is the standard deviation

Please solve in excel (will give thumbs up)

#1 Year Stock X 1 11.00% 2 -7.00% 3 18.00% 4 7.00% What is the standard deviation of Stock X's returns? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%. % sign required. rounded to 4 decimal places (ex: 0.0924)) #2 Year Stock X Stock Y 1 7.00% -3.00% 2 -8.00% 18.00% 3 3 13.00% 7.00% 4 4.00% 9.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. rounded to 4 decimal places (ex: 0.0924)) #3 Year Stock X Stock Y 1 7.00% -3.00% 2 -8.00% 18.00% 3 13.00% 7.00% 4 4.00% 9.00% What is the standard deviation of Stock Y

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please solve in Excel (will give thumbs up) #4 Year Stock X Stock Y 1 7.00% -3.00% 2 -8.00% 18.00% 3 13.00% 7.00% 4 4.00% 9.00% What is the covariance of the returns of Stock X with the returns of...

#1 Year Stock X 1 9.00% 2 -5.00% 3 16.00% 4 10.00% What is the standard deviation of Stock X's returns? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required....

Year Stock X Stock Y 1 15.00% 18.00% 2 3.00% 13.00% 3 18.00% 6.00% 4 10.00% 5.00% What is the standard deviation of the returns of Stock X? Submit Answer format: Percentage Round to: 2 decimal places...

Year Stock X 1 8.00% 2 -6.00% 3 13.00% 4 10.00% What is the standard deviation of Stock X's returns? Year Stock X Stock Y 1 13.00% -7.00% 2 -7.00% 17.00% 3 17.00% 6.00% 4 10.00% 9.00% What is the...

#1 Year Stock X Stock Y 1 11.00% 12.00% 2 9.00% 12.00% 3 17.00% 2.00% 4 0.00% 8.00% What is the standard deviation of the returns of Stock X? Submit Answer format: Percentage Round to: 2 decimal...

Year Stock X Stock Y 1 8.00% -8.00% 2 -5.00% 20.00% 3 11.00% 4.00% 4 7.00% 11.00% What is the standard deviation of Stock Y? Submit Answer format: Percentage Round to: 2 decimal places (Example:...

FINC 340 INVESTMENTS MIDTERM EXAMINATION_04 DIRECTIONS: Here are the questions for the Midterm Examination. Please submit your Midterm Examination Answer Sheet in MS Word format with the following...

The annual returns of three stocks for the past seven years are given in the following table: Year Stock X Stock Y Stock Z 2011 3.00% 14.00% 19.00% 2012 9.00% 7.00% 11.00% 2013 12.00% 19.00% 5.00%...

You have observed the following returns over time: Year Stock X Stock Y Market 2011 15 % 13 % 11 % 2012 17 5 11 2013 -14 -7 -11 2014 3 1 2 2015 22 12 12 Assume that the risk-free rate is 3% and the...

The annual returns of three stocks for the past seven years are given in the following table: Year Stock X Stock Y Stock Z 2011 3.00% 14.00% 19.00% 2012 9.00% 7.00% 11.00% 2013 12.00% 19.00% 5.00%...

Monique is a self-employed manufacturers representative (i.e., an independent contractor) who solicits business for numerous clients and receives a commission based on sales. She incurs the following...

Gold Nest Company of Guandong, China, is a family-owned enterprise that makes birdcages for the South China market. The company sells its birdcages through an extensive network of street vendors who...

Tax researchers should not consider the client s potential liability in determining how much time to spend on a client s problem.

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

1 Learning from some of the measures taken by Eskom, AECI and Germiston City Council, what could a foreign company like Colgate Palmolive do to contribute to the development of human potential within...

Achievementascription. Quite often more traditional societies accord status according to ascription. Again, this may influence recruitment and promotion policies that may be at variance with...

Indian managers at both middle and senior levels in organizations profess a belief in group-based, participative decision making, but have little faith in the capacity of workers for taking...