Which Excel function will give the pvalue for overall signif

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 F_calc = 3.67?

	=F.INV(.05, 5, 75)
	=F.DIST(.05, 4, 70)
	=F.DIST(3.67, 4, 74)
	=F.DIST.RT(3.67, 5, 69)

5 predictors: DF1 = 5

Total DF=75-1=74

DF2= 74-5=69

calculated F value =3.67

Answer: F.DIST.RT(3.67, 5, 69)

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

Which Excel function will give the pvalue for overall signif

Solution

Get Help Now

Submit a Take Down Notice