answersLogoWhite

0

Risk reflects the chance that the actual return on an investment may be very different than the expected return. One way to measure risk is to calculate the variance and standard deviation of the distribution of returns.

Consider the probability distribution for the returns on stocks A and B provided below.StateProbabilityReturn on

Stock AReturn on

Stock B

120%5%50%

230%10%30%

330%15%10%

320%20%-10%

The expected returns on stocks A and B were calculated on the Expected Return page. The expected return on Stock A was found to be 12.5% and the expected return on Stock B was found to be 20%.

Given an asset's expected return, its variance can be calculated using the following equation:

where

  • N = the number of states,
  • pi = the probability of state i,
  • Ri = the return on the stock in state i, and
  • E[R] = the expected return on the stock.

The standard deviation is calculated as the positive square root of the variance.

Note: E[RA] = 12.5% and E[RB] = 20%

Stock A

Stock B

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Difference Standard Deviation of a portfolio?

difference standard deviation of portfolio


How can he return and standard deviation of a portfolio be determined?

How can the return and standard deviation of a portfolio be deteremined


How can I calculate the standard deviation of a portfolio in Excel?

To calculate the standard deviation of a portfolio in Excel, you can use the STDEV.P function. This function calculates the standard deviation based on the entire population of data points in your portfolio. Simply input the range of values representing the returns of your portfolio into the function to get the standard deviation.


How can one calculate the standard deviation of a portfolio?

To calculate the standard deviation of a portfolio, you need to first determine the individual standard deviations of each asset in the portfolio, as well as the correlation between the assets. Then, you can use a formula that takes into account the weights of each asset in the portfolio to calculate the overall standard deviation. This helps measure the overall risk of the portfolio.


How can one determine the standard deviation of a portfolio?

To determine the standard deviation of a portfolio, you would need to calculate the weighted average of the individual asset standard deviations and their correlations. This involves multiplying the squared weight of each asset by its standard deviation, adding these values together, and then taking the square root of the result. This calculation helps measure the overall risk and volatility of the portfolio.


What type of measures are the range and the standard deviation?

They are measures of the spread of data.


How do you find highest standard deviation in given number?

Standard deviations are measures of data distributions. Therefore, a single number cannot have meaningful standard deviation.


What do the variance and the standard deviation measure?

They are measures of the spread of distributions about their mean.


How can I calculate portfolio standard deviation in Excel?

To calculate portfolio standard deviation in Excel, you can use the formula SQRT(SUMPRODUCT(COVARIANCEMATRIX, TRANSPOSE(WEIGHTS), WEIGHTS)), where COVARIANCEMATRIX is the range of covariance values, and WEIGHTS is the range of weights assigned to each asset in the portfolio. This formula takes into account the covariance between assets and their respective weights to determine the overall risk of the portfolio.


How can I calculate the portfolio standard deviation in Excel?

To calculate the portfolio standard deviation in Excel, you can use the formula SQRT(SUMPRODUCT(COVARIANCE MATRIX, WEIGHTS MATRIX, TRANSPOSE(WEIGHTS MATRIX))). This formula multiplies the covariance matrix of the assets, the weights of each asset in the portfolio, and the transpose of the weights matrix, then takes the square root of the sum of these products.


What does standard deviation show us about a set of scores?

Standard Deviation tells you how spread out the set of scores are with respects to the mean. It measures the variability of the data. A small standard deviation implies that the data is close to the mean/average (+ or - a small range); the larger the standard deviation the more dispersed the data is from the mean.


Annualized standard deviation?

http://www.hedgefund.net/pertraconline/statbody.cfmStandard Deviation -Standard Deviation measures the dispersal or uncertainty in a random variable (in this case, investment returns). It measures the degree of variation of returns around the mean (average) return. The higher the volatility of the investment returns, the higher the standard deviation will be. For this reason, standard deviation is often used as a measure of investment risk. Where R I = Return for period I Where M R = Mean of return set R Where N = Number of Periods N M R = ( S R I ) ¸ N I=1 N Standard Deviation = ( S ( R I - M R ) 2 ¸ (N - 1) ) ½ I = 1Annualized Standard DeviationAnnualized Standard Deviation = Monthly Standard Deviation ´ ( 12 ) ½ Annualized Standard Deviation *= Quarterly Standard Deviation ´ ( 4 ) ½ * Quarterly Data