<

[Webinar] Streamline your web hosting managementRegister Today

x

Working With Basic Random Variables in Excel

Posted on
6,336 Points
236 Views
1 Endorsement
Last Modified:
Experience Level: Beginner
5:31
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

1
Comment
Author:Toby Reaper
0 Comments

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month