Lesson 15: Simulation of Continuous Random Variables
March 10, 2022
Review:
- Project 2
- Simulation automation
- Chuck-a-luck
Presentation:
- Random Variables
- Discrete Random Variables
- Probability distribution table
- Dice Simulation
- =RANDBETWEEN()
- Continuous Random Variables
- Stock Market simulation
- Assume normal distribution
- =norminv(rand(),$B$2,$B$3)
- Discrete Random Variables
Assignment:
- Stock Market Simulation in Sheets
- Use Annual Stock Market Return data as a starting point
- Modifications
- Generate a 40-year simulation (you’ll need to modify the automation script)
- Modify the simulation to add $1,000 to the balance at the end of each year
- Make a histogram of your ending balances
- Press run to make your histogram “dance” as it generates new ending balances