Index
- accountability
- biases
- shared
- Add Output function, @RISK
- add-in creation, Excel
- adding comments to VBA code
- addition, static risk values
- Advanced Sensitivity Analysis
- advantages
- correlated sampling
- resampling methods
- aggregate delays
- aggregate risk optimisation
- aggregation
- benefits
- core design principles
- risk registers
- risk-driven occurrences
- static risk values
- algorithms
- @RISK sampling
- random number generation in VBA
- aligning assessment and modelling
- allocation of contingency
- alternative parameters, @RISK
- analysis
- model during design
- principles
- sampling, @RISK
- sheets in Excel/VBA
- anchoring, biases
- applicability of simulation methods
- approaches to risk quantification
- approximations
- continuous distributions
- distributions by other distributions
- modelling choices
- parameter matching
- potential pitfalls
- Archimedean copulas
- array functions
- Excel
- Visual basic
- ascending percentiles
- assigning values, Visual Basic into Excel
- assumptions
- biases
- careful selection
- transparency
- asymmetric impacts, biases
- @RISK
- alternate parameters
- auditing
- benefits
- beta distributions
- binomial distributions
- core steps
- correlations
- dependencies
- distribution approximations
- distribution special applications
- distribution/time series fitting
- exponential distributions
- extreme value distributions
- fixing the seed
- general discrete distributions
- input statistics functions
- integer uniform distributions
- kurtosis
- lognormal distributions
- macros
- MS project integration
- multiple simulations
- normal distributions
- optimisation
- Pareto distributions
- PERT distributions
- reducing run time
- repeating simulations
- report generation by macros
- results statistics
- running simulations
- sampling
- analysis macros
- comparisons with Excel
- scatter plots
- sense checking
- simulation control
- special applications of distributions
- standard deviation
- static view
- storing results
- time series correlation
- tornado graphs
- viewing results
- auditing, @RISK models
- Australian Stock Exchange
- authority
- automating
- data filter clearing
- recalculations in Excel/VBA
- autoregressive models
- average
- see also mean
- backward calculations
- barriers to modelling
- base cases
- everyday examples
- full model integration
- likelihood
- separating risk distributions
- strategic option development
- basic mean-reversion models
- Bayesian analysis
- benefits
- aggregation
- @RISK
- formal risk assessments
- full risk models
- qualitative risk registers
- Bernoulli distributions
- Bernoulli processes
- beta distributions
- geometric distributions
- periods-of-occurrence
- best estimates
- best practice, Visual Basic
- beta distributions
- beta general distributions
- beta-Bernoulli processes
- beta-binomial processes
- biases
- cognitive
- motivational
- non-symmetry
- political
- reduction
- structural
- to action
- binomial distributions
- Black-Scholes formula
- bottom-up versus top-down implementation
- Browse Results icon, @RISK
- business design, risk assessment
- business issues, versus risks
- capturing event risks
- category-driven variability
- centiles see percentiles
- central point, measures of
- centre of gravity
- challenges in risk mapping
- change management
- Change in Output Mean tornados
- chi-squared distributions
- choice versus uncertainty
- Cholesky factorisation
- Clayton copulas
- clearing
- Data Filters
- DataTables
- previous results
- closed-form solutions
- co-directional (integrated) processes
- code modules, Visual Basic
- coefficient of skewness
- cognitive biases
- Columbia space shuttle disaster, 2003
- COMBIN function, Excel
- comments, Visual Basic code
- common causalities, capturing
- common risk drivers
- correlation matrices
- evaluation
- modelling
- risk prioritisation
- communication
- decision effects versus uncertainties
- full risk models
- risk model design
- see also graphs; visual representation
- communications focus
- comparisons
- Excel-created inverse samples and @RISK values
- measures of the central point
- risk prioritisation
- competitive advantage
- complacency
- complex dependency modelling
- complexity, risk assessment
- compound distributions
- compound likelihood
- compound processes
- conceptual approaches, distribution selection
- conditional probabilities
- conditional value-at-risk
- confidence intervals
- confirmation bias
- conflicting view resolution
- consistency in risk assessment
- contextual risks
- contingencies
- allocation and ownership of budgets
- levels
- setting
- continuous dependencies
- continuous distributions
- approximations
- chi-squared
- exponential
- extreme value
- F
- log logistic
- logistic distributions
- lognormal
- normal distributions
- Pareto
- PERT distributions
- student/t
- triangular
- uniform
- continuous processes
- cumulative curves
- definition
- density curves
- suitable distributions
- Convergence function, @RISK
- copulas
- core design principles
- aggregation
- choice vs. uncertainties
- Data Filter clearing
- delays/time shifting
- dependencies
- dynamic formulae
- enhanced sensitivity
- fade formulae
- model analysis
- planning and communication
- results interpretation during design
- sensitivity-driven thinking
- simplicity
- switches
- working with existing models
- corporate governance
- Corporate Governance Council on the Australian Stock Exchange
- corporate planning
- CORREL function, Excel
- correlated sampling
- Cholesky factorisation
- copulas
- time series
- VBA array functions
- versus parameter-dependent sampling
- correlation
- @RISK
- capturing
- matrices
- rank coefficients
- scatter plots
- correlation coefficients
- correlation matrices
- Cholesky factorisation
- common risk drivers
- partial dependencies
- validity
- COUNTIFS function, Excel
- Cox-Ingersoll-Ross models
- creativity, risk identification
- credibility of models
- cross-calibration
- cross-functional activities
- cumulative curves
- compound distributions
- continuous processes
- definition
- cumulative distributions
- gamma distributions
- Weibull distributions
- cumulative functions
- exponential distributions
- extreme value distributions
- geometric distributions
- integer uniform distributions
- log-logistic distributions
- logistic distributions
- Pareto distributions
- Poisson distributions
- Weibull distributions
- Data Filter clearing
- data storage
- @RISK
- Excel/VBA
- data-driven approaches, distribution selection
- data-structure-driven dependence
- DataTables
- Choose function
- macro functions
- scenario analysis
- sensitivity analysis
- simulation methods
- decision-making
- biases
- cognitive biases
- formalised risk assessment
- general challenges
- integration
- model planning considerations
- motivational/political biases
- optimisation
- outcome ranges
- project management
- quantification
- rational versus intuitive approaches
- risk tolerances
- shared accountability
- structural biases
- target setting
- versus uncertainties
- decision risks
- prioritisation
- versus business risks
- versus variability
- decision trees
- with future uncertainty
- principles
- real options
- DecisionTools suite
- Deepwater Horizon oil spill
- Define Distribution, @RISK
- defining outputs, Excel/VBA
- delays, risk modelling
- deletion, DataTables with macros
- density curves
- compound distributions
- continuous processes
- definition
- density functions
- exponential distributions
- extreme value distributions
- geometric distributions
- integer uniform distributions
- log logistic distributions
- logistic distributions
- negative binomial distributions
- Pareto distributions
- Poisson distributions
- Weibull distributions
- dependencies
- category-driven variability
- common drivers of variability
- continuous
- core design principles
- correlation coefficients
- correlation matrices
- creation in @RISK
- fade formulae
- full models
- input effects
- joint occurrence
- measurement
- modelling
- non-linear simulation
- parameter-driven
- partial aggregation by category
- Pearson Rank correlation
- real options
- risk registers
- sampling-driven
- scatter plots
- scenario-driven variability
- simultaneous occurrences
- Spearman rank correlation
- time series
- tornado diagrams
- uncertainty modelling
- derivatives
- descending percentiles
- development, business strategy
- direct formula links
- disadvantages
- correlated sampling
- parameter-dependencies
- resampling methods
- disciplines, risk identification
- discrete distributions
- Bernoulli
- binomial
- general
- geometric distributions
- hypergeometric
- measures of the central point
- negative binomial
- Poisson
- discrete processes, definition
- distribution fitting, @RISK
- distributions, see also statistical distributions
- diversification, risk assessment
- doing one's job
- “don't worry, be happy”
- double-counting, risk registers
- drivers of variability
- dynamic formulae creation
- economic evaluation, tolerances
- economics
- averages
- base commodity pricing risk
- value-at-risk
- effective project management
- Elliptical copulas
- embedded procedures, existing models
- energy production, full risk models
- energy provisioning, full risk models
- enhanced decision-making
- enhanced sensitivity analysis
- enterprise-wide risk management
- error, iterations
- escalation of issues
- Euler's constant
- European options trading
- evaluation, commonalities
- event risks
- Evolver software
- exact solutions, combination with simulation methods
- Excel
- add-in creation
- analysis sheets
- @RISK integration
- averages
- backwards calculations
- Bernoulli distributions
- beta distributions
- binomial distributions
- Cholesky factorisation
- Choose function, scenario-driven variability
- clearing Data Filters
- clearing previous results
- confidence intervals
- continuous distribution approximations
- correlated sampling
- DataTables
- easily created inverse functions
- exponential distributions
- extreme value distributions
- gamma distributions
- GoalSeek
- hypergeometric distributions
- impact aggregation
- inserting VBA code modules
- inverse functions
- iterative calculations
- kurtosis
- lognormal distributions
- lookup tables, sample creation
- Mode functions
- negative binomial distributions
- normal distributions
- optimisation modelling
- output links sheets
- percentiles
- Poisson distributions
- RANDBETWEEN
- random value usage
- RANK function
- recording macros
- results sheets
- sample creation
- comparison with @RISK
- inverse functions provided
- lookup tables
- search methods
- VBA code
- scenario analysis
- search methods for sample creation
- sensitivity analysis
- simulation modelling
- basic results analysis
- core capability generalisation
- core steps
- examples
- layout optimisation
- multiple output storing
- multiple simulations
- random number sequences
- running
- structure optimisation
- user input at run time
- Solver
- specific numerical techniques for iterative methods
- standard deviation
- time series correlation
- user-defined functions
- What-If analysis
- see also Visual Basic
- excess contingencies
- exclusion criteria
- existing models
- clearing Data Filters
- embedded procedures
- GoalSeek and Solver
- manual processes
- restructuring
- risk identification and mapping
- working with
- expectation management
- expected tail losses
- expected values
- experience, complexity
- expert input
- explicit risk modelling
- explicit time axes
- exponential distributions
- extreme value distributions
- F-distributions
- final results presentation
- financial crisis, 2008
- financial modelling, value-at-risk
- first-order autoregressive models
- fitting, distributions/time series, @RISK
- fixing the seed, @RISK
- flexibility of formulae
- forecasting
- formal risk assessment
- benefits
- key drivers
- objectives and uses
- frameworks
- distribution selection
- data-driven
- industry standards
- pragmatic approaches
- scientific and conceptual
- distribution selection
- framing biases
- Frank copulas
- freezing, distribution samples, Excel/VBA
- frequency distributions, as outputs
- FREQUENCY function, Excel
- frequency-of-occurrence
- fuel sources, full risk models
- full risk models
- alignment with risk assessment
- assessment and quantification
- base case model integration
- benefits
- bias reduction
- communication and group work
- correlations, common causalities and partial dependencies
- decision-support benefits
- differences to aggregate risk registers
- enhanced decision-making benefits
- event risks
- key characteristics
- multi-variable trade-offs
- non-linear simulation
- operational flexibility
- percentile mapping
- real options
- risk mitigation/response integration
- sensitivity approaches
- simultaneous occurrences
- full stop, Visual Basic syntax
- gamma distributions
- “garbage in, garbage out”
- gating systems
- Gaussian (normal) copula
- GBM see geometric Brownian motion
- general discrete distributions
- general risk assessment, objectives and uses
- generation of reports, @RISK macros
- geometric Brownian motion (GBM)
- geometric distributions
- global switches
- Goal Seek, @RISK
- GoalSeek, Excel
- government guarantees
- graphs
- @RISK
- Excel and Visual Basic simulation
- scatter plots
- tornados
- group think, biases
- group work facilitation
- Gumbel copulas
- high intensity Poisson processes
- high risk/high return projects
- Huang-Litzenberger formulae
- hypergeometric distributions
- icons, @RISK
- “ignorance is bliss”
- impacts
- fade formulae
- non-symmetry
- risk registers
- implementation constraint optimisation
- implied correlations
- improving speed
- @RISK simulations
- Excel/VBA simulation
- incentives
- inclusion criteria, risk prioritisation
- incompleteness, biases
- indentations, Visual Basic code
- independent processes, measures of the central point
- individual projects, portfolio optimisation
- industry standards, distribution selection
- influence
- informal approaches
- information gathering
- inputs
- @RISK
- combinatorial effects
- dependency effects
- role of distributions
- Insert icon, @RISK
- insufficient contingencies
- integer uniform distributions
- integrated (co-directional) processes, modelling
- integration with decision-making
- interim results presentation
- International Organization for Standardization (ISO)
- intuitive approaches
- inverse functions
- easily created in Excel
- Excel provided
- lookup tables in Excel
- percentiles
- readily available
- search methods in Excel
- standard normal distribution
- user-defined
- inverse square root law
- investment portfolio optimisation
- ISO see International Organization for Standardization
- issue escalation
- iterations
- @RISK
- error minimisation
- Excel
- loops in Excel/VBA
- Newton-Raphson method
- risk assessment
- Iterations icon, @RISK
- joint occurrence, measurement
- Kendall tau coefficients
- key drivers for formalised risk assessment
- key objectives of risk mapping
- key stages of risk assessment
- Kübler–Ross model
- kurtosis
- LARGE function, Excel
- Latin Hypercube sampling
- layout optimisation, Excel/VBA
- likelihood
- average values
- base case achievement
- risk prioritisation
- risk registers
- line breaks, Visual Basic code
- linear models, mean averages
- log-logistic distributions
- logistic distributions
- lognormal distributions
- lookup tables, inversions
- loop creation, Visual Basic
- loss of capacity
- low intensity Poisson processes
- macro risks, prioritisation
- macros
- @RISK
- report generation
- sampling analysis
- Excel/VBA
- DataTables
- model switches
- recording
- repeated runs/storage
- @RISK
- management
- culture and processes
- expectations
- risk culture
- risk mitigation
- risk tolerances
- manual processes, existing models
- market pricing
- energy production
- manufactured products
- market share
- Markov chains
- mature projects
- MAX function, Excel
- mean
- mean-reversion models
- measurement of dependencies
- measures of the central point
- comparisons
- median
- mode
- measures of ranges
- median
- minimisation of error, iterations
- mixed portfolio optimisation
- mixed use facilities
- MMULT function, Excel
- mode/modal values
- model analysis
- Model Window icon, @RISK
- modelling
- autoregressive
- category risk drivers
- Cholesky factorisation
- co-directional processes
- common risk drivers
- copulas
- core design principles
- aggregation
- alignment with assessment criteria
- category-driven variability
- decision effects versus uncertainties
- delays/time shifting
- dependencies
- dynamic formulae creation
- enhanced sensitivity processes
- existing models
- fade formulae
- planning and communication
- scenario-driven variability
- sensitivity-driven thinking
- simplicity
- switches
- visual display methods
- correlated sampling
- data-structure-driven dependence
- dependencies
- conditional probabilities
- parameters
- sampling
- time series
- differences to static approaches
- forecasting
- geometric Brownian motion
- implied correlations
- Markov chains
- mean-reversion
- moving averages
- optimisation analysis
- parameter dependencies
- random state switching
- reasons
- resampling
- sampling dependencies
- similarities to static approaches
- time series dependencies
- see also simulation
- modularisation of code, Visual Basic
- monitoring, Excel and Visual Basic simulation
- Monte Carlo sampling, @RISK
- motivational biases
- moving average models
- multi-variable trade-offs
- multiple risks, cross-calibration
- multiple simulations
- @RISK
- Excel/VBA
- multiple switches
- multiplication, static values
- multiplicative processes
- lognormal distributions
- non-symmetry
- skewness
- named ranges, Excel/VBA
- negative binomial distributions
- Newton-Raphson method
- non-intuitive outcomes, lognormal distributions
- non-linear processes, non-symmetry
- non-linear simulation
- non-occurrence
- non-symmetry
- distributions
- effects
- input distributions
- measures of the central point
- skewness
- sources
- uncertainties
- normal distributions
- number of iterations
- numerical integration by simulation
- numerical techniques, Excel
- objectives
- of risk assessment
- setting
- occurrence probabilities, cross-calibration
- oil prices, versus rig costs
- Olympic games, 2012
- operational flexibility, full risk models
- optimisation
- analytic methods
- @RISK
- backward calculations
- business portfolios
- categories of situations
- closed-form solutions
- decision-making
- Evolver function
- implementation constraints
- layout and structure of Excel/VBA simulations
- modelling aspects
- portfolio mapping
- in the presence of risk and uncertainty
- resource deployment
- simulation methods
- Solver function
- speed of simulation
- @RISK
- Excel/VBA
- uncertainty versus choice
- uses of simulation
- optimism
- bias
- percentile mapping
- option trading
- organisational challenges
- aligning assessment and modelling
- bottom-up versus top-down change
- change management
- complacency
- contingency budget ownership
- decision-making integration
- enterprise-wide risk management
- escalation of issues
- incentive systems
- management processes and culture
- previous bad experiences
- proving value
- risk culture
- shared accountability
- standardisation
- working effectively
- organisational complexity
- organisational effectiveness, risk assessment
- Ornstein-Uhlenbeck (Vasicek) models
- outcome-based incentives
- output links sheets, Excel/VBA
- outputs
- data storage
- defining in Excel/VBA
- distributions
- see also graphs; results; visual representation
- overconfidence
- overrunning projects
- oversimplification
- ownership, contingency budgets
- parameter dependencies
- category-dependent
- contextual risks
- continuous dependencies
- definition
- implied correlations
- modelling
- base commodity pricing
- category risk drivers
- common risk drivers
- competitors/market share
- conditional probabilities
- data-structure-driven
- derivative pricing
- oil pricing and rig costs
- phased projects
- resampling
- scenario dependence
- versus correlated sampling
- parameter matching
- Pareto distributions
- partial aggregation
- partial dependencies
- partial periods, time shifting
- participant expectations, management
- pattern recognition
- Pearson rank correlation
- percentiles
- ascending/descending
- concepts
- distribution selection
- Excel/VBA simulations
- inversions
- mapping base case achievement
- random sampling
- PERT distributions
- pessimism, percentile mapping
- phased projects
- planning, risk model design
- Poisson distributions
- political biases
- poor decisions, accountability
- portfolios
- evaluation of commonalities
- mapping
- optimisation
- phase completion risks
- sensitivity analysis
- positively skewed distributions
- PrecisionTree software
- previous result clearing, Excel/VBA
- pricing
- base commodities
- derivatives
- government guarantees
- oil versus rig costs
- trend modelling
- probability distributions
- probability-of-occurrence
- cross-calibration
- multiple risks
- random inputs, Excel/VBA
- risk registers with aggregation
- risk registers without aggregation
- timeframes
- probability-weighted averages
- process-driven incentives
- product method, correlation coefficients
- product upgrade processes
- program evaluation and review technique (PERT) distribution
- progress monitoring, Excel/VBA
- project evaluation
- project management
- project monitoring
- project selection
- projects in implementation
- qualitative approaches
- quantification approaches
- Quick Report function, @RISK
- RANDBETWEEN function, Excel
- random processes
- lognormal distributions
- visual representation
- random sampling
- @RISK
- percentiles
- Visual Basic
- random state switching
- Random/Static Recalculation, @RISK
- ranges
- avoiding underestimation
- measures
- named
- ranges of outcomes
- enhanced decision-making
- value of insights
- rank correlations
- rational-driven approaches
- real options
- recalculations see iterations
- reciprocal distributions, skewness
- recording macros
- reduction of biases
- Regression Coefficients option, @RISK
- Regression-Mapped Values, @RISK
- reinforcing shared accountability
- repeating simulations, @RISK
- replacement, DataTables with macros
- reports, generation, @RISK macros
- resampling, parameter dependencies
- research projects
- reserve levels
- resolution of conflicting views
- resource optimisation
- resource planning
- responsibility, risk-response measures
- restructuring, existing models
- results
- analysis, Excel/VBA
- interpretation, process stages
- statistical functions, @RISK
- storage
- @RISK
- Excel/VBA
- viewing, @RISK
- results sheets, Excel/VBA
- reward-driven approaches
- rig rental costs and oil prices
- risk aggregation, model design
- risk assessment
- alignment with modelling
- approaches
- authority and responsibility
- competitive advantage and organisational effectiveness
- complexity
- corporate governance
- corporate planning
- dependencies
- diversification
- everyday examples
- full risk modelling
- identification
- informal/intuitive approaches
- iterations
- key drivers
- key stages
- mapping
- objectives and uses
- portfolio optimisation
- prioritisation
- project management
- quantification
- research and information gathering
- responses to
- scale
- tolerances
- risk categories, prioritisation
- risk culture management
- risk distributions, comparison to base case models
- risk exploitation
- risk identification
- existing model usage
- importance of definitions
- risk impacts
- risk management
- everyday examples
- intuition
- prominent failures
- risk mapping
- risk measurement
- context-specific
- discrete, continuous and compound processes
- measures of the central point
- percentiles
- uses
- visual representation of random processes
- see also risk quantification
- risk mitigation
- risk prioritisation
- risk profiles
- risk quantification
- approaches
- full risk modelling
- registers with aggregation
- registers without aggregation
- see also risk measurement
- risk reduction
- risk registers
- with aggregation
- definitions
- dependencies
- differing requirements
- double-counting
- with full risk models
- partial impact aggregation by category
- qualitative approaches
- quantitative approaches
- without aggregation
- risk responses
- authority
- benefits of modelling
- full risk models
- risk tolerances
- risk transfer
- risk-driven occurrence aggregation
- RiskBinomial function, @RISK
- RiskCompound function, @RISK
- RiskCorrectCorrmat function, @RISK
- RiskMakeInput function, @RISK
- RiskNormal function, @RISK
- RiskOptimizer, @RISK
- risks
- definition
- simultaneous occurrences
- sizing
- see also sources of risk
- risks of delays
- RiskSimtable function, @RISK
- RiskStdDev function, @RISK
- RiskTheo function, @RISK
- RiskTheoMax function, @RISK
- RiskTheoPtoX function, @RISK
- RiskXtoP function, @RISK
- robust decision-making
- robust risk identification
- rules of thumb, standard deviation
- running simulations
- @RISK
- Excel/VBA
- sales revenues
- sampling
- @RISK
- comparing @RISK and Excel
- creation from distributions
- Excel
- freezing, Excel/VBA
- inverse functions in Excel
- lookup tables in Excel
- Newton-Raphson method
- search methods in Excel
- sequencing, Excel/VBA
- sampling dependencies
- Cholesky factorisation
- copulas
- correlated sampling
- correlation matrices
- definition
- modelling
- time series correlations
- versus parameter dependencies
- Sarbanes-Oxley Act (2002)
- scale, risk assessment
- scatter plots
- scenario analysis
- scenario dependence
- scientific approaches to distribution selection
- second-order autoregressive models
- self-fulfilling rumours
- semi-deviation
- sense checking, @RISK models
- sensitivity analysis
- @RISK
- DataTable macros
- enhancements for risk modelling
- full risk models
- optimisation versus uncertainty
- organisational challenges
- principles
- strategic option development
- sequencing, distribution samples, Excel/VBA
- sequential decisions, presentation as a set
- setting contingencies
- shared accountability
- similarities between modelling and static approaches
- simulation control, @RISK
- simulation control sheets, Excel/VBA
- Simulation Data icon, @RISK
- simulation methods
- analytic methods
- applicability
- @RISK
- auditing and sense checking
- core steps
- distribution/time series fitting
- fixing the seed
- graphs
- macros
- multiple simulations
- optimisation
- results statistics
- running simulations
- sampling
- simulation control
- special applications of distributions
- storing results
- viewing results
- core aspects
- DataTables
- diverse scenarios
- exact solution combinations
- Excel/VBA
- basic results analysis
- core capability generalisation
- core steps
- defining outputs
- examples
- layout optimisation
- loop creation
- multiple output storing
- multiple simulations
- percentile parameters
- practical challenges
- random number sequences
- running
- structure optimisation
- user input at run time
- user-defined distribution samples
- GoalSeek
- iterations needed
- key addressable questions
- macros for model switches
- numerical integration
- optimisation analysis and modelling
- principles
- probability distributions as inputs
- random number usage
- as a risk modelling tool
- scenario analysis
- sensitivity analysis
- see also sampling
- simultaneous occurrences, uncertainties and risks
- sizing risks
- skewness
- slopes, scatter plots
- small samples sizes, non-symmetry
- Smart Sensitivity Analysis, @RISK
- Solver function, Excel
- sources of non-symmetry
- sources of risk
- dependency modelling
- parameters/partial causality
- sampling processes
- time series
- dependency modelling
- Spearman rank correlation
- specific numerical techniques, iterative methods
- speed improvements
- @RISK
- Excel/VBA
- standard deviation
- standard normal distribution
- standardisation, organisational challenges
- standardised risk definitions, prioritisation
- Start Simulation icon, @RISK
- static risk values, aggregation
- static view, @RISK
- statistical distributions
- approximation by alternative distributions
- Bernoulli
- beta/beta general distributions
- binomial
- conceptual selection and use frameworks
- data-driven selection and use frameworks
- dependency measurements
- descriptions
- discrete, continuous and compound processes
- exponential
- extreme value
- F
- fitting, @RISK
- gamma distributions
- general discrete
- geometric
- hypergeometric
- industry standard selection and use frameworks
- inversions
- log logistic
- logistic
- lognormal
- mean
- mean value comparisons
- measures of the central point
- median
- mode
- negative binomial
- non-symmetry
- normal distributions
- parameter matching
- Pareto
- percentiles
- periods-of-occurrence of Bernoulli processes
- PERT distributions
- Poisson
- pragmatic selection and use frameworks
- random sample creation, @RISK
- ranges
- risk measurement
- sample creation
- scientific selection and use frameworks
- selection and use frameworks
- semi-deviation
- skewness
- special applications in @RISK
- standard deviation
- student/t
- tail losses
- triangular
- uniform continuous
- Weibull
- statistical distributions for periods-of-occurrence of Bernoulli processes
- statistical measures
- @RISK
- correlation coefficients
- dependency measurement
- Excel and Visual Basic simulation
- joint occurrence
- kurtosis
- mean
- median
- mode
- non-symmetry
- Pearson correlation
- ranges
- rank correlations
- scatter plots
- semi-deviation
- skewness
- Spearman correlation
- standard deviation
- tail losses
- value-at-risk
- storage
- results
- @RISK
- Excel/VBA
- results
- strategic options, risk assessment
- strategy development
- Stress Analysis, @RISK
- structural biases
- structure optimisation, Excel/VBA
- structures, risk identification
- student (t) distributions
- Summary Trend plots, @RISK
- switches
- macro control
- model design
- symmetric input distributions, output percentile mapping
- syntax, Visual Basic
- t (student) distributions
- tail losses
- target setting
- tau coefficients
- tax charge calculations
- t-copulas
- technical complexity
- “the trap of the most likely”
- third-order autoregressive models
- time series
- autoregressive models
- co-directional processes
- correlation
- development, full models
- fitting, @RISK
- geometric Brownian motion
- Markov chains
- mean-reversion models
- modelling dependencies
- moving average models
- random state switching
- time shifting, partial periods
- timeframes, probability of occurrence
- timing
- model development
- monitoring, Excel/VBA
- risks of delays
- tolerances
- top-down versus bottom-up implementation
- tornado graphs
- traditional models, correlations
- transparency
- “trap of the most likely”
- triangular distributions
- UK combined Code on Corporate Governance
- unaggregated risk registers
- uncertainty
- competitors/market share
- complex dependencies
- definition
- non-symmetry
- simultaneous occurrences
- versus decision effects
- uniform continuous distributions
- uniform continuous ranges, Excel/VBA
- user input at run time, Excel and Visual Basic simulation
- user-defined correlated probability samples, Visual Basic
- user-defined distribution samples, Visual Basic
- user-defined inverse functions, Visual Basic
- user-defined probability samples, Visual Basic
- uses of risk assessment
- uses of simulation methods
- utilising existing models
- validity, correlation matrices
- valuation of derivatives
- value-at-risk (VaR)
- variability
- category-driven
- definition
- distinguishing from decision risks
- fading impacts
- scenario-driven
- variance
- extreme value distributions
- standard deviation
- Vasicek (Ornstein-Uhlenbeck) models
- VBA (Visual Basic for Applications) see Visual Basic
- VBE (Visual Basic Editor) see Visual Basic
- viewing results, @RISK
- Visual Basic
- adding comments
- analysis sheets
- array function creation
- assigning values into Excel
- automatic clearing of Data Filters
- benefits
- Bernoulli distribution sampling
- bespoke random number algorithms
- best practice
- beta/beta general distribution sampling
- binomial distribution sampling
- Cholesky factorisation
- clearing previous results
- code modularisation
- DataTable creation
- distribution samples creation
- editor usage
- freezing distribution samples
- general discrete distribution sampling
- geometric distribution sampling
- inserting code modules
- inverse function creation
- line breaks and indentations
- lognormal distribution sampling
- loop creation
- normal distribution sampling
- output links sheets
- PERT distribution sampling
- Poisson distribution sampling
- random number sequence control
- results sheets
- semi-deviation analysis
- sequencing distribution samples
- simulation control sheets
- simulation modelling
- basic results analysis
- core capability generalisation
- core steps
- examples
- layout optimisation
- multiple output storing
- multiple simulations
- percentile parameters
- random value usage
- running
- structure optimisation
- user input at run time
- switch control macros
- syntax
- triangular distribution sampling
- user-defined functions
- Weibull distribution sampling
- visual representation
- @RISK
- correlation matrices
- Excel/VBA simulation output
- model planning
- random processes
- scatter plots
- tornado graphs
- Weibull distributions
- weighted averages
- weighting factors, static values
- What-If analysis
- Excel
- see also sensitivity analysis
- working effectively with enhanced processes and procedures
- working with existing models
- X-Y charts
- see also scatter plots
- zero skew
- “zombie projects”
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.