Assignment 1

A Sample Spreadsheet

The spreadsheet Twocoins.xls simulates the experiment of tossing two coins (or, equivalently, tossing a single coin twice).

This experiment has four equally likely outcomes:

OutcomeNumber of HeadsProbability
HH20.25
HT10.25
TH10.25
TT00.25

The spreadsheet is a simulation designed to estimate the probability of the following events using the empirical approach (p.226):

The Assigned Task

Using the Twocoins.xls spreadsheet as a model, create a new spreadsheet called "Threecoins" that simulates the experiment of tossing three fair coins.

Your spreadsheet should be designed to estimate the probability of the following events using the empirical approach (p.226):

Offer a brief explanation of the estimates of the probability of each of these events based on the assumption that the eight possible outcomes of this experiment are equally likely.