Which is the correct Excel formula for the 80th percentile of a distribution that is N(475,33)?
A)= NORM.DIST(80,475,33,1)
B)= NORM.INV(0.80,475,33)
C)= NORM.S.INV((80 − 475)/33)

Question

Quizplus · Accepted Answer

The NORM.INV function is used to calculate the inverse of the cumulative normal distribution for a given probability (in this case, 0.80) with a specified mean (475) and standard deviation (33). This will give us the value that corresponds to the 80th percentile of the distribution.

Which Is the Correct Excel Formula for the 80th Percentile