| Subject | Excel Exercise File | Video | Chapter Reference | Page Reference | ||||
| Working with Normal Distribution | Exercise 1: Normal Distribution Functions | https://www.youtube.com/watch?v=7s2GiemfZdg | Chapter 21 | 278 | ||||
| Working with Wiebull Distribution | Exercise 2: Wiebull Distribution Functions | |||||||
| Creating Basic Time Series Distribution with Normal Distribution | ||||||||
| Creating Time Series with Weibull Distribution | ||||||||
| Graphing Distribution | ||||||||
| Adding Time Series to Financial Model | ||||||||
| Mean Reversion in Time Series Models | ||||||||
| Boundaries in Time Series Models | ||||||||
| Correlation in Time Series Models | ||||||||
| Black Scholes Model | ||||||||
| Monte Carlo Simulation and Black Scholes Model | ||||||||
| Testing Time Series for Normal | Commodity Price Analysis | |||||||
| Simple Time Series Analysis in Excel without Mean Reversion | https://www.youtube.com/watch?v=WliOwYepmHo | |||||||
| Monte Carlo with Mean Reversion | https://www.youtube.com/watch?v=2mLJEo2ubsw | |||||||
| Monte Carlo Distribution Graphs | https://www.youtube.com/watch?v=_oVz9TT6a5g | |||||||
| ………………………………………………………………………………………………………….. | …. | …………………………………………………………………………………………. | …. | ……………………………………………………………………………………………… | …. | …………………………………….. | …. | ……………………………………… |