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:

Depression

An emotional disorder defined by an ongoing feeling of sadness or a disinterest in pursuits, resulting in substantial difficulty in everyday activities.

Crisis

A critical event or point of decision which, if not managed appropriately, can turn into a disaster or catastrophe, often characterized by a temporary state of emotional turmoil or stress.

Patient's Anxiety

A state of unease, such as worry or fear, experienced by a patient typically related to medical procedures or health concerns.

Angry Patient

A healthcare term for a patient displaying feelings of anger or frustration, often arising from or contributing to challenges in the treatment process.