<

Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

Building Probability Models in Excel Part 4: Discrete Random Variables

Posted on
6,396 Points
396 Views
Last Modified:
Experience Level: Beginner
5:06
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilities and outcomes with the =STDEVPR command.

Video Steps

1. Discrete Random Variables: Type in the set of outcomes and corresponding probabilities in cells A2:B6

2. Enter =SUM(B2:B6) into cell B7

3. Enter =DISCRINV(RAND(),A2:A6,B2:B6) into cell B9 and label “Profit”

4. Enter =B9 into cell B14

5. Select cells A14:B213

6. Click Tools > SimTools > Simulation Table

7. Enter =AVERAGE(B14:B213) into cell B11 and label “Mean”

8. Enter =STDEV(B14:B213) into cell B12 and label “StDev”

9. Enter =STDEVPR(A2:A6,B2:B6) into cell C12

0
Comment
Author:Toby Reaper
0 Comments

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Join & Write a Comment

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Gain an elementary understanding of Blockchain technology.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month