Which Is the Correct Excel Formula for the 80th Percentile

question 41

Multiple Choice

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)

---

Definitions:

Enumeration

A user-defined data type in programming that consists of a set of named integer constants.

Integer Value

A data type that represents whole numbers without fractional parts, used in programming languages for calculations and operations.

Conditional Operator

A ternary operator in C and C++ (?:) that selects one of two expressions to evaluate, based on a third expression being true or false.

Assignment Operator

An operator in programming languages used to assign a value to a variable, typically denoted by an equal sign (=).