Which Excel function finds the value X such that 55% of the probability lies below X from a normal distribution with mean $\mu$= 20 and standard deviation $\sigma$= 3?
A)NORMDIST(.55,20,3,TRUE)
B)NORMSDIST(.55,20,3)
C)NORMINV(.55,20,3)
D)NORMSINV(.55,20,3)

Question

Quizplus · Accepted Answer

NORMINV function in Excel is used to find the value of X such that a given percentage of the probability lies below that value from a normal distribution with a known mean and standard deviation. In this case, the function would be =NORMINV(0.55, 20, 3), which gives the value of X as 21.26 (rounded to two decimal places).

Which Excel Function Finds the Value X Such That 55 μ\muμ

Which Excel Function Finds the Value X Such That 55 $\mu$