<

Working With Basic Random Variables in Excel

Posted on
6,394 Points
294 Views
1 Endorsement
Last Modified:
Published
Experience Level: Beginner
5:29
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
Author:Toby Reaper
0 Comments
This article covers how to resolve Outlook password issues and serves as a guide when you keep entering credentials Outlook fails to remember. A "Needs Password" message is typically seen at the bottom of Outlook, or a Windows Security prompt keeps …
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Hashing.