excel solver
optimization
simulation
excel solver, optimization software

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   

Risk Solver - Statistics / Risk Measures


optimization, solver, Excel

 
Home
Register
What's New
Solver Tutorial
Solver Technology
Select a Product
Excel Users
MATLAB Users
Developers
Government Users
Academic Users
Press/Analysts
Privacy Policy
 

 

 
Easily Use a Wide Range of Statistics and Risk Measures

Risk Solver provides a wide range of statistics and risk measures, computed for each output of interest across the trials of a Monte Carlo simulation.  You can use measures of central tendency, measures of variation or dispersion, and quantile measures, to assess almost any output in your model.

bulletMeasures of Central Tendency
bulletMeasures of Variation
bulletRisk Measures
bulletQuantile Measures
bulletConfidence Intervals

Measures of Central Tendency

Risk Solver provides several measures of central tendency:

bulletPsiMean, the average of all the values
bulletPsiPercentile for the median or 50th percentile
bulletPsiMode, the most frequently occurring single value

Measures of Variation

Risk Solver provides several standard measures of variation:

bulletPsiVariance, which describes the spread of the distribution of values
bulletPsiStdDev for standard deviation, the square root of variance
bulletPsiSkewness, which describes the asymmetry of the distribution of values
bulletPsiKurtosis, which describes the peakedness of the distribution of values
bulletPsiMin, PsiMax, and PsiRange for the minimum and maximum values, and the difference between them

Risk Measures

Risk Solver also provides several risk measure functions that are most often used in quantitative finance applications, but may be used in any model:

bulletPsiAbsDev for ‘MAD’, which measures absolute deviations from the mean
bulletPsiSemiVar for semivariance or lower partial moment, which measures and weights negative deviations from the mean
bulletPsiSemiDev for semideviation, the square root of semivariance (qth root for the lower partial moment)

PsiSemiVar and PsiSemiDev are useful in situations where ‘upward’ variation -- for example, higher stock prices or increased profits -- is desirable, but ‘downward’ variation -- lower prices or losses -- is undesirable.

Quantile Measures

To get a complete grasp of the range of outcomes, it’s essential to look at quantile measures, such as percentiles and Value at Risk, in addition to measures of central tendency and variation. Quantile measures allow you to answer questions such as ‘How much money might we lose, with 5% or 10% probability?” or “What is the probability that we’ll make at least $100,000?” based on your simulation model. Risk Solver provides:

bulletPsiPercentile, which provides percentile values from 1% to 99%
bulletPsiTarget, which returns the proportion of values less than or equal to a target value
bulletPsiBVaR, which measures standard (‘Basel’) Value at Risk
bulletPsiCVaR, which measures Conditional Value at Risk

Confidence Intervals

Every Monte Carlo simulation uses a sample of the possible values of your uncertain variables; hence any statistic resulting from the simulation involves some degree of sampling error. For the mean and standard deviation of an output value, Risk Solver provides functions that help you assess this error, and estimate the range or interval in which you can be confident that the true mean or standard deviation lies, at a confidence level that you specify:

bulletPsiMeanCI, which returns a confidence interval for the mean
bulletPsiStdDevCI, which returns a confidence interval for the standard deviation
bulletPsiCITrials, which returns the number of simulation trials needed to obtain a confidence interval of a given size, at a given confidence level

Back to Risk Solver Overview

Risk Solver Capabilities
Ribbon User Interface
Instant Charts of Results
Right-Click Menus
Quick Model Navigation
Define Uncertain Inputs
Define Uncertain Results
Drag and Drop Statistics
Define Correlations
Fit Distributions to Data
Interactive Simulation
Speed of PSI Technology
Simulation Optimization
Probability Management
Certified Distributions
Stochastic Libraries
Sampling / Distributions
Statistics / Risk Measures
Conditional Distributions
Deploying Custom Apps
80 New Excel Functions
VBA Object-Oriented API
Download Free Trial
How to Order Your Copy
Support and Upgrades
Runtime Licensing
   
Our Premium Solver Platform works with existing Excel Solver models, solves much larger problems up to hundreds of times faster, and solves new kinds of problems via Evolutionary Solver.  Solver Engines plug into the Premium Solver Platform.
   
Solver Platform SDK makes it easy to solve any type or size of optimization problem in your Visual Basic, VB.NET, C/C++, C#, Java, or MATLAB program. And it's easy to deploy your application with our flexible licensing for software vendors and corporate developers.
   
spreadsheet solver
scarce resources