Which Excel Function Would Give the Critical Value for a Left-Tailed

question 14

Multiple Choice

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

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

---

Definitions:

Cash Payback Period

The time it takes for an investment to generate cash flow sufficient to recover its initial cost.

Net Income

The total profit of a company after all expenses, including taxes and operating expenses, have been subtracted from total revenue.

Net Present Value

A method used in capital budgeting to assess the profitability of an investment by calculating the present value of expected cash flows minus the initial investment cost.

Average Rate of Return

A metric used to evaluate the profitability of an investment, calculated by dividing the average annual profit by the initial investment cost.