I need some help on part E. I'm not sure how to get the p-value for this hypothesis test, and unless I'm confused, I don't believe there is anyway to get it out of the regression option in Excel's analysis toolpak.
The only other way I see to use in Excel for calculating p-values needs the t-value as an input. It is TDIST(t-statistic, degrees of freedom, number of tails).
Using the formula at the bottom of page 109, F0= {(RegSS1 - RegSS0)/q}/{RSS1/(n-k-1)}, I calculated F0=33.29.
I see in the solution to practice problem 1.2 from "Module 12: Statistical Inference for Multiple Linear Regression" that "in the two-variable regression model, the t statistic is the square root of the F ratio." I therefore concluded that the t-statistic = +- the square root of 33.29 = +-5.7697. I calculated the degrees of freedom as n-k-1 = 16-2-1=13. I then computed the p-value by typing TDIST = (5.7697, 13, 2) in excel : .0001.
Did I approach the problem correctly? Also, why does excel give me an error when I attempt to enter the negative t-statistic (TDIST = (-5.7697, 13, 2))?
[NEAS: What you did is correct for one explanatory variable. It is simpler to use the regression add-in, which give p-values for coefficients and for F statistics. You need the regression add-in to easily do multiple regression for the student project. Click on the Tools menu, then data analysis, then regression.]