I am making a simple monte carlo model in Excel, using a Data Table to calculate Profit as Revenue minus Costs, where Revenue is assumed to follow a defined normal distribution and Costs, a triangular distribution.
Right now, each of the two random variable cells refers to its own cell containing simply = RAND(). I.e. there are two such cells.
Is this appropriate? Or is it for some reason better to have one global RAND() cell which the different distribution formulas refer to? Does it make any difference? What if I decided to add another 10 stochastic variables?
Grateful for any advice.
Right now, each of the two random variable cells refers to its own cell containing simply = RAND(). I.e. there are two such cells.
Is this appropriate? Or is it for some reason better to have one global RAND() cell which the different distribution formulas refer to? Does it make any difference? What if I decided to add another 10 stochastic variables?
Grateful for any advice.