Monte-Carlo-Style Scenarios: Expected Value and the Chance of a Loss
This lesson is part of the course
In this lesson
You turn 20 given random numbers into 20 possible years for the desk lamp, then report the expected EBIT and the probability of a loss.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Input-Driven Models: Inputs vs Calculations Locked
- Scenario Selector: Base, Best and Worst with CHOOSE and INDEX Locked
- One-Variable Data Table, Built with Formulas Locked
- Two-Variable Data Table with Mixed References Locked
- Goal Seek by Hand: Bisection Table vs the Algebraic Solution Locked
- Break-Even and Target Profit: Solve Instead of Seek Locked
- Tornado Sensitivity: Which Driver Moves Profit Most? Locked
- Monte-Carlo-Style Scenarios: Expected Value and the Chance of a Loss Locked