Question

What function would generate a random value from a Normal distribution with mean 50 and standard deviation 5

Answer 1

NORMDIST(RAND(),50,5)

Explanation:

NORMDIST(RAND(),50,5) returns the random value from a normal distribution. The second space is meant for Mean and the third space is meant for standard deviation.