Model 1: Enter the data into XL Stat and compute a regression model using X1, X2, and X3 to predict Y.

(a) Paste the “Goodness of Fit Statistics” table. Comment on the R2 and RMSE.

(b) Assume there is a category called “marginal significance” which occupies the range: p > .05 to p <= .1. Which predictor variable is not significant and which is marginally significant?

Model 2: Rerun Model 1, only this time click on the Options tab and check the “Model Selection” box. Make sure that “Best Model” is showing as the option. XLStat now will tell you which model it prefers.

(c) Study the output. Which predictors did XLStat suggest as best?

(d) Do you agree that XLStat’s model is better than Model 1? Justify your answer.

y	x1	x2	x3
14	51	16.4	56
17	48	17.1	64
29	29	18.2	53
32	36	17.9	41
54	40	16.5	60
86	27	17.1	55
117	14	17.8	71
120	17	18.2	48
194	16	16.9	60
203	9	18	77
217	14	18.9	90
235	11	18.5	67

Answer rating: 100% (QA)

a Goodness of Fit Statistics Table 1 Goodness of Fit Statistics StatisticValue R208257 Adjusted R207788 RMSE239395 The R2 value of 08257 indicates tha... View the full answer