Which Excel function gives the right-tail p-value for an ANOVA test with a test statistic Fcalc = 4.52,n = 29 observations,and c = 4 groups?
A)=F.DIST.RT(4.52,3,25)
B)=F.INV(4.52,4,28)
C)=F.DIST(4.52,4,28)
D)=F.INV(4.52,3,25)

Question

Quizplus · Accepted Answer

The F.DIST.RT function in Excel gives the right-tail p-value for an F-distribution. In this case, we input the test statistic Fcalc = 4.52, the degrees of freedom for the numerator (c - 1 = 4 - 1 = 3), and the degrees of freedom for the denominator (n - c = 29 - 4 = 25). Therefore, the correct function to use is F.DIST.RT(4.52,3,25).

Which Excel Function Gives the Right-Tail P-Value for an ANOVA