View online at

Palisade Corporation

In This Issue

What’s New
» 88% of Monte Carlo Actuaries Use @RISK
» Boeing to Use Monte Carlo Simulation for TSA
» Monte Carlo Aids Mutual Funds

Case Study
» @RISK Used for Cash Cropping

Product Spotlight
» DecisionTools and Training: Save $395

Software Applications
in the Press

» Business Process

» Cancer Diagnosis
» Climate Change
» Consumer Behavior
» Credit and Debit Fraud

» Derivatives Analysis
» Food Flavoring
» Gaming
» Gas Exploration
» Insurance Fraud
» Investment Decision-making
» Obstetrics
» Stock Pricing
» Supply Chain Optimization
» Water System Management

Ask Amy Tech Tips
» Using @RISK with PrecisionTree

2007 Palisade User Conferences
» Asia-Pacific
13-14 September
Sydney, AU
» North America
25-26 October
Miami Beach, USA
» Latinoamérica
el 26 y el 27 de noviembre
San José, Costa Rica
» Europe
2008 dates TBA

Live chat Click
to chat live
with a sales

Regional Seminars
» North America
Seattle, WA: 26-27 June
Boston, MA: 10-11 July
San Francisco, CA: 24-25 July
Calgary, AB: 14-15 Aug
Philadelphia, PA: 28-29 Aug
St. Louis, MO: 11-12 Sept
Chicago, IL: 18-19 Sept
Toronto, ON: 27-28 Sept

» Europe
Munich (auf deutsch): 28 June
London: 11-12 July
London: 31 July
Frankfurt (auf deutsch): 13 Sept

» Latinoamérica
Santiago, Chile (en español):
  del 18 al 20 de junio
Bogotá, Colombia (en
  español): del 9 al 11 de julio

» Asia-Pacific
Sydney: 20 June
Sydney: 21-22 June
Wellington: 5-6 July
Perth: 19-20 July
Singapore: 23-24 July
Brisbane: 2-3 August

Live Web Training
» Risk and Decision Assessment Training using @RISK, Part I
18-19 June, 1-5pm ET
16-17 July, 1-5pm ET
6-7 August, 1-5pm ET
10-11 September, 1-5pm ET

» Risk and Decision Assessment Training using @RISK, Part II
21-22 June, 1-5pm ET
19-20 July, 1-5pm ET
9-10 August, 1-5pm ET
13-14 September, 1-5pm ET

» Improving Estimates and Budgets
19 June, 10am-1pm GMT
17 July, 10am-1pm GMT
14 August, 10am-1pm GMT

Free Webcasts
Case Study
» Using Bayesian Networks within an @RISK Monte Carlo Simulation Environment for Project Management
14 June
10-11am ET / 3-4pm GMT

Case Study
» Making $ense of Baseball: An Economic Approach
2 August
11am-12pm ET / 4-5pm GMT

Trade Shows
» North America
Joint Statistical Meeting (JSM) 2007
29 July - 2 August 2007
Salt Lake City, UT

PMI Global Congress 2007 – North America
6-9 October 2007
Atlanta, GA
Booth #711

Society of Actuaries Annual Meeting and Exhibit
14-17 October 2007
Washington, D.C.
Booth #506

INFORMS Annual Meeting 2007
4-7 November 2007
Seattle, WA

SPE Annual Technical Conference and Exhibition - 2007
11-14 November 2007
Anaheim, CA

38th Annual Meeting of the Decision Sciences Institute - DSI 2007
17-20 November 2007
Phoenix, AZ

» Europe
2-3 July 2007

IRM Risk Forum
11-13 September 2007
Conference Hertfordshire, Hatfield, UK

30 Sept - 3 Oct 2007

17-18 October 2007

Free Trial Versions
Palisade software is available in fully functional free trial versions. Try @RISK or any of our software today!

The DecisionTools Suite
The complete risk and decision analysis toolkit

The world's most widely used risk analysis tool
» @RISK for Excel
@RISK» @RISK for Project

Visual decision analysis for spreadsheets

Sophisticated neural networks for spreadsheets

Advanced statistical analysis for spreadsheets

Optimization with simulation for spreadsheets

The DecisionTools Suite

