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

question 126

Multiple Choice

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)

---

Definitions:

Useful Life

The estimated span of time during which an asset is expected to be functionally and economically viable for its intended purpose.