One hundred monkeys are typing in Excel spreadsheets when one of them enters =NORM.S.INV(RAND()) What is the result of this monkey's function?
A) the number zero
B) random numbers evenly distributed from 0 to 1 inclusive
C) probabilities of the normal distribution function
D) z-scores from the standard normal distribution

Question

Quizplus · Accepted Answer

The function =NORM.S.INV(RAND()) returns z-scores from the standard normal distribution. The RAND() function generates a random number uniformly distributed between 0 and 1, and then the NORM.S.INV() function returns the corresponding z-score for that random number. The monkey's function generates a random sample from the standard normal distribution.

One Hundred Monkeys Are Typing in Excel Spreadsheets When One