SOLUTION: An investment will be worth $1000, $2000, or $5000 at the end of the year. The probabiltiies of the values are 0.25, 0.60, and 0.15 respectively. Determine the mean and variance of

Question 1197944: An investment will be worth $1000, $2000, or $5000 at the end of the year. The probabiltiies of the values are 0.25, 0.60, and 0.15 respectively. Determine the mean and variance of the worth of the investment. (You may use Excel to solve this problem).
Answer by Theo(13342) (Show Source): You can put this solution on YOUR website!
you could to this manually as shown below.
.25 * 1000 = 250
.60 * 2000 = 1200
.15 * 5000 = 750

sum of multiplied amounts = 2200
sum of multipliers = 1.0
mean is equal to 2200 / 1 = 2200.

sum of squares is equal to:
(1000 - 2200)^2 * .25 = 360,000
(2000 - 2200)^2 * .60 = 24,000
(5000 - 2200)^2 * .15 = 1,176,000
sum = 1,560,000
variance = sum / sum of (.25, .60, .15) = 1) = 1,560,000
standard deviation = sqrt(variance) = 1248.9996.

your solution is that the mean is 2200 and the variance is 1,560,000.

this could be done in excel.
i'm not sure if it can be done directly.
i have the 2007 version which may not allow that that to be done automatically.
i can, however, use excel to create it manually.
this takes the drudgery out of the calculations.

here's what the excel output looks like.

RELATED QUESTIONS
What is the present value of an investment that will be worth $25,000 at the end of five... (answered by Theo)

An investment was worth $2500 in 1995. By 2000 it had grown to $3500. Let y be the value... (answered by stanbon)

amy makes an initial investment of 5000 the investment loses 13.5% each year find the... (answered by ikleyn,greenestamps)

You can purchase an investment that pays $75,000 at the beginning of each year for twenty (answered by ikleyn)

Suppose $2000 is invested at 5.75% annual interest compounded continuously for 20 months. (answered by rfer)

Susan�purchased�a�painting�in�the�year�2000�for�$5000.�Assuming�an�exponential�rate�of... (answered by KMST)

present value of an uneven stream of payments) you are given 3 investments alternatives... (answered by Theo)

If interest is compounded continuously at 4.5% for 7 years, how much will a $2000... (answered by Theo)

I need help with this question. An intial investment of $5000 earns 8% interst,... (answered by solver91311)