Which Excel Function Would Give a P-Value for a Left-Tailed

question 54

Multiple Choice

Which Excel function would give a p-value for a left-tailed F test to compare two sample variances?

• A)=1−F.DIST(s12/s22,df1,df2)
• B)=F.INV(α,df1,df2)
• C)=F.DIST(s12/s22,df1,df2)
• D)=F.INV(α/2,df1,df2)

---

Definitions:

Secret Antiperspirant

A branded personal care product designed to prevent perspiration and body odor.

Derived Demand

Demand for a product or service that arises from the demand for another product or service.

Business Product

A good or service sold to organizations for the specific purpose of resale, use in producing other goods, or use in general business operations.

Consumer Product

Goods bought by individuals for personal or household use.