Which Excel function will give the p-value for overall significance if a regression has 75 observations and 5 predictors and gives an F test statistic Fcalc = 3.67?
A)=F.INV(.05,5,75)
B)=F.DIST(3.67,4,74)
C)=F.DIST.RT(3.67,5,69)
D)=F.DIST(.05,4,70)

Question

Quizplus · Accepted Answer

To find the p-value for overall significance in a regression with F test statistic Fcalc = 3.67, we need to use the F distribution. We know that there are 5 predictors and 75 observations. Therefore, we use the F.DIST.RT function in Excel to find the p-value. This function gives the right-tailed probability of an F distribution. The syntax is F.DIST.RT(x, degrees_freedom_numerator, degrees_freedom_denominator). In this case, the input values are:
- x = 3.67 (the calculated F test statistic)
- degrees_freedom_numerator = 5 (number of predictors)
- degrees_freedom_denominator = 69 (75 minus the number of predictors minus 1, which is 5)

The correct answer is C) F.DIST.RT(3.67,5,69).

Which Excel Function Will Give the P-Value for Overall Significance