88% of Actuaries Running
Monte Carlo Choose @RISK
A recent independent survey of actuaries across North America and Europe revealed that, when Monte Carlo simulation is needed, 88% of them select @RISK. Furthermore, nearly half of all actuaries surveyed use @RISK. @RISK is used in all areas of work, including the top two applications of premium pricing and estimating loss reserves. But it is considered “vitally important,” according to the survey, for capital management, as well as for catastrophe modeling.

The survey, entitled “Actuaries excel: but what about their software?” was presented by independent consultant Louise Pryor at the 2006 General Insurance Convention in Vienna, Austria, on 26 September 2006.

“We have long had a strong customer base in the actuarial and insurance market,” said Palisade President Sam McLafferty. “This latest survey confirms the trends we have been seeing. Through meetings like the Society of Actuaries, coverage in a variety of insurance and actuarial publications, as well as sales, we have seen dramatic expansion of @RISK for actuarial applications.”

Read the full survey (PDF)
» Read case studies using @RISK for insurance
» Read more about @RISK

Boeing to Build
Monte Carlo Simulation to
Weigh Air Transportation Risks
Source:, June 4, 2007
The Transportation Security Administration is looking to a computer-dependent design method used in airframe manufacturing as a template for evaluating air travel risks. TSA, a Homeland Security Department agency, has recently announced plans to enter into a no-fee agreement with Boeing, under which the company would build a Risk Management Assessment Tool, or RMAT, for the commercial aviation system using what’s known as the Monte Carlo model. TSA said Boeing would use its Monte Carlo simulation model “to identify U.S. commercial aviation system vulnerabilities against a wide variety of attack scenarios.”

Read the full story

Monte Carlo Simulation May Help Increase Mutual Fund Return
Source:, June 8, 2007
The average mutual fund in the U.S. holds 161 stocks, compared with 105 in the U.K. and 88 for a Europe-wide one, according to Chicago-based Morningstar Inc.

“The idea that you need 160 or 88 stocks to diversify is simply ludicrous,” says James Montier, head of global equity strategy at Dresdner Kleinwort Group Ltd. in London. “You can have a return profile with roughly the same volatility as the overall equity market by holding around 30 to 40 stocks.”

As a result, investors may be paying exorbitant fees for lackluster returns. According to Montier, using Monte Carlo simulation can allow fund managers to concentrate on absolute returns, instead of buying a variety of unwanted stocks in an attempt to mimic benchmark results.

» Read the full story

Case Study

@RISK Used for Large-Scale
Cash Cropping
With the advent of corporate farming, large agricultural companies have begun to apply the same kinds of risk analysis techniques to the powerful uncertainties of the natural world and market prices that their counterparts in the manufacturing and finance sectors use. Prof. Ariadna Berger, professor of Farm Management at the University of Buenos Aires, has introduced @RISK and a portfolio approach to assessing and balancing the risks and opportunities of large cash cropping operations in Argentina.

» Read the full case study
» Submit a case study

Product Spotlight

DecisionTools and Training:
Save $395!
Did you know that @RISK and the DecisionTools Suite are available with a 2-day training seminar for a special bundle price? You can purchase @RISK Professional for Excel and 2-day training seminar for $2250 — saving $240. Or, you can purchase DecisionTools Suite Professional with a 2-day seminar for $2895 — saving $395. Attending training is the single best way to get the most from your software investment. Armed with DecisionTools software and a little know-how, one good decision can more than pay for your purchase. These bundles are good for single copies of software only.

“The course was useful and the presenter was knowledgeable. There was a good mix of background material and working through actual problems.” — Marvin Schwedock, General Atomics

Call 800 432 RISK

» View the training schedule
Trade Shows »
Learn about the DecisionTools Suite

100% Excel
@RISK simulations are calculated 100% within Excel, supported by Palisade sampling and statistics proven in over twenty years of use.
Palisade does not attempt to rewrite Excel in an external recalculator to gain speed.
A single recalculation from an unsupported or poorly reproduced macro or function can dramatically change your results.
Where will it occur, and when? Palisade harnesses the power
of multiple CPUs and multi-core processors to give you the fastest calculations. Correct results—and fast—using @RISK!

Palisade Software Techniques in the News

Business Process Outsourcing

» BPO scales a new peak with version 3.0
Technique: Monte Carlo simulation  » see @RISK
Source: Economic Times, May 16, 2007

