Example models
See also: Useful Excel functions, ModelRisk functions and windows
Apart from the models listed below, a number of example models explaining specific ModelRisk functions are provided. These are listed on the right and linked to from that function's topic (e.g. VoseEigenValues).
On your hard drive, the example model files are located in the Models subfolder of your ModelRisk folder (usually this is c:\Program Files\Vose Software\ModelRisk\Models).
Example models explaining risk analysis techniques
The table below lists the example models included. All models are unprotected to allow you to use the code for your own problems.
When making use of these example models, we would consider it a kindness if you were to reference Help file for ModelRisk in papers and reports.
See the References topic for guidelines on referencing.
|
Topic link |
ModelRisk Edition required |
Techniques used (ModelRisk edition needed) |
A portfolio optimization problem
|
Industrial |
Optimization, Copulas. |
|
A reservation management optimization problem |
Link |
Professional or Industrial |
Optimization example. |
Professional or Industrial |
|
||
|
Industrial |
Directly calculating the moments of an aggregate distribution |
|
Any |
|
||
Link |
Any |
|
|
Link |
Professional or Industrial |
|
|
|
Any |
Loan default. |
|
Industrial |
|
||
|
Any |
|
|
Building a house |
Link |
Any |
|
Capital required |
|
Any |
Sum of random number of random variables Output statistics generation in spreadsheet. Calculation of risk budget. |
Cards
|
Any |
||
Cascading risks |
|
Professional or Industrial |
Modeling correlated (cascading) risk. |
Check aggregate accuracy |
Link |
Industrial |
|
CLT risk portfolio approximation |
Link |
Professional or Industrial |
|
Clumps of cysts |
Link |
Any |
|
Coins
|
Any |
Exercise in building a dynamic array. |
|
Combining expert opinions |
|
Professional or Industrial |
Combining opinions of different experts. |
Computers in the basement
|
Any |
Exercise in building a dynamic array. |
|
Contagious extreme value distribution
|
Professional or Industrial |
Contagious extreme value model and comparison with simulation. |
|
COPPER
|
Any |
Number of errors to achieve a success. Sum of resources expended to achieve success. |
|
Correlated insurance portfolio
|
Industrial |
Loss distribution for a number of policies with correlated aggregate loss distributions. |
|
Correlated risk portfolio
|
Professional or Industrial |
Modeling correlated risks. |
|
Correlating interest and mortgage rates
|
Any |
Modeling two correlated variables using the envelope method. |
|
Correlation using look-up tables
|
Any |
||
Correlation with fitted copula
|
Professional or Industrial |
||
Cost and schedule |
Link |
Any |
|
Cost model
|
Any |
A very simple project cost model. |
|
Covariance and correlation
|
Any |
Calculates the approximate sum of correlated random variables using a covariance matrix. |
|
Credit risk separated
|
Professional or Industrial |
Modeling credit risk with separate exposure and loss fraction components. |
|
Credit risk single portfolio
|
Industrial |
Modeling credit risk for a single portfolio. |
|
Credit risk without MR |
Link |
Any |
|
Cysts in water |
Link |
Any |
|
Database example model |
Link |
Industrial |
|
Distance To Nearest Fire
|
Any |
Two ways of determining the distance between an individual and its nearest, or next nearest, etc. neighbour. |
|
Distribution Object Properties |
Industrial |
|
|
Distribution Of Particles |
Link |
Any |
|
Election
|
Professional or Industrial |
Constructing a Dirichlet distribution. |
|
Error message comparison |
Link |
Professional or Industrial |
|
Estimate mean and stdev for Normal distribution when neither known
|
Link 1 |
Any |
A classical statistics method of estimating the mean and the standard deviation for Normal distribution when neither are known. |
Estimate mean for Normal distribution when stdev is known
|
Link |
Any |
A classical statistics method of estimating the mean for Normal distribution when the distributions standard deviation is known. |
Estimate stdev for Normal distribution when mean is known
|
Link |
Any |
A classical statistics method of estimating the standard deviation of a Normal distribution when the distributions mean is known. |
Exchange rate |
Link |
Any |
|
Extremes |
Industrial |
|
|
Finally retired
|
Any |
Calculate the total worth of a retirement fund upon retirement. |
|
Finite market |
Any |
Forecasting sales over time to a finite market. |
|
Link |
Industrial |
Various examples of fit reports. |
|
Fixed and Risked Model |
Link |
Professional or Industrial |
|
Floods |
Link |
Any |
|
Frechet
|
Any |
Generating a Frechet distribution. |
|
Gender
|
Any |
||
Healtheffect
|
Professional or Industrial |
Number of samples required in a random sampling of a population to obtain a particular minimum set. |
|
Hospital
|
Link |
Any |
Simple project duration model. |
Hospital bed days
|
Industrial |
Adding correlation in aggregate calculations Correlating partial sums. |
|
Hospital bed days_2
|
Professional or Industrial |
||
Hospital_bed_days_3
|
Professional or Industrial |
Adding correlation in aggregate calculations Correlating partial sums using scaling variables. |
|
Hospital_bed_days_4
|
Industrial |
||
Indepprob
|
Professional or Industrial |
Illustrating an incorrect way to use the Beta distribution to model variability in a Binomial probability. |
|
Inputs Outputs |
Any |
|
|
Integrated Risk Management
|
Professional or Industrial |
Sum of random number of random variables Insurance. Hedging. |
|
|
Any |
||
|
Professional or Industrial |
||
|
Professional or Industrial |
Comparing uncertain quantities. |
|
|
Any |
Model a time series based on a relationship with a leading indicator variable. |
|
Lifetime of a device
|
Any |
Reliability of a set of components. |
|
Lognormal random walk |
Link |
Any |
|
Marital status in 25 years
|
Professional or Industrial |
Modeling a Markov time series with time an integer > 1 unit with ModelRisk. |
|
Market growth model
|
Any |
Exercise to allow you to try out various modeling techniques. |
|
Market Size Estimation |
Any |
||
Markov chain multinomial method
|
Professional or Industrial |
Multinomial method of performing a Markov Chain model. |
|
Markov chain multinomial method 2
|
Professional or Industrial |
Multinomial method of performing a Markov Chain model with time an integer > 1 unit. |
|
Markov tracking |
Professional or Industrial |
Progressive dominance of the default state in a Markov time series. |
|
Mean value comparison |
Link |
Industrial |
|
Missile2 |
Link |
Industrial |
|
Missile3 |
Link |
Industrial |
|
Missile |
Link |
Industrial |
|
MTTF
|
Professional or Industrial |
Bayesian inference, estimating MTTF. |
|
Multivariate hypergeometric
|
Professional or Industrial |
Construct a Multivariate Hypergeometric distribution. |
|
|
Any |
Model sales where market is divided with new entry competitors. |
|
Link |
Professional or Industrial |
|
|
NPV of a capital investment
|
Professional or Industrial |
Exercise to allow you to try out various modeling techniques. |
|
Offshore Oil Platform |
Link |
Any |
|
One lightbulb
|
Professional or Industrial |
||
Operational risk
|
Industrial |
Capital allocation to cover operational risk under Basel II. |
|
Optimization example model |
Link |
Professional or Industrial |
|
Pareto extremes
|
Professional or Industrial |
Determination of extreme values for 10 000 independent random variables drawn from a Pareto(5,2) distribution. |
|
Particles in a volume |
Link |
Any |
|
Pats |
Link |
Any |
|
People in a lift
|
Professional or Industrial |
Calculating (rather than simulating) the probability that a sum of random variables exceeds some target. |
|
Plane crashes1 |
Link |
Professional or Industrial |
|
Plane crashes2
|
Any |
Poisson process with time log. Sum of random number of random variables Insurance claim size. |
|
Poisson random walk
|
Any |
Poisson random walk with trend. |
|
Poisson sales with competitor
|
Any |
Forecasting Poisson sales with new competitor entering the market. |
|
Poisson series
|
Any |
Poisson random walk with trend and seasonality. |
|
Polya regression
|
Professional or Industrial |
Pólya regression model fitted to data and projected three years into the future. |
|
Polya time series
|
Any |
Similar to Poisson series but with randomness in the expected intensity |
|
Power units |
Link |
Any |
|
Power station pumps
|
Any |
Modeling continuous random process. |
|
Premium calculations
|
Industrial |
Calculating the premium of an insurance policy using four different principles |
|
Prevalence estimate for imperfect test |
Link |
Professional or Industrial |
|
Probability of ruin
|
Link |
Any |
Estimating combined risk from several risk events. Probability of exceeding some threshold. |
Project schedule 1
|
Any |
Typical project schedule model. |
|
Project schedule 2
|
Any |
Project schedule model. Schedule risk modeled as additional duration. |
|
Project schedule 3
|
Any |
Project schedule model. Schedule risk modeled as alternative duration. |
|
Projected cures
|
Any |
Time series with cyclical shock. |
|
Pylons
|
Any |
Exercise to allow you to try out various modeling techniques. |
|
Pylons correlated
|
Any |
Exercise to allow you to try out various modeling techniques. |
|
Raw egg |
Link |
Industrial |
|
Real option
|
Professional or Industrial |
Real option evaluation. |
|
Recursive formulae |
Link |
Any |
|
Regression Bootstrap X Y random using INDEX |
Link |
Any |
|
Regression Bootstrap X Y random using OFFSET |
Link |
Any |
|
Regression Bootstrap X Y random using VLOOKUP |
Link |
Any |
|
Risk portfolio
|
Professional or Industrial |
Modeling impact of correlated risks. VoseRiskEvent function. |
|
Roof of office block
|
Any |
Using triangle distributions to estimate project cost. |
|
Runoff1
|
Industrial |
Run-off calculation. |
|
Runoff2
|
Industrial |
Run-off calculation. |
|
Runoff3
|
Industrial |
Run-off calculation. |
|
Sales at the store
|
Professional or Industrial |
Summing large random number of random variables using Central Limit Theorem |
|
Sales projection for a finite market
|
Any |
Model the sales over a period where it is known that there is a finite market for the product. |
|
Sales with maximum
|
Any |
Modeling sales where there is an uncertain maximum to the number of sales. |
|
Schedule model with risks
|
Any |
Project schedule modeling with risks. |
|
Seasonal Poisson random walk |
Link |
Any |
|
Share price movement |
Link |
Professional or Industrial |
|
Silo
|
Link |
Any |
Simple project duration model. |
Simulating a variable risk
|
Link |
Any |
Two ways of simulating a risk event with a random impact. |
Stress and strength
|
Any |
Model to determine the probability that stress on a component exceeds its strength, and therefore causes it to fail. |
|
Ten lightbulbs |
Professional or Industrial |
Modeling a parallel renewal process. |
|
The weakest link
|
Link |
Professional or Industrial |
Extremes, Simulating probability. |
Link |
Professional or Industrial |
|
|
Any |
|||
Any |
Estimating total cost of Poisson failures at different rates. Note this is a VC/RS/US model. |
||
Professional or Industrial |
|||
Treatment comparison
|
Any |
Comparison of several uncertain binomial probabilities. |
|
Turbine blade construction
|
Professional or Industrial |
||
Turbine blade simulation
|
Any |
||
Turbine blade construction |
Link |
Professional or Industrial |
|
TV series profits
|
Professional or Industrial |
||
Using the VoseIntegrate function |
Industrial |
Numerical Integration. |
|
VC RC US - 1
|
Link |
Professional or Industrial |
Part 1 of a simple example of a VC/RC/US model: randomness R only. |
VC RC US - 2
|
Link |
Professional or Industrial |
Part 2 of a simple example of a VC/RC/US model: randomness R and uncertainty U |
VC RC US - 3
|
Link |
Professional or Industrial |
Part 3 of a simple example of a VC/RC/US model: randomness R, uncertainty U and variability V |
VC RS UL - 1
|
Link |
Any |
Simple example of a VC/RS/UL model part 1: generating values for uncertain parameters. |
Professional or Industrial |
Numerical integration | ||
VoseAggregateTranche |
Link |
Industrial |
|
VoseOptimalFit and related functions |
Professional or Industrial |
|
|
VoseBinomialP |
Link |
Professional or Industrial |
|
VoseCholesky |
Link |
Industrial |
|
VoseCLTSum |
Link |
Professional or Industrial |
|
VoseCopulaOptimalFit and related functions |
Professional or Industrial |
|
|
VoseCopula Correlating with copulas |
Link |
Professional or Industrial |
|
VoseCopulaData |
Link |
Professional or Industrial |
|
VoseCopulaDataSeries |
Link |
Professional or Industrial |
|
VoseCorrmat |
Link |
Professional or Industrial |
|
VoseCovCorr |
Link |
Professional or Industrial |
|
VoseDescription and VoseParameters |
Link |
Industrial |
|
VoseDominance |
Link |
Professional or Industrial |
|
VoseEigenValues |
Link |
Industrial |
|
VoseEigenVectors |
Link |
Industrial |
|
VoseExpression |
Link |
Professional or Industrial |
|
VoseFrequency |
Link |
Professional or Industrial |
|
VoseFrequencyCumulA |
Link |
Professional or Industrial |
|
VoseFrequencyCumulD |
Link |
Professional or Industrial |
|
VoseIdentity |
Link |
Professional or Industrial |
|
VoseIntegrate |
Link |
Industrial |
|
VoseInterpolate |
Link |
Industrial |
|
VosejkProduct |
Link |
Industrial |
|
VosejkSum |
Link |
Industrial |
|
VosejProduct |
Link |
Industrial |
|
VosejSum |
Link |
Industrial |
|
VosejSumInf |
Link |
Industrial |
|
VoseKendallsTau and VoseSpearman |
Link |
Industrial |
|
VoseKendallsTau |
Link |
Industrial |
|
VoseLLH |
Link |
Professional or Industrial |
|
VoseMeanExcessP and VoseMeanExcessX |
Link |
Industrial |
|
VoseNBoot Bootstrap Properties |
Link |
Professional or Industrial |
|
VoseODE |
Link |
Industrial |
|
VoseOgive1 and VoseOgive2 |
Link |
Professional or Industrial |
|
VosePoissonLambda |
Link |
Professional or Industrial |
|
VosePrinciple Principle calculations |
Link |
Industrial |
|
VoseRankA |
Link |
Professional or Industrial |
|
VoseRankD |
Link |
Professional or Industrial |
|
VoseRolling Stats |
Link |
Professional or Industrial |
|
VoseRunoff |
Link |
Industrial |
|
VoseSample |
Link |
Professional or Industrial |
|
VoseShift, VosePBounds and VoseXBounds |
Link |
Professional or Industrial |
|
VoseShuffle |
Link |
Professional or Industrial |
|
VoseSimXxxx |
Link |
Professional or Industrial |
|
VoseSortA |
Link |
Professional or Industrial |
|
VoseSortD |
Link |
Professional or Industrial |
|
VoseStopSum |
Link |
Professional or Industrial |
|
VoseThielU |
Link |
Professional or Industrial |
|
VoseTimeOptimalFit and related functions |
Professional or Industrial |
|
|
VoseValidCorrmat |
Link |
Professional or Industrial |
|
VS RS US - 1 |
Link |
Any |
|
VS RS US - 2 |
Link |
Any |
|
Waiting under the clock |
Link |
Any |
|
Weibull |
Link |
Any |
|
Widgets
|
Any |
Simple MC simulation |
|
Wine experts |
Any |
||
Wine problem |
Link |
Any |
|
Navigation
- Risk management
- Risk management introduction
- What are risks and opportunities?
- Planning a risk analysis
- Clearly stating risk management questions
- Evaluating risk management options
- Introduction to risk analysis
- The quality of a risk analysis
- Using risk analysis to make better decisions
- Explaining a models assumptions
- Statistical descriptions of model outputs
- Simulation Statistical Results
- Preparing a risk analysis report
- Graphical descriptions of model outputs
- Presenting and using results introduction
- Statistical descriptions of model results
- Mean deviation (MD)
- Range
- Semi-variance and semi-standard deviation
- Kurtosis (K)
- Mean
- Skewness (S)
- Conditional mean
- Custom simulation statistics table
- Mode
- Cumulative percentiles
- Median
- Relative positioning of mode median and mean
- Variance
- Standard deviation
- Inter-percentile range
- Normalized measures of spread - the CofV
- Graphical descriptionss of model results
- Showing probability ranges
- Overlaying histogram plots
- Scatter plots
- Effect of varying number of bars
- Sturges rule
- Relationship between cdf and density (histogram) plots
- Difficulty of interpreting the vertical scale
- Stochastic dominance tests
- Risk-return plots
- Second order cumulative probability plot
- Ascending and descending cumulative plots
- Tornado plot
- Box Plot
- Cumulative distribution function (cdf)
- Probability density function (pdf)
- Crude sensitivity analysis for identifying important input distributions
- Pareto Plot
- Trend plot
- Probability mass function (pmf)
- Overlaying cdf plots
- Cumulative Plot
- Simulation data table
- Statistics table
- Histogram Plot
- Spider plot
- Determining the width of histogram bars
- Plotting a variable with discrete and continuous elements
- Smoothing a histogram plot
- Risk analysis modeling techniques
- Monte Carlo simulation
- Monte Carlo simulation introduction
- Monte Carlo simulation in ModelRisk
- Filtering simulation results
- Output/Input Window
- Simulation Progress control
- Running multiple simulations
- Random number generation in ModelRisk
- Random sampling from input distributions
- How many Monte Carlo samples are enough?
- Probability distributions
- Distributions introduction
- Probability calculations in ModelRisk
- Selecting the appropriate distributions for your model
- List of distributions by category
- Distribution functions and the U parameter
- Univariate continuous distributions
- Beta distribution
- Beta Subjective distribution
- Four-parameter Beta distribution
- Bradford distribution
- Burr distribution
- Cauchy distribution
- Chi distribution
- Chi Squared distribution
- Continuous distributions introduction
- Continuous fitted distribution
- Cumulative ascending distribution
- Cumulative descending distribution
- Dagum distribution
- Erlang distribution
- Error distribution
- Error function distribution
- Exponential distribution
- Exponential family of distributions
- Extreme Value Minimum distribution
- Extreme Value Maximum distribution
- F distribution
- Fatigue Life distribution
- Gamma distribution
- Generalized Extreme Value distribution
- Generalized Logistic distribution
- Generalized Trapezoid Uniform (GTU) distribution
- Histogram distribution
- Hyperbolic-Secant distribution
- Inverse Gaussian distribution
- Johnson Bounded distribution
- Johnson Unbounded distribution
- Kernel Continuous Unbounded distribution
- Kumaraswamy distribution
- Kumaraswamy Four-parameter distribution
- Laplace distribution
- Levy distribution
- Lifetime Two-Parameter distribution
- Lifetime Three-Parameter distribution
- Lifetime Exponential distribution
- LogGamma distribution
- Logistic distribution
- LogLaplace distribution
- LogLogistic distribution
- LogLogistic Alternative parameter distribution
- LogNormal distribution
- LogNormal Alternative-parameter distribution
- LogNormal base B distribution
- LogNormal base E distribution
- LogTriangle distribution
- LogUniform distribution
- Noncentral Chi squared distribution
- Noncentral F distribution
- Normal distribution
- Normal distribution with alternative parameters
- Maxwell distribution
- Normal Mix distribution
- Relative distribution
- Ogive distribution
- Pareto (first kind) distribution
- Pareto (second kind) distribution
- Pearson Type 5 distribution
- Pearson Type 6 distribution
- Modified PERT distribution
- PERT distribution
- PERT Alternative-parameter distribution
- Reciprocal distribution
- Rayleigh distribution
- Skew Normal distribution
- Slash distribution
- SplitTriangle distribution
- Student-t distribution
- Three-parameter Student distribution
- Triangle distribution
- Triangle Alternative-parameter distribution
- Uniform distribution
- Weibull distribution
- Weibull Alternative-parameter distribution
- Three-Parameter Weibull distribution
- Univariate discrete distributions
- Discrete distributions introduction
- Bernoulli distribution
- Beta-Binomial distribution
- Beta-Geometric distribution
- Beta-Negative Binomial distribution
- Binomial distribution
- Burnt Finger Poisson distribution
- Delaporte distribution
- Discrete distribution
- Discrete Fitted distribution
- Discrete Uniform distribution
- Geometric distribution
- HypergeoM distribution
- Hypergeometric distribution
- HypergeoD distribution
- Inverse Hypergeometric distribution
- Logarithmic distribution
- Negative Binomial distribution
- Poisson distribution
- Poisson Uniform distribution
- Polya distribution
- Skellam distribution
- Step Uniform distribution
- Zero-modified counting distributions
- More on probability distributions
- Multivariate distributions
- Multivariate distributions introduction
- Dirichlet distribution
- Multinomial distribution
- Multivariate Hypergeometric distribution
- Multivariate Inverse Hypergeometric distribution type2
- Negative Multinomial distribution type 1
- Negative Multinomial distribution type 2
- Multivariate Inverse Hypergeometric distribution type1
- Multivariate Normal distribution
- More on probability distributions
- Approximating one distribution with another
- Approximations to the Inverse Hypergeometric Distribution
- Normal approximation to the Gamma Distribution
- Normal approximation to the Poisson Distribution
- Approximations to the Hypergeometric Distribution
- Stirlings formula for factorials
- Normal approximation to the Beta Distribution
- Approximation of one distribution with another
- Approximations to the Negative Binomial Distribution
- Normal approximation to the Student-t Distribution
- Approximations to the Binomial Distribution
- Normal_approximation_to_the_Binomial_distribution
- Poisson_approximation_to_the_Binomial_distribution
- Normal approximation to the Chi Squared Distribution
- Recursive formulas for discrete distributions
- Normal approximation to the Lognormal Distribution
- Normal approximations to other distributions
- Approximating one distribution with another
- Correlation modeling in risk analysis
- Common mistakes when adapting spreadsheet models for risk analysis
- More advanced risk analysis methods
- SIDs
- Modeling with objects
- ModelRisk database connectivity functions
- PK/PD modeling
- Value of information techniques
- Simulating with ordinary differential equations (ODEs)
- Optimization of stochastic models
- ModelRisk optimization extension introduction
- Optimization Settings
- Defining Simulation Requirements in an Optimization Model
- Defining Decision Constraints in an Optimization Model
- Optimization Progress control
- Defining Targets in an Optimization Model
- Defining Decision Variables in an Optimization Model
- Optimization Results
- Summing random variables
- Aggregate distributions introduction
- Aggregate modeling - Panjer's recursive method
- Adding correlation in aggregate calculations
- Sum of a random number of random variables
- Moments of an aggregate distribution
- Aggregate modeling in ModelRisk
- Aggregate modeling - Fast Fourier Transform (FFT) method
- How many random variables add up to a fixed total
- Aggregate modeling - compound Poisson approximation
- Aggregate modeling - De Pril's recursive method
- Testing and modeling causal relationships
- Stochastic time series
- Time series introduction
- Time series in ModelRisk
- Autoregressive models
- Thiel inequality coefficient
- Effect of an intervention at some uncertain point in time
- Log return of a Time Series
- Markov Chain models
- Seasonal time series
- Bounded random walk
- Time series modeling in finance
- Birth and death models
- Time series models with leading indicators
- Geometric Brownian Motion models
- Time series projection of events occurring randomly in time
- Simulation for six sigma
- ModelRisk's Six Sigma functions
- VoseSixSigmaCp
- VoseSixSigmaCpkLower
- VoseSixSigmaProbDefectShift
- VoseSixSigmaLowerBound
- VoseSixSigmaK
- VoseSixSigmaDefectShiftPPMUpper
- VoseSixSigmaDefectShiftPPMLower
- VoseSixSigmaDefectShiftPPM
- VoseSixSigmaCpm
- VoseSixSigmaSigmaLevel
- VoseSixSigmaCpkUpper
- VoseSixSigmaCpk
- VoseSixSigmaDefectPPM
- VoseSixSigmaProbDefectShiftLower
- VoseSixSigmaProbDefectShiftUpper
- VoseSixSigmaYield
- VoseSixSigmaUpperBound
- VoseSixSigmaZupper
- VoseSixSigmaZmin
- VoseSixSigmaZlower
- Modeling expert opinion
- Modeling expert opinion introduction
- Sources of error in subjective estimation
- Disaggregation
- Distributions used in modeling expert opinion
- A subjective estimate of a discrete quantity
- Incorporating differences in expert opinions
- Modeling opinion of a variable that covers several orders of magnitude
- Maximum entropy
- Probability theory and statistics
- Probability theory and statistics introduction
- Stochastic processes
- Stochastic processes introduction
- Poisson process
- Hypergeometric process
- The hypergeometric process
- Number in a sample with a particular characteristic in a hypergeometric process
- Number of hypergeometric samples to get a specific number of successes
- Number of samples taken to have an observed s in a hypergeometric process
- Estimate of population and sub-population sizes in a hypergeometric process
- The binomial process
- Renewal processes
- Mixture processes
- Martingales
- Estimating model parameters from data
- The basics
- Probability equations
- Probability theorems and useful concepts
- Probability parameters
- Probability rules and diagrams
- The definition of probability
- The basics of probability theory introduction
- Fitting probability models to data
- Fitting time series models to data
- Fitting correlation structures to data
- Fitting in ModelRisk
- Fitting probability distributions to data
- Fitting distributions to data
- Method of Moments (MoM)
- Check the quality of your data
- Kolmogorov-Smirnoff (K-S) Statistic
- Anderson-Darling (A-D) Statistic
- Goodness of fit statistics
- The Chi-Squared Goodness-of-Fit Statistic
- Determining the joint uncertainty distribution for parameters of a distribution
- Using Method of Moments with the Bootstrap
- Maximum Likelihood Estimates (MLEs)
- Fitting a distribution to truncated censored or binned data
- Critical Values and Confidence Intervals for Goodness-of-Fit Statistics
- Matching the properties of the variable and distribution
- Transforming discrete data before performing a parametric distribution fit
- Does a parametric distribution exist that is well known to fit this type of variable?
- Censored data
- Fitting a continuous non-parametric second-order distribution to data
- Goodness of Fit Plots
- Fitting a second order Normal distribution to data
- Using Goodness-of Fit Statistics to optimize Distribution Fitting
- Information criteria - SIC HQIC and AIC
- Fitting a second order parametric distribution to observed data
- Fitting a distribution for a continuous variable
- Does the random variable follow a stochastic process with a well-known model?
- Fitting a distribution for a discrete variable
- Fitting a discrete non-parametric second-order distribution to data
- Fitting a continuous non-parametric first-order distribution to data
- Fitting a first order parametric distribution to observed data
- Fitting a discrete non-parametric first-order distribution to data
- Fitting distributions to data
- Technical subjects
- Comparison of Classical and Bayesian methods
- Comparison of classic and Bayesian estimate of Normal distribution parameters
- Comparison of classic and Bayesian estimate of intensity lambda in a Poisson process
- Comparison of classic and Bayesian estimate of probability p in a binomial process
- Which technique should you use?
- Comparison of classic and Bayesian estimate of mean "time" beta in a Poisson process
- Classical statistics
- Bayesian
- Bootstrap
- The Bootstrap
- Linear regression parametric Bootstrap
- The Jackknife
- Multiple variables Bootstrap Example 2: Difference between two population means
- Linear regression non-parametric Bootstrap
- The parametric Bootstrap
- Bootstrap estimate of prevalence
- Estimating parameters for multiple variables
- Example: Parametric Bootstrap estimate of the mean of a Normal distribution with known standard deviation
- The non-parametric Bootstrap
- Example: Parametric Bootstrap estimate of mean number of calls per hour at a telephone exchange
- The Bootstrap likelihood function for Bayesian inference
- Multiple variables Bootstrap Example 1: Estimate of regression parameters
- Bayesian inference
- Uninformed priors
- Conjugate priors
- Prior distributions
- Bayesian analysis with threshold data
- Bayesian analysis example: gender of a random sample of people
- Informed prior
- Simulating a Bayesian inference calculation
- Hyperparameters
- Hyperparameter example: Micro-fractures on turbine blades
- Constructing a Bayesian inference posterior distribution in Excel
- Bayesian analysis example: Tigers in the jungle
- Markov chain Monte Carlo (MCMC) simulation
- Introduction to Bayesian inference concepts
- Bayesian estimate of the mean of a Normal distribution with known standard deviation
- Bayesian estimate of the mean of a Normal distribution with unknown standard deviation
- Determining prior distributions for correlated parameters
- Improper priors
- The Jacobian transformation
- Subjective prior based on data
- Taylor series approximation to a Bayesian posterior distribution
- Bayesian analysis example: The Monty Hall problem
- Determining prior distributions for uncorrelated parameters
- Subjective priors
- Normal approximation to the Beta posterior distribution
- Bayesian analysis example: identifying a weighted coin
- Bayesian estimate of the standard deviation of a Normal distribution with known mean
- Likelihood functions
- Bayesian estimate of the standard deviation of a Normal distribution with unknown mean
- Determining a prior distribution for a single parameter estimate
- Simulating from a constructed posterior distribution
- Bootstrap
- Comparison of Classical and Bayesian methods
- Analyzing and using data introduction
- Data Object
- Vose probability calculation
- Bayesian model averaging
- Miscellaneous
- Excel and ModelRisk model design and validation techniques
- Using range names for model clarity
- Color coding models for clarity
- Compare with known answers
- Checking units propagate correctly
- Stressing parameter values
- Model Validation and behavior introduction
- Informal auditing
- Analyzing outputs
- View random scenarios on screen and check for credibility
- Split up complex formulas (megaformulas)
- Building models that are efficient
- Comparing predictions against reality
- Numerical integration
- Comparing results of alternative models
- Building models that are easy to check and modify
- Model errors
- Model design introduction
- About array functions in Excel
- Excel and ModelRisk model design and validation techniques
- Monte Carlo simulation
- RISK ANALYSIS SOFTWARE
- Risk analysis software from Vose Software
- ModelRisk - risk modeling in Excel
- ModelRisk functions explained
- VoseCopulaOptimalFit and related functions
- VoseTimeOptimalFit and related functions
- VoseOptimalFit and related functions
- VoseXBounds
- VoseCLTSum
- VoseAggregateMoments
- VoseRawMoments
- VoseSkewness
- VoseMoments
- VoseKurtosis
- VoseAggregatePanjer
- VoseAggregateFFT
- VoseCombined
- VoseCopulaBiGumbel
- VoseCopulaBiClayton
- VoseCopulaBiNormal
- VoseCopulaBiT
- VoseKendallsTau
- VoseRiskEvent
- VoseCopulaBiFrank
- VoseCorrMatrix
- VoseRank
- VoseValidCorrmat
- VoseSpearman
- VoseCopulaData
- VoseCorrMatrixU
- VoseTimeSeasonalGBM
- VoseMarkovSample
- VoseMarkovMatrix
- VoseThielU
- VoseTimeEGARCH
- VoseTimeAPARCH
- VoseTimeARMA
- VoseTimeDeath
- VoseTimeAR1
- VoseTimeAR2
- VoseTimeARCH
- VoseTimeMA2
- VoseTimeGARCH
- VoseTimeGBMJDMR
- VoseTimePriceInflation
- VoseTimeGBMMR
- VoseTimeWageInflation
- VoseTimeLongTermInterestRate
- VoseTimeMA1
- VoseTimeGBM
- VoseTimeGBMJD
- VoseTimeShareYields
- VoseTimeYule
- VoseTimeShortTermInterestRate
- VoseDominance
- VoseLargest
- VoseSmallest
- VoseShift
- VoseStopSum
- VoseEigenValues
- VosePrincipleEsscher
- VoseAggregateMultiFFT
- VosePrincipleEV
- VoseCopulaMultiNormal
- VoseRunoff
- VosePrincipleRA
- VoseSumProduct
- VosePrincipleStdev
- VosePoissonLambda
- VoseBinomialP
- VosePBounds
- VoseAIC
- VoseHQIC
- VoseSIC
- VoseOgive1
- VoseFrequency
- VoseOgive2
- VoseNBootStdev
- VoseNBoot
- VoseSimulate
- VoseNBootPaired
- VoseAggregateMC
- VoseMean
- VoseStDev
- VoseAggregateMultiMoments
- VoseDeduct
- VoseExpression
- VoseLargestSet
- VoseKthSmallest
- VoseSmallestSet
- VoseKthLargest
- VoseNBootCofV
- VoseNBootPercentile
- VoseExtremeRange
- VoseNBootKurt
- VoseCopulaMultiClayton
- VoseNBootMean
- VoseTangentPortfolio
- VoseNBootVariance
- VoseNBootSkewness
- VoseIntegrate
- VoseInterpolate
- VoseCopulaMultiGumbel
- VoseCopulaMultiT
- VoseAggregateMultiMC
- VoseCopulaMultiFrank
- VoseTimeMultiMA1
- VoseTimeMultiMA2
- VoseTimeMultiGBM
- VoseTimeMultBEKK
- VoseAggregateDePril
- VoseTimeMultiAR1
- VoseTimeWilkie
- VoseTimeDividends
- VoseTimeMultiAR2
- VoseRuinFlag
- VoseRuinTime
- VoseDepletionShortfall
- VoseDepletion
- VoseDepletionFlag
- VoseDepletionTime
- VosejProduct
- VoseCholesky
- VoseTimeSimulate
- VoseNBootSeries
- VosejkProduct
- VoseRuinSeverity
- VoseRuin
- VosejkSum
- VoseTimeDividendsA
- VoseRuinNPV
- VoseTruncData
- VoseSample
- VoseIdentity
- VoseCopulaSimulate
- VoseSortA
- VoseFrequencyCumulA
- VoseAggregateDeduct
- VoseMeanExcessP
- VoseProb10
- VoseSpearmanU
- VoseSortD
- VoseFrequencyCumulD
- VoseRuinMaxSeverity
- VoseMeanExcessX
- VoseRawMoment3
- VosejSum
- VoseRawMoment4
- VoseNBootMoments
- VoseVariance
- VoseTimeShortTermInterestRateA
- VoseTimeLongTermInterestRateA
- VoseProb
- VoseDescription
- VoseCofV
- VoseAggregateProduct
- VoseEigenVectors
- VoseTimeWageInflationA
- VoseRawMoment1
- VosejSumInf
- VoseRawMoment2
- VoseShuffle
- VoseRollingStats
- VoseSplice
- VoseTSEmpiricalFit
- VoseTimeShareYieldsA
- VoseParameters
- VoseAggregateTranche
- VoseCovToCorr
- VoseCorrToCov
- VoseLLH
- VoseTimeSMEThreePoint
- VoseDataObject
- VoseCopulaDataSeries
- VoseDataRow
- VoseDataMin
- VoseDataMax
- VoseTimeSME2Perc
- VoseTimeSMEUniform
- VoseTimeSMESaturation
- VoseOutput
- VoseInput
- VoseTimeSMEPoisson
- VoseTimeBMAObject
- VoseBMAObject
- VoseBMAProb10
- VoseBMAProb
- VoseCopulaBMA
- VoseCopulaBMAObject
- VoseTimeEmpiricalFit
- VoseTimeBMA
- VoseBMA
- VoseSimKurtosis
- VoseOptConstraintMin
- VoseSimProbability
- VoseCurrentSample
- VoseCurrentSim
- VoseLibAssumption
- VoseLibReference
- VoseSimMoments
- VoseOptConstraintMax
- VoseSimMean
- VoseOptDecisionContinuous
- VoseOptRequirementEquals
- VoseOptRequirementMax
- VoseOptRequirementMin
- VoseOptTargetMinimize
- VoseOptConstraintEquals
- VoseSimVariance
- VoseSimSkewness
- VoseSimTable
- VoseSimCofV
- VoseSimPercentile
- VoseSimStDev
- VoseOptTargetValue
- VoseOptTargetMaximize
- VoseOptDecisionDiscrete
- VoseSimMSE
- VoseMin
- VoseMin
- VoseOptDecisionList
- VoseOptDecisionBoolean
- VoseOptRequirementBetween
- VoseOptConstraintBetween
- VoseSimMax
- VoseSimSemiVariance
- VoseSimSemiStdev
- VoseSimMeanDeviation
- VoseSimMin
- VoseSimCVARp
- VoseSimCVARx
- VoseSimCorrelation
- VoseSimCorrelationMatrix
- VoseOptConstraintString
- VoseOptCVARx
- VoseOptCVARp
- VoseOptPercentile
- VoseSimValue
- VoseSimStop
- Precision Control Functions
- VoseAggregateDiscrete
- VoseTimeMultiGARCH
- VoseTimeGBMVR
- VoseTimeGBMAJ
- VoseTimeGBMAJVR
- VoseSID
- Generalized Pareto Distribution (GPD)
- Generalized Pareto Distribution (GPD) Equations
- Three-Point Estimate Distribution
- Three-Point Estimate Distribution Equations
- VoseCalibrate
- ModelRisk interfaces
- Integrate
- Data Viewer
- Stochastic Dominance
- Library
- Correlation Matrix
- Portfolio Optimization Model
- Common elements of ModelRisk interfaces
- Risk Event
- Extreme Values
- Select Distribution
- Combined Distribution
- Aggregate Panjer
- Interpolate
- View Function
- Find Function
- Deduct
- Ogive
- AtRISK model converter
- Aggregate Multi FFT
- Stop Sum
- Crystal Ball model converter
- Aggregate Monte Carlo
- Splicing Distributions
- Subject Matter Expert (SME) Time Series Forecasts
- Aggregate Multivariate Monte Carlo
- Ordinary Differential Equation tool
- Aggregate FFT
- More on Conversion
- Multivariate Copula
- Bivariate Copula
- Univariate Time Series
- Modeling expert opinion in ModelRisk
- Multivariate Time Series
- Sum Product
- Aggregate DePril
- Aggregate Discrete
- Expert
- ModelRisk introduction
- Building and running a simple example model
- Distributions in ModelRisk
- List of all ModelRisk functions
- Custom applications and macros
- ModelRisk functions explained
- Tamara - project risk analysis
- Introduction to Tamara project risk analysis software
- Launching Tamara
- Importing a schedule
- Assigning uncertainty to the amount of work in the project
- Assigning uncertainty to productivity levels in the project
- Adding risk events to the project schedule
- Adding cost uncertainty to the project schedule
- Saving the Tamara model
- Running a Monte Carlo simulation in Tamara
- Reviewing the simulation results in Tamara
- Using Tamara results for cost and financial risk analysis
- Creating, updating and distributing a Tamara report
- Tips for creating a schedule model suitable for Monte Carlo simulation
- Random number generator and sampling algorithms used in Tamara
- Probability distributions used in Tamara
- Correlation with project schedule risk analysis
- Pelican - enterprise risk management