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

question 83

Multiple Choice

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)

---

Definitions:

Buying Specialization

A procurement approach where purchasing responsibilities are divided amongst team members based on specific categories of goods or services.

Purchasing Consortium

A group of companies or organizations that join together to pool their purchasing power, aiming to negotiate better terms and prices from suppliers.

Collaborative Purchasing

A strategy where multiple organizations come together to negotiate and buy products or services to achieve cost savings and other buying synergies.

Design Stage

The phase in a project or product development process where the visual aspects, functionalities, and specifications are planned and drafted.