The recent blog positing on best practices in Excel modelling could be thought of as providing a reasonable and robust set of principles for building static Excel models. When building simulation models for risk analysis in Excel (for instance, with @RISK Monte Carlo...
This blog briefly posts some fairly standard (but not fully accepted, and more often simply not implemented!) “best practice principles” in Excel modelling. A later blog discusses a related topic as to whether risk modelling (when building Monte Carlo simulation...
This is the second in a series of postings about correlation modelling. In the first posting we discussed the idea of correlation as representing a proxy model of dependency between random variables. In this posting, we discuss the idea the often overlooked concept...
In Part I combining simulation and decision tree techniques was introduced. But what does that actually give you? What meaningful results are created to justify the work? Obviously there are good things to come, or I wouldn’t be bringing it up! A regular spreadsheet...
Quantitatively Optimize Your Negotiation Strategy with Decision Trees In litigation, you often get stuck in inefficient negotiations. Between 95-97% of patent lawsuits settle before trial, but not before amassing an average of more than $2 million in expenses,...