Question

Use the given information to find the tabled value for an F variable based on n₁ − 1 numerator degrees of freedom, n₂ − 1 denominator degrees of freedom with an area of a to its right. (Round your answer to two decimal places.)

n₁ = 13, n₂ = 19, a = 0.100

F =

Answer 1

We use following excel command to calculate f value

=F.INV.RT(probability, deg_freedom1, deg_freedom2)

probability: The significance level to use

deg_freedom1: The numerator degrees of freedom

deg_freedom2: The denominator degrees of freedom

For this example,

Probability = 0.100, deg_freedom1= 13-1= 12 , deg_freedom2 = 19-1 = 18

Therefore  F = 1.93334 = 1.93 (round to two decimals)