What is the Excel equivalent of Matlab's randn function

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 Answer

I think you want:

=NORMINV(RAND(),0,1)

for a standard normal distribution:

In the above example all the cells in column A were filled. The mean is not exactly zero nor is the S.D. exactly one because they represent the values for this specific sample.