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
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
How can the return and standard deviation of a portfolio be deteremined
They are measures of the spread of data.
They are measures of the spread of distributions about their mean.
It is one of several measures of the spread of data. It is easier to calculate than the standard deviation, which has important statistical properties.
For a two-asset portfolio, the risk of the portfolio, σp, is: 2222p1122112212222p11221212121212σ=wσ+wσ+2wσwσρorσ=wσ+wσ+2wwcovcov since ρ=σσ where σi is the standard deviation of asset i's returns, ρ12 is the correlation between the returns of asset 1 and 2, and cov12 is the covariance between the returns of asset 1 and 2. Problem What is the portfolio standard deviation for a two-asset portfolio comprised of the following two assets if the correlation of their returns is 0.5? Asset A Asset B Expected return 10% 20% Standard deviation of expected returns 5% 20% Amount invested $40,000 $60,000
difference standard deviation of portfolio
How can the return and standard deviation of a portfolio be deteremined
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.
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.
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.
They are measures of the spread of data.
Standard deviations are measures of data distributions. Therefore, a single number cannot have meaningful standard deviation.
They are measures of the spread of distributions about their mean.
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.
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.
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.
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