Which is the correct Excel formula for the 80^th 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 correct Excel formula for finding the percentile of a normal distribution is NORM.INV. The first parameter for this function is the desired percentile (0.80 for the 80th percentile). The second and third parameters are the mean (475) and standard deviation (33) of the normal distribution. Therefore, the correct Excel formula is NORM.INV(0.80,475,33).

Which Is the Correct Excel Formula for the 80th Percentile

Which Is the Correct Excel Formula for the 80^th Percentile