You have an investment with the following history of returns:3.30-10%a2015025%a6C4080-22%a19%a43%aa26%a10%a13%aYou believe that the history ofreturns for this investment is a good indication ofwhat toexpect going forward. What is the expected return, standard deviation of returns, and95% confidence interval for this investment?T

Question
1 views

I need help with this problem and want to set up for excel with formulas.

check_circle

Step 1

Value of Z at the 95% Confidence Level = 1.96

Calculation of expected return, standard deviation and lower and upper limit of 95% confidence interval of the investment is as follows:

Expected return is calculated by using AVERAGE function of excel:

To open the "AVERAGE function" window - MS-Excel --> Formulas --> More Function --> Statistical --> AVERAGE.

Standard Deviation is calculated by using STDEV.S function of excel:

To open the "STDEV.S function" window - MS-Excel --> Formulas --> More Function --> Statistical --> STDEV.S.

Step 2

The result of the above ta...

Want to see the full answer?

See Solution

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in