Question

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?

Answer 1

Answer:

The excel function that will gibe the p-valur for overall significance of a regression has 75 observations and 5 predictors and gives an F test statistic FCal = 3.67 is given below:

F.DIST.RT(3.67,5.69)