Move over night-long slogs on mundane outsourcing jobs. The $9-billion business process outsourcing (BPO) sector has graduated to the third generation services, or BPO Ver 3.0. Sample the work in BPO 3.0: developing structured products for investment banks, using Monte Carlo simulation based patent valuation, and more.

Cancer Diagnosis

» A close-up on pancreatic disease:
How do we improve the odds?

Technique: Neural networks  » see NeuralTools
Source: American Gastroenterological Association,
May 22, 2007

Pancreatic cancer is among the deadliest of today's cancers due to limited tools for early diagnosis and few effective treatments. Research takes a closer look at pancreatic cancer and the promising new applications of technology that will improve survival rates in the coming years. Overall, the neural network based model was very accurate in classifying pancreatic cancer, with an area under ROC curve of 0.93.

Climate Change

» Think global, calculate local
Technique: Monte Carlo simulation  » see @RISK
Source: The Guardian, April 19, 2007

Some climate change models will produce heavy rain over a region while in others the same location will be bone dry. There are now an increasing number of regional model simulations to compare. Recent projects apply the Monte Carlo technique to refine their probability distributions, with the stated goal of producing “a probabilistic estimate of uncertainty in future climate.”

Consumer Behavior

» Netflix prize still awaits a movie seer
Technique: Neural networks  » see NeuralTools
Source: The New York Times, June 4, 2007

Last October, Netflix announced that it would award $1 million to the first person or team who can devise a system that is 10 percent more accurate than the company’s current system for recommending movies that customers would like. Systems using machine learning, neural networks, and other techniques were submitted. And the improvement level to Netflix’s rating system is now at 7.42 percent.

Credit and Debit Card
Fraud Detection

» Analytic Innovations LLC's CEO and VP of
Fraud Risk Analysis to air in live MN1 interview

Technique: Neural networks  » see NeuralTools
Source: Marketwire, May 16, 2007

The executives will discuss the company's findings across concrete areas where significant debit fraud risk and loss can be mitigated and managed: purchase-limit evaluation, cardholder behavior analysis after a fraud-related card reissue, and neural network review and evaluation.

Derivatives Analysis

» A new engine for financial analysis
Technique: Monte Carlo simulation  » see @RISK
Source:, May 25, 2007

The numerical method for derivatives analysis uses Monte Carlo simulations in a Black-Scholes world. The algorithm makes heavy usage of floating-point math operations such as logarithm, exponent, square-root, and division. In addition, these computations must be repeated over millions of iterations. The numerical Black-Scholes solution is typically used within a Monte Carlo simulation, where the value of a derivative is estimated by computing the expected value, or average, of the values from a large number different scenarios, each represents a different market condition.

Food Flavoring

» Make available e-nose to tea industry
Technique: Neural networks  » see NeuralTools
Source: The Hindu, June 1 , 2007

The United Planters' Association of Southern India (UPASI) has urged the Tea Board and National Tea Research Foundation (NTRF) to make available tea quality monitoring instrument “E-nose” to the industry at the earliest. The system is capable of sensing volatile compounds of tea and reliably predicting tea taster like scores with a high degree of accuracy. Neural Network based 'soft computing techniques' are used to tune near accurate co-relation smell print of multi-sensor array with that of the Tea Tasters' scores.


» Poker bots learn to bluff
Technique: Neural networks  » see NeuralTools
Source: Wired, May 30, 2007

Poker-playing software programs are great at calculating odds and keeping, so to speak, a straight face. But the bluff -- that highest art of the game, the ability to intuit when and how to successfully play a low pair like a full house -- has always been beyond the grasp of their code. All that may have changed. Based on a neural network algorithm typically used to predict the stock market, Hurwitz's bots weren't pre-programmed with the rules of a card game.

Gas Exploration

» Riverdale Oil and Gas Corp. announces its natural gas development program in the Gulf Coast region of Texas
Technique: Neural networks  » see NeuralTools
Source: Marketwire, May 22, 2007

Riverdale Oil and Gas Corp announced a natural gas program to develop reserves trapped in the shallow Frio and Miocene sands of the gulf coast of Texas. The Company is in final negotiations with Nettlecombe Oil Co., Inc., a geophysical consulting company located in Houston, Texas. Nettlecombe will utilize Neural Networks and Artificial Intelligence, which are powerful extensions to its 3D seismic analysis.

