Purchase Solution

Standard deviation, Variance and Covariance

Not what you're looking for?

Ask Custom Question

Consider three sets of data:

1. data: 1 0 1 3
probability: 0.2 0.3 0.3 0.2

2. data: 0 2 4 1
probability: 0.2 0.3 0.3 0.2

3. data: 4 1 0 0
probability: 0.2 0.3 0.3 0.2

Calculate the standard deviation and variance of each set data, and covariance.

Purchase this Solution
Solution Summary

Standard deviation, variance and covariance are calculated in Excel. Calculations are not explained.

Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

View More Free Quizzes
Related BrainMass Solutions

  • Portfolio of Common Stock

    Variance of a stock = (Standard deviation of a stock)^2. ? Covariance of stock 1 and 2 = (Correlation of stock 1 and 2) * (Standard deviation of stock 1) * (Standard deviation of stock 2). ?

  • Standard deviations of stocks

    return is 0.235, or 23.5% The Variance of a two-stock portfolio (the standard deviation will simply be the square root of the variance) is: Variance = (wa^2)*Variance(A) + (wb^2)*Variance(B) + 2*wa*wb*Covariance(A, B) [the symbol ^ means "to the

  • Standard deviation of securities- Two factor model

    #963;F2^2+2b21*b22*COV(F1,F2)+σe2^2 = 0.105635 Standard deviation of Security B=√Variance= 32.50% Covariance of Security A and B= σ12=b11*b21*σF1^2+b12*b22*σF2^2+(b11*b22+b12*b21)*COV(

  • Calculating the Return, Variance and Standard Deviation

    Mean and geometric mean of the rate of return B. Variance and standard deviation of the rate of return C. Covariance and correlation coefficient of the rate of return. Please check the attached sheet for the solution.

  • Accounting: Calculating the expected return and standard deviation of a portfolio.

    (A, B) * standard deviation of A * standard deviation of B Variance = standard deviation^2 --> standard deviation = square root of variance Given: E(A) = 0.15 E(B) = 0.25 Standard deviation of A = 0.1 --> Variance of A = 0.01 Standard deviation

  • Determine the Correlation of Determination

    Determine (calculate) the Covariance (formula given above) between GM and S&P500. Note: the Covariance of an asset with itself is equal to its Variance. The standard deviation (sigma symbol = ) is equal to the square root of the variance. 1.

  • Average return, volatility, covariance, correlation

    = Covariance / (Standard deviation of X * Standard Deviation of Y)= 0.4789 =0.00794/ (0.105972 x 0.156461) Answer: (a) the average return and volatility for each stock, Stock A:

  • Covariance of stock returns, Diversification

    ;Y)^ 2 /N}/(N-1)= 81.8 =(424-22^2/5)/(5-1) standard deviation of Y =√Variance of Y= 9.0443 =√81.8 Correlation between X and Y = Covariance / (Standard deviation of X * Standard Deviation of Y)= -0.0660 =-5.8/ (9.7108

  • Riskiness of an Isolated Asset

    The common measure of the riskiness of an asset held in isolation is the standard deviation. Note: beta and covariance measure the correlation between an asset and the market, and are not used for an asset held in isolation.

View More Related Solutions