ANOVA and regression problem set

A) Explain why a confidence interval for the slope or intercept would be equivalent to a two-tailed hypothesis test. (b) Why is it especially important to test for a zero slope?
--------------------------------------------------------------------------------------------------------------------------------------------
DATA SET B (See attached file for data)

Using the data set above........
12.28 Are the variables cross-sectional data or time-series data?
12.29 How do you imagine the data were collected?
12.30 Is the sample size sufficient to yield a good estimate? If not, do you think more data could easily be obtained, given the nature of the problem?

12.31 State your a priori hypothesis about the sign of the slope. Is it reasonable to suppose a cause and effect relationship?
12.32 Make a scatter plot of Y against X. Discuss what it tells you.
12.33 Use Excel's Add Trendline feature to fit a linear regression to the scatter plot. Is a linear model credible?
12.34 Interpret the slope. Does the intercept have meaning, given the range of the data?
12.35 Use Excel, MegaStat, or MINITAB to fit the regression model, including residuals and standardized residuals.
12.36 (a) Does the 95 percent confidence interval for the slope include zero? If so, what does it mean? If not, what does it mean? (b) Do a two-tailed t test for zero slope at α = .05. State the hypotheses, degrees of freedom, and critical value for your test. (c) Interpret the p-value for the slope. (d) Which approach do you prefer, the t test or the p-value? Why? (e) Did the sample support your hypothesis about the sign of the slope?

12.37 (a) Based on the R2 and ANOVA table for your model, how would you assess the fit? (b) Interpret the p-value for the F statistic. (c) Would you say that your model's fit is good enough to be of practical value?

12.38 Study the table of residuals. Identify as outliers any standardized residuals that exceed 3 and as unusual any that exceed 2. Can you suggest any reasons for these unusual residuals?

12.39 (a) Make a histogram (or normal probability plot) of the residuals and discuss its appearance. (b) Do you see evidence that your regression may violate the assumption of normal errors?

12.40 Inspect the residual plot to check for heteroscedasticity and report your conclusions.
12.41 Is an autocorrelation test appropriate for your data? If so, perform one or more tests of the residuals (eyeball inspection of residual plot against observation order, runs test, and/or Durbin-Watson test).

12.42 Use MegaStat or MINITAB to generate 95 percent confidence and prediction intervals for various X-values.
12.43 Use MegaStat or MINITAB to identify observations with high leverage.