Working With Basic Random Variables in Excel

Posted on
6,356 Points
1 Endorsement
Last Modified:
Experience Level: Beginner
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.

Video Steps

1. Flipping Coins in Excel: Enter =RAND() into cell A2

2. Recalculate the random variable with the key combination fn+F9 (Also whenever a cell’s content is edited it recalculates)

3. Enter =IF(A2<0.5,”Heads”,”Tails”) into cell B2

4. Copy down to simulate 20 independent coin tosses

5. Enter =IF(B2=”Heads”, 1, 0) into cell C2 and copy down to C21

6. Count total and number of tosses and total number of heads (Calculate probability of heads versus the average of column C)

7. Changing the Probability: Enter 0.75 into cell E4

8. Change cell B2 to: =IF(A2<$E$4,"Heads","Tails") and copy down

Author:Toby Reaper

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Join & Write a Comment

Microsoft Office 365 is one of the most widely used business productivity suites. Over 23 million users around the world are now utilizing Office 365 and this number increasing every year. Here we have discussed topic how to backup Office 365 Mailbo…
Do you know how to convert CSV to multiple VCF formats? Are you searching for a hassle-free solution to import .csv file contacts into .vcf files? Get an optimum solution here to export Excel or CSV files to vCard or VCF formats! Read more to know t…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month