n-Step Probabilities: Matrix Powers P², P⁴, P⁸ with MMULT
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- States & the Transition Matrix: Weather Records to Probabilities that Sum to 1Free
- n-Step Probabilities: Matrix Powers P², P⁴, P⁸ with MMULT Pro
- Steady State: Iterate to Convergence, then Solve Exactly with MINVERSE Pro
- Absorbing Chains: the Fundamental Matrix, Expected Steps & Absorption Probabilities Pro
- Gambler's Ruin: Probability of Reaching a Target before Going Broke Pro
- Snakes & Ladders: a Transition Matrix from Dice Rolls and the Expected Game Length Pro
- Brand Switching: Monthly Market Shares and the Long-Run Share (with a Chart) Pro
- Simulation vs Exact: 80 Simulated Days against the Steady State (with a Chart) Pro