# Expected value;standard deviation;coefficient of variation

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 ad1c9bdddfhttps://brainmass.com/business/annuity/expected-value-standard-deviation-coefficient-variation-352040

#### 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.