Working With Basic Random Variables in Excel

Posted on
6,361 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

OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

In this article, we have come up with a step by step procedure to migrate Office 365 data to Zoho Mail using SysTools Office 365 Backup and Zoho Mail Migration Wizard.
In this write-up, we have come up with a two-step solution to migrate Office 365 back to Exchange 2019 / 2016 / 2013 / 2010. First move Office 365 to PST, next add PST to Exchange Server.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month