3
The randn
function of Matlab generates a random number from the standard normal distribution.
What is the equivalent in Excel?
I think the rand(2)-1
is not the right solution because the random number is uniformly generated, not following the standard normal distribution.
1
see: https://stackoverflow.com/questions/6241784/produce-random-numbers-with-specific-distribution-with-excel
– Scott Craner – 2018-06-25T17:47:03.700