Insurance Fraud

» Insurance companies not reaping full
benefits of fraud tech, Celent report says

Technique: Neural networks  » see NeuralTools
Source: TechWeb, May 17, 2007

Many insurance companies aren't taking full advantage of technology when it comes to fighting fraud, suggests a recently released report from Boston-based research and advisory firm Celent. Several newer techniques — including neural networks — have gone underutilized. Insurance lags behind the credit card and banking industries regarding fraud technology adoption.

Investment Decision-Making

» Minimize your investment losses
Technique: Decision trees  » see PrecisionTree
Source: The Motley Fool, May 15, 2007

Decision trees, decision trees, decision trees. I believe one of the biggest errors (myself included) that investors make is attributing results to decisions, rather than to decision trees.


» Decision aid tool could cut the number
of Caesarean sections by 4000 a year

Technique: Decision analysis/decision trees
see DecisionTools Suite
Source: British Medical Journal, May 31, 2007

A computerized decision analysis program which helps women decide on the type of birth that is most appropriate for them could cut the number of caesarean sections performed in England and Wales by 4000 a year, according to a study published today.

Stock Pricing

» Citigroup increases price target on Dow Jones
Technique: Decision trees  » see PrecisionTree
Source:, May 24, 2007

Citigroup increases price target on Dow Jones & Company Inc (NYSE: DJ) to $55. Citigroup analyst says, “Our price target is $55 (prev. $37) and is based on a decision-tree analysis of potential outcomes.”

Supply Chain Optimization

» Supply chain optimization versus simulation
Technique: Monte Carlo simulation and optimization
see RISKOptimizer
Source: Supply Chain Digest, May 31, 2007

There is renewed interest in supply chain “simulation” at multiple levels; and new concepts (for the supply chain) that straddle optimization and simulation approaches, such as “stochastic optimization.” The key is that demand (or other key inputs) aren’t static, but are more dynamic. It is possible to use techniques such as “Monte Carlo” analysis to have demand or other variable populated more or less randomly over some period.

Water System Management

» Genetic algorithms in municipal water systems
Technique: Genetic algorithm optimization  » see Evolver
Source: WaterWorld, May 18, 2007

Tap water has been taken for granted as a daily resource for many people, but it may not be well known that genetic algorithm optimization has been playing an important role in managing and operating municipal drinking water systems by means of hydraulic and water quality models.


Ask Amy Tech Support

Expert Answers to Technical Questions

Dear Amy,

Can I represent uncertain factors in my PrecisionTree models using @RISK? For instance, I have chance nodes and payoff nodes that are really continuous ranges of outcomes.


Dear W.P.,

@RISK is a perfect companion to PrecisionTree. @RISK allows you to 1) quantify the uncertainty that exists in the values and probabilities which define your decision trees, and 2) more accurately describe chance events as a continuous range of possible outcomes. Using this information, @RISK performs a Monte Carlo simulation on your decision tree, analyzing every possible outcome and graphically illustrating the risks you face.

With @RISK, all uncertain values and probabilities for branches in your decision trees and supporting spreadsheet models can be defined with distribution functions. When a branch from a decision or chance node has an uncertain value, for example, this value can be described by an @RISK distribution function. During a normal decision analysis, the expected value of the distribution function will be used as the value for the branch. The expected value for a path in the tree will be calculated using this value.

However, when a simulation is run using @RISK, a sample will be drawn from each distribution function during each iteration of the simulation. The value of the decision tree and its nodes will then be recalculated using the new set of samples and the results recorded by @RISK. A range of possible values will then be displayed for the decision tree. Instead of seeing a risk profile with a discrete set of possible outcomes and probabilities, a continuous distribution of possible outcomes is generated by @RISK. You can see the chance of any result occurring.

In decision trees, chance events must be described in terms of discrete outcomes (a chance node with a finite number of outcome branches). But, in real life, many uncertain events are continuous, meaning that any value between a minima and maxima can occur.

Using @RISK with PrecisionTree makes modeling continuous events easier using distribution functions. And, @RISK functions can make your decision tree smaller and easier to understand!

Live Chat Visit
E-mail comments or suggestions to:
2007 Palisade Corporation, 798 Cascadilla Street, Ithaca, NY 14850 USA