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