
To make a spreadsheet similar to the one in Example 3, use the steps below.
 Enter the titles "Number," "Payoff," "Probability," and "Expected Value" into row 1.
 Enter 1 into cell A2.
 Enter the formula = A2 + 1 into cell A3.
 Select cell A3. From the Edit menu, choose Copy.
 Select cells A4 through A7. From the Edit menu, choose Paste.
 Enter the title "Total" into cell A8.
 Enter the formula = 3*A2 into cell B2.
 Select cell B2. From the Edit menu, choose Copy.
 Select cells B3 through B7. From the Edit menu, choose Paste.
 Enter 0.1667 into cell C2.
 Select cell C2. From the Edit menu, choose Copy.
 Select cells C3 through C7. From the Edit menu, choose Paste.
 Enter the formula = B2*C2 into cell D2.
 Select cell D2. From the Edit menu, choose Copy.
 Select cells D3 through D7. From the Edit menu, choose Paste.
 Enter the formula =SUM(D2:D7) into cell D8.
To format the cells, use the steps below.
 Select cells B2 through B7.
 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 2. For Symbol, choose $ from the drop down list. Then click OK.
 Repeat Steps 15 for cells D2 through D8.
 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 2. Then click OK.

A coin toss is used at the beginning of a football game. You may have used a coin toss or two to settle an argument. For a few tips to help you win a coin toss, visit Wired.

A spreadsheet showing the number of dots, payoff, probability, and expected value for each possible roll of the die is shown below.
The probability of rolling each number of dots is The expected value for each number of dots is the payoff multiplied by the probability of that roll happening. The expected value of the offer is the sum of the individual expected values. I would take the uncle's offer. It has the highest expected value, $13, compared to $10 and $10.50, and the highest potential payout, $24, compared to $20 and $18.

Comments (1)
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 1 commentsGuest 9 years ago I like the type of question in Example 3. What would you do?0 1