Thursday, October 12, 2006

Excel Commands

Here are some commands that can be used in Excel for estimating if either a coin is heads or tails.

Copy into cells A1-A100:

=IF(RAND()<0.5,"heads","tails")

Copy into cell B1:

=COUNTIF(A1:A100,"heads")

Copy into cell B2:

=COUNTIF(A1:A100,"tails")

0 comments: