Explore BrainMass
Share

Explore BrainMass

    Expected value;standard deviation;coefficient of variation

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Problems involve:
    expected value
    standard deviation
    coefficient of variation
    pv
    fv
    pva
    fva

    (see attached)

    I need these problems done using excel and showing how the answers were calculated. The answers are at the end of the attached problem set.

    I need the formulas to each problem in an EXCEL spreadsheet as well as explanations as to what the answers mean in the context of the problem.

    Describe and justify each assumption you have made

    Explain, support and justify every statement you make

    Support your conclusions with evidence such as facts and statistics from reliable sources, or a well-reasoned logical argument.

    © BrainMass Inc. brainmass.com October 10, 2019, 1:51 am ad1c9bdddf
    https://brainmass.com/business/annuity/expected-value-standard-deviation-coefficient-variation-352040

    Attachments

    Solution Preview

    See the attached file. Thanks
    7.14
    Sales Probability of Occurance
    Ri pi (Ri-R-)
    $800 2% ($1,200)
    $1,000 8% ($1,000)
    $1,400 20% ($600)
    $2,000 40% $0
    $2,600 20% $600
    $3,000 8% $1,000
    $3,200 2% $1,200
    Expected return = R- Spi*Ri
    2000
    Standard Deviation=s (Spi*(Ri-R-)^2)^0.5
    $601.33

    Coefficient of Variation=CV s/R-
    0.301

    8.3
    This is the future value of a one time ...

    Solution Summary

    This post shows how to calculate expected value, standard deviation, coefficient of variation, pv, fv, pva, fva.

    $2.19