
To make a spreadsheet similar to the one in Example 6(a), use the steps below.
 Enter the titles "Result," "Payoff," "Probability," and "Expected Value" into row 1.
 In column A under the title "Result," enter the titles "Complete loss," "No gain," "100% gain," "400% gain," "900% gain," and "Total."
 In column B under the title "Payoff," enter the values 1000, 0, 1000, 4000, and 9000.
 In column C under the title "Probability," enter the values 0.40, 0.15, 0.15, 0.15, and 0.15.
 Enter the formula = B2*C2 into cell D2.
 Select cell D2. From the Edit menu, choose Copy.
 Select cells D3 through D6. From the Edit menu, choose Paste.
 Enter the formula =SUM(C2:C6) into cell C7.
 Enter the formula =SUM(D2:D6) into cell D7.
To format the cells, use the steps below.
 Select cells B2 through B6.
 From the Format menu, choose Cells....
 In the Format Cells dialog, select the Number tab.
 From the Category: list, select Currency.
 For Decimal places:, enter 0. For Symbol, choose $ from the drop down list. Then click OK.
 Repeat steps 15 for cells D2 through D7.
 Select cells C2 through C7.
 From the Format menu, choose Cells....
 In the Format Cells dialog, select the Number tab.
 From the Category: list, select Percentage.
 For Decimal places:, enter 0. Then click OK.

The Standard and Poor's 500 Index includes 500 leading companies in the U.S. economy. To access the index and much more, visit Standard and Poor's.

Sample answer:
Assume that you invest $1000. A spreadsheet showing the expected value of each investment is shown below.
If you have to pick only one investment, I think that the conservative investment is the best choice because it has only a slight chance of loss and is still expected to have a decent return. The expected value of the payoff is $105. This is a return of
On the other hand, if you could make a great number of speculative investments, the average payoff would approach the expected value, $1350. This is a very high return of

Comments (0)
These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
When posting a comment, you agree to our Terms of Use.Showing 0 commentsThere are no comments.