<

Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Working With Basic Random Variables in Excel

Posted on
6,317 Points
217 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Join & Write a Comment

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month