@RISK Helps Keep Endangered Fish
The Devils Hole pupfish (Cyprinodon diabolis) is one of the world’s most endangered animals. There is only one wild population living in a single aquifer-fed thermal pool in Nye County, Nevada, and has been perched on the brink of extinction with a population of only 35 to 68 fish in 2013. A major strategy for conserving the pupfish has been to create additional captive populations, but scientists needed to know how to best extract wild pupfish for breeding purposes without unduly accelerating the extinction risk for the population in Devils Hole. Dr. Steven Beissinger, Professor of Conservation Biology at the University of California, Berkeley, constructed a population variability analysis (PVA) using @RISK to better inform this dilemma.
Dr. Beissinger first created models for extinction risk in the wild for the pupfish, which showed that most simulated populations of the pupfish became extinct within 50 years. Median and mean time to extinction were 26 and 27 years, and 17 and 22 years, respectively. Next, to evaluate the effects of different strategies for removing individuals to initiate a captive breeding program on the wild population, Dr. Beissinger modeled the effects of removing different numbers of individuals (0–14) at the start of each simulated year.
Dr. Beissinger then wanted to answer the question of which life-stage should pupfish be harvested. The model showed that removing pupfish eggs had the least effect on the wild population. Indeed, Dr. Beissinger calculated that removing 25 eggs for captive breeding is equivalent to removing a single adult in terms of its influence on population dynamics.
This modeling work has helped to inform decisions made by the U.S. Fish and Wildlife Service to conserve the Devils Hole pupfish, which has now begun to remove pupfish eggs from Devils Hole to start a captive population in its state-of-the-art breeding facility. “The modeling helped everyone to see what some of the trade-offs would be and made the various outcomes more explicit,” says Dr. Beissinger.
Dr. Beissinger uses @RISK for both research and teaching, and finds it to be a valuable tool: “@RISK makes Monte Carlo processes easy for professionals and students to understand,” he says. “The nice thing about it, from my perspective, is that it functions within Excel, which makes visualizing the information a lot easier and more intuitive for people. It makes what would otherwise be a lot of tedious steps a lot easier to do.”
» Read the full case study
There are three easy ways to get the DecisionTools Suite for your students:
Course Licenses available from Palisade. These are economical, annually renewing bulk licenses for both
network lab and laptop installation. Palisade offers a complimentary Live Web Training session to all instructors who order a Course License.
» Learn more
Student Versions from Palisade. These are 12-month versions available for purchase individually by students through either the Palisade web site or the school store.
» Learn more
Textbook Editions available bundled with textbooks.
These are time- and model-limited licenses.
» Learn more
Get DecisionTools Suite 6 for your course by contacting:
Palisade Academic Sales
800-432-7475 / 607-277-8000
The DecisionTools Suite is a great way to present quantitative techniques in a straightforward, easy-to-understand way for students.
Excerpted from Evolver Solutions for Business,
by Roy L. Nersesian, published by Palisade Corporation
Suppose that you are responsible for production planning at a plant whose product line shows enormous variations in sales. The two key operating questions facing you are what inventory level should trigger a production run and how many should be produced. This example uses Evolver to evaluate two different situations. The first is when an order is placed once the inventory numbers reach a certain trigger point and the other is when there is one order per shipping cycle. RiskOptimizer could also be used for these same two situations. The output under Evolver is discrete whereas the output under RiskOptimizer, while also discrete, is based on probability distributions of costs and stockouts.
» Learn more and download the associated example files
Combining Inputs in a Sensitivity Tornado
Q: How can I aggregate multiple inputs in the tornado graph, so that I see the output's sensitivity to the combination instead of sensitivities to the individual inputs?
If you would like to maybe combine countries in a region, or maybe you want an NPV instead of individual cash flows, or some other situation where you would like to see a combination of sensitities, the RiskMakeInput( ) is the function that will help you do just that. If you already have a formula in your workbook that computes the aggregate you're interested in, just wrap it in a RiskMakeInput( ), like this:
=RiskMakeInput(formula, RiskName("name to appear in tornado") )
As an alternative, you could just create that formula in an empty cell.
RiskMakeInput( ) tells @RISK that its contents should be treated as an @RISK input distribution for purposes of sensitivity analysis, and RiskMakeInput( )'s precedents should be ignored in sensitivity analysis.
» Read the complete answer here
» View other Techniques and Tips here
Estimation of Mixed Traffic Densities in Congested Roads Using Monte Carlo Analysis
by Brian Freeman, Bahram Gharabaghi, and Jesse Thé, EM Magazine, April 2015
The authors use @RISK to create a novel stochastic Monte Carlo method to estimate the number and type of vehicles on a 1-km stretch congested roadway. This technique can then be linked to vehicle emission data to estimate real-time mobile source pollution on roadways due to traffic conditions. The resulting graphs of the @RISK model yielded a power curve that approximates the expected number of cars at each speed, thus giving researchers a fast, convenient tool for better understanding and estimating vehicle numbers in traffic. For Freeman, the benefit of using @RISK for this research was its efficiency. “You can quickly create a model in Excel that would otherwise require a very complicated statistical tool package to set up,” he says. “You can easily create your model without having to become an expert in statistics.”
» Read the full article here
The Academic Global Leader in
Risk and Decision Analysis
Palisade Corporation is the world's leading provider of risk and decision analysis software and solutions. Founded in 1984, its products @RISK and the DecisionTools Suite are used by over 95% of the Fortune 100, in nearly every industry around the world. Palisade is headquartered in New York State, and has offices in London, Sydney, Rio de Janeiro, and Tokyo.
What is The DecisionTools Suite?
The DecisionTools Suite is the world’s only integrated set of risk and decision analysis programs. The Suite includes @RISK for Monte Carlo simulation, PrecisionTree for decision trees, and TopRank for “what if” sensitivity analysis. In addition, DecisionTools Suite comes with StatTools for statistical analysis and forecasting, NeuralTools for predictive neural networks, and Evolver and RISKOptimizer for optimization. All programs work together seamlessly, and all integrate completely with Microsoft Excel for ease of use and maximum flexibility.
The Suite is offered in three affordable and flexible licensing options for those in academia: Student Versions, Course Licenses and Full Academic Versions.
» Schools using Palisade software
» Textbooks using Palisade software
» @RISK Helps Keep
» Licensing Options
» Teaching Tips &
» Tech Tip
Combining Inputs in a
» Featured White Paper
Estimation of Mixed Traffic
Densities in Congested Roads
Using Monte Carlo Analysis
» About Palisade and the
Click to chat live with
a sales representative
An intensive day of networking, software training presented by Palisade trainers and consultants, and real-world case studies presented by industry experts. Join us at an event near you. More dates to come for 2015.
» Rio de Janeiro:
EMEA & India
» New York:
» San Francisco:
» New Orleans:
Adelaide: 29-30 June
Brisbane: 14-15 July
Melbourne: 29-30 July
Perth: 18-19 August
Sydney: 1-3 September
London: 14-16 July
London: 15-17 September
Amsterdam: 6-8 October
London: 27-29 October
21 al 23 de julio
San José, Costa Rica:
11 al 13 de agosto
8 al 10 de septiembre
23 al 25 de septiembre
Houston, TX: 23-25 June
Denver, CO: 4-6 August
Ithaca, NY: 5-6 August
Cincinnati, OH: 11-13 August
Dallas, TX: 22-24 September
» Trade Shows
Society of Petroleum Engineers / ATCE 2015
EMEA & India
27th European Conference on Operational Research
University of Strathclyde, Glasgow
» Live Web Training
Decision-Making & Quantitative Risk Analysis
using the DecisionTools Suite
18-19 June, 11am - 3pm ET
1-2 July, 11am - 3pm ET
Project Risk Assessment using @RISK
Decision-Making and Quantitative Risk Analysis using @RISK
2-3 Sept, 11am - 3pm ET
23-24 Sept, 11am - 3pm ET
Palisade software is available in fully functional trial versions. Try @RISK or any of our software today!
The complete risk and
decision analysis toolkit
The world's most widely
used risk analysis tool
» @RISK for Excel
» For Project Management
» For Six Sigma
Visual decision analysis
Sophisticated neural networks for spreadsheets
Advanced statistical analysis for spreadsheets
The Innovative Optimizer
Intel and the Intel logo are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
|©2015 Palisade Corporation, visit www.palisade.com
798 Cascadilla Street, Ithaca, NY 14850 USA, +1 607 277 8000 firstname.lastname@example.org
Av. Presidente Vargas 435, Sala 501, Centro, Rio de Janeiro CEP 20071-001, +55 (21) 2586-6334 email@example.com
Palisade Europe UK Ltd
31 The Green, West Drayton, Middlesex, UB7 7PN, UK, +44 1895 425050 firstname.lastname@example.org
Palisade Asia-Pacific Pty Limited
Suite 404, L4, 20 Loftus Street, Sydney NSW 2000 Australia, +61 2 9252 5922 email@example.com
Palisade Asia-Pacific, Tokyo Office
〒 150-8512 東京都渋谷区桜丘町 26-1 セルリアンタワー15F 電話 03-5456-5287