Video tutorials.
Discover new techniques with our video tutorials.
Whether you are a beginner or advanced user, our tutorials guide you step by step through the techniques and concepts of risk analysis, the Monte Carlo simulation method, and our products. Each tutorial is designed to foster hands-on learning, so you can apply what you have learned right away.
Confidence in decisions
What is Risk Kit in a nutshell?
What you can do with Risk Kit and how.
The first steps
Running a Monte Carlo simulation
A basic introduction to how Risk Kit transforms calculations in Excel into a comprehensive risk analysis that uses advanced techniques such as the Monte Carlo simulation.
The control center
The toolbar
A quick overview of all the functions of the Risk Kit toolbar and what you can do with them.
Presenting simulation results
Creating charts
When developing and evaluating risk models, it is often helpful to display results and input variables graphically.
Risk Kit lets you create charts quickly and easily with a single click, or use the plot function to design charts precisely, style their colors and appearance, and use them for reports.
Watching the development
Charts in cells
To see how the distributions of risk factors and results evolve, histograms and distribution functions can be displayed in cells. The charts are saved with the model. The feature can be switched on and off with a mouse click. The display is available effortlessly.
Prioritizing uncertainties
Sensitivities
In risk models, the question often arises which influencing factors have the strongest effect on the results. Risk Kit provides several methods to analyze and graphically display how sensitive the results are to uncertainties in the input variables and risk factors.
Presenting dependencies
Using correlations
Dependencies between risk factors in the form of correlations are a common use case. Using a business example, the video shows how correlations can be applied to arbitrary risk factor distributions in Risk Kit in Excel with the normal distribution copula.
Which distribution should I use?
Estimating distributions and correlations
Risk Kit lets you calibrate the parts of models for which data is available. For each risk factor, distributions are displayed in order of goodness of fit, compared with the data, their parameters are stated, and the correlations with the other factors are calculated. These values can be used directly as a model for the matter at hand, or used to benchmark expert judgments.
Risk Kit Data
Loading, consolidating, and synchronizing data
Managing investment, interest rate, exchange rate, share price, commodity price, and many other types of risk requires a data foundation to build on. The video shows how Risk Kit Data makes high-quality international data sources such as Federal Reserve Economic Data, the European Central Bank, the World Bank, Eurostat, and Apilayer Marketstack available with a mouse click.
Price risks
Simulating price developments
The video shows how models can be selected and calibrated to simulate price developments with their specific characteristics.
Distributions explained one by one
Each important distribution has its own video and an article that presents the content for reading. For an overview of all distributions, see our guide “When Do I Use Which Distribution?”.
Bernoulli distribution
When do I use a Bernoulli distribution in a Monte Carlo simulation?
Definition, formula and examples: when the Bernoulli distribution fits and what role it plays as a switch in a simulation.
Read the articleBinomial distribution
When do I use a binomial distribution in a Monte Carlo simulation?
Definition, formula and examples: how the binomial distribution describes the number of successes in n independent trials and how to calculate it in Excel.
Read the articlePoisson distribution
When do I use a Poisson distribution in a Monte Carlo simulation?
Definition, formula and examples: how the Poisson distribution describes the frequency of independent events and when it fits.
Read the articleNormal distribution
When do I use a normal distribution in a Monte Carlo simulation?
Definition, formula and examples: when the normal distribution fits, where its limits lie and how to truncate it.
Read the articleTriangular distribution, part 1
When do I use a triangular distribution in a Monte Carlo simulation?
Definition, formula and example: when the triangular distribution fits, why the most likely value is not the expected value and where its limits lie.
Read the articleTriangular distribution, part 2
When do I use a triangular distribution in a Monte Carlo simulation?
Part 2 uses an example to show how to model several uncertain quantities with triangular distributions and which of them has the strongest effect on the profit.
Read the articleExpert distribution
Quantifying expert estimates in a Monte Carlo simulation: the Expert distribution
Quantifying expert estimates better: how the Expert distribution captures estimates through bounds and quantiles, even without a fixed minimum or maximum.
Read the articlePERT distribution
When do I use a PERT distribution in a Monte Carlo simulation?
Definition, formula and example: how the PERT distribution describes a bounded duration with minimum, most likely value and maximum, and where its limits lie.
Read the articleLognormal distribution
When do I use a lognormal distribution in a Monte Carlo simulation?
Definition, properties and limits: when the lognormal distribution correctly describes proportional growth processes and how to parametrise it in Excel.
Read the articleFlex distribution
Custom distributions in a Monte Carlo simulation: the Flex distribution
Custom distributions: how the Flex distribution is built from values and probabilities and when it fits, from expert estimates to transferring simulation results.
Read the articleWehrspohn on YouTube
All tutorials appear on our YouTube channel, from the first steps to advanced modeling topics. New videos are added continuously.
Open YouTube channel