For a given mean and standard deviation, the __________ function in Excel is used to generate a value for the random variable characterized by a normal distribution.
A)NORM.INV
B)RAND
C)VLOOKUP
D)FREQUENCY

Question

Quizplus · Accepted Answer

The NORM.INV function in Excel is used to generate a value for a random variable characterized by a normal distribution, given its mean and standard deviation. The RAND function, on the other hand, generates a random value between 0 and 1. VLOOKUP is used to retrieve specific data from a table, and FREQUENCY is used to calculate the frequency distribution of a set of data.

For a Given Mean and Standard Deviation, the __________ Function