VBA Monte Carlo risk analysis spreadsheet with correlation using the Iman-Conover method. Part 2

Welcome back! This is number two in a series of five blog posts that describe how to construct a Monte Carlo risk analysis application in Excel VBA. It follows on from yesterday’s, where I gave an overview of the problem and how I propose to tackle it. Today‚Äôs post describes how to generate random numbers according to arbitrarily chosen probability distributions using the inverse transform method. Read more