excel solver
optimization
simulation
global optimization, multistart methods

   solver.com

Frontline Systems, Inc.  

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

Risk Solver Engine - Sampling Methods and Distribution Functions


clustering methods, multi-level single linkage

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

 

 

Sampling Methods

Risk Solver Engine can generate Monte Carlo samples from a wide range of probability distributions, using any of three methods:

bulletStandard Monte Carlo
bulletLatin Hypercube
bulletSobol Numbers

Sobol numbers are an innovation in Risk Solver Engine that's not found in other software for Monte Carlo simulation.  They are widely used by developers in quantitative finance.  For low to moderate dimensional problems, Sobol numbers offer the "best of both worlds" -- the speed of Standard Monte Carlo with the "coverage" of Latin Hypercube sampling.

Risk Solver Engine provides both a complete set of analytic probability distributions, and a complete set of methods for defining custom distributions, both discrete and continuous, by supplying sample data or by specifying certain parameters.  And you can specify shifting and truncation to customize your probability distributions.

Continuous Analytic Distributions

PsiBeta PsiLaplace PsiPareto2
PsiBetaGen PsiLogistic PsiPearson5
PsiBetaSubj PsiLogLogistic PsiPearson6
PsiCauchy PsiLogNormal PsiPert
PsiChiSquare PsiLogNorm2 PsiRayleigh
PsiErf PsiMaxExtreme PsiStudent
PsiErlang PsiMinExtreme PsiTriangGen
PsiExponential PsiMyerson PsiTriangular
PsiGamma PsiNormal PsiUniform
PsiInvNormal PsiPareto PsiWeibull

Discrete Analytic Distributions

PsiBernoulli PsiHyperCeo PsiNegBinomial
PsiBinomial PsiIntUniform PsiPoisson
PsiGeometric PsiLogarithmic  

Custom and Special Distributions

PsiCumul PsiHistogram PsiShuffle
PsiDiscrete PsiMVLogNormal PsiSip
PsiDisUniform PsiMVNormal PsiSlurp
PsiGeneral PsiResample PsiCertified

If you are programming in Excel VBA, you can easily create an instance of a Distribution object, with the properties of any of these probability distributions.  By simply accessing properties of this object, you can obtain the probability density (PDF) or cumulative density (CDF) function, or analytic values for the moments of the distribution, based on its type and parameters.

Back to Risk Solver Engine Product Overview

Risk Solver Capabilities
What's New in Version 8.0
Interactive Simulation
Vectorized Evaluation
Probability Management
Certified Distributions
Stochastic Libraries
Simulation Optimization
Sampling/Distributions
Statistics/Risk Measures
Correlating Distributions
Object-Oriented API
Download Free Trial
How to Order Your Copy
Support and Upgrades
Runtime Licensing
To Learn More:
For instant access to example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, you can register now.
User Type
Email Address
Name First Last
Company University
Phone

Trial version passwords are sent to the above email address: See Privacy Policy.
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.
  convergence in probability, GRG Solver   optimization software, excel solver dll downloads
spreadsheet solver
scarce resources