Which is the Excel function to find the critical value of F for α = .05,df1 = 3,df2 = 25?
A)=F.DIST(.05,2,24)
B)=F.INV.RT(.05,3,25)
C)=F.DIST(.05,3,25)
D)=F.INV(.05,2,24)

Question

Quizplus · Accepted Answer

The function to find the critical value of F for a given significance level α and degrees of freedom df1 and df2 is F.INV.RT(α, df1, df2) or F.INV(α, df1, df2). In this case, the correct function to use is F.INV.RT(.05, 3, 25) as we are given α = .05, df1 = 3, and df2 = 25. Therefore, the answer is B.

Which Is the Excel Function to Find the Critical Value