Business Homework Solutions
#246942
variance and standard deviation
Please see the attached file.
This solution shows how to calculate standard deviation and variance on excel.
What is this?
By OTA - Overall OTA Rating
Kulaea Dudley, MBA - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
- Attached file(s):
- Standard_deviation_variance.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Accounting: Calculating the expected return and standard deviation of a portfolio. - Suppose the expected returns and standard deviations of stocks A and B are E(Ra) =0.15, E(Rb) = 0.25, Stdev A = 0.1, and Stdev B = 0.2, respectively. Calculate the expected return and standard devia ...
- Calculate variance & standard deviation for a portfolio - A portfolio is made up of 75% of stock 1 and 25% of stock 2. Stock 1 has a variance of .08 and Stock 2 has a variance of .035. The covariance between the stocks is -.001. Calculate the variance & s ...
- Variance of a portfolio - Stock A has a standard deviation of return of 50%. Stock B has a standard deviation of return of 40%. The two stocks have a correlation of 60%. What is the standard deviation of return of a portfo ...
- Guidance on calculating variance and std deviation of a portfolio - A portfolio is made up of 75% of stock 1, and 25% of stock 2. Stock 1 has a variance of .08, and stock 2 has a variance of .035. The covariance between the stocks is -.001. Calculate both the varia ...
- Calculate the mean return, the standard deviation and the geometric mean - Year Return 1 10% 2 -9% 3 12% Using the returns above calculate the mean return, the standard deviation and the geometric mean
