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
1

I think you want:

=NORMINV(RAND(),0,1)

for a standard normal distribution:

enter image description here

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.