inverse-transform-method

The inverse transform method is simply a way to create a random variable that is characterized by a SPECIFICALLY desired distribution (it can be any distribution, parametric or empirical). For example, =NORM.S.INV(RAND()) transform a random uniform into a random standard normal. The "inverse"...