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)

Question

Quizplus · Accepted Answer

The function F.INV(α,df1,df2) gives the critical value for a left-tailed F test to compare two sample variances. The parameters df1 and df2 are the degrees of freedom for the numerator and denominator, respectively, and α is the significance level.

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