Question

Shown here are the data for y and three predictors, x1, x2, and x3. A stepwise...

Shown here are the data for y and three predictors, x1, x2, and x3. A stepwise regression procedure has been done on these data; the results are also given. Comment on the outcome of the stepwise analysis in light of the data.

y x1 x2 x3
94 21 1 204
97 25 0 198
93 22 1 184
95 27 0 200
89 31 1 183
91 20 1 159
91 18 1 147
94 25 0 196
98 26 0 228
99 24 0 242
90 28 1 162
92 23 1 180
96 25 0 219


Step 1 2 3
Constant 74.57 82.8 89.05
X3 0.1 0.064 0.07
T-Value 5.97 2.95 4.92
P-Value 0.000 0.014 0.001
X2 -2.53 -2.9
T-Value -2.2 -3.83
P-Value 0.053 0.004
X1 -0.297
T-Value -3.8
P-Value 0.004
S 1.59 1.37 0.895
R-Sq 76.43 % 84.11 % 93.9 %

Homework Answers

Answer #1

We are given the outcome of the stepwise Regression analysis. It is obvious that it is a forward type of stepwise regression analysis. In forward type, we start from a single explanatory variable and keep adding the other explanatory variable and check the fitness of model in each step.

To check the fitness of models, we have many criteria but out of the given output, we have two determinants first the significance of the variable and secondly the R-square.

We got all the explanatory variables significant in each step that indicates X1, X2 and X3 are significant to add in the model. Moreover, the R-square (93.9%) value is maximum for model 3. The R-square shows that amount of variation on Y (dependent variable) that can be explained through all the covariates. Therefore, at last, we can conclude that the model 3 is the best model and it is worth to add the variables x1, x2 and x3.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given here are data for a dependent variable and four potential predictors. y x1 x2 x3...
Given here are data for a dependent variable and four potential predictors. y x1 x2 x3 x4 x5 96 8 60 2.4 48 51 73 6 64 2.1 42 43 108 2 76 1.8 34 20 124 5 74 2.2 11 14 82 6 50 1.5 61 29 89 9 57 1.6 53 22 76 1 72 2 72 38 109 3 74 2.8 36 40 123 2 99 2.6 17 50 125 6 81 2.5 48 55 101 2...
You have a data set with three predictors: X1 = GPA, X2 = IQ, and X3...
You have a data set with three predictors: X1 = GPA, X2 = IQ, and X3 = Gender (1 for female, 0 for male). The response is starting salary after graduation (in $ thousands). We use least squares to fit the model, and we get b0 = 50, b1 = 20, b2 = 0.07, and b3 = 35. a. Predict the salary of a woman with an IQ of 110 and a GPA of 4.0 (for calculation please use Excel.)...
Let X = ( X1, X2, X3, ,,,, Xn ) is iid, f(x, a, b) =...
Let X = ( X1, X2, X3, ,,,, Xn ) is iid, f(x, a, b) = 1/ab * (x/a)^{(1-b)/b} 0 <= x <= a ,,,,, b < 1 then, Show the density of the statistic T = X(n) is given by FX(n) (x) = n/ab * (x/a)^{n/(b-1}}   for 0 <= x <= a ; otherwise zero. # using the following P (X(n) < x ) = P (X1 < x, X2 < x, ,,,,,,,,, Xn < x ), Then assume...
Consider the following data for a dependent variable y and two independent variables,  x1 and x2. x1...
Consider the following data for a dependent variable y and two independent variables,  x1 and x2. x1 x2 y 30 12 94 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 211 The estimated regression equation for these data isŷ = −18.37 + 2.01x1 + 4.74x2. Here, SST = 15,182.9, SSR = 14,052.2, sb1 = 0.2471,  and  sb2 = 0.9484. (A) Test for a significant relationship...
Consider the following data for a dependent variable y and two independent variables, x1 and x2...
Consider the following data for a dependent variable y and two independent variables, x1 and x2 . x 1 x 2 y 29 13 94 46 11 109 25 17 112 50 16 178 40 6 95 51 19 175 74 7 170 36 13 117 59 13 143 76 17 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1 . ŷ...
2. Consider the data set has four variables which are Y, X1, X2 and X3. Construct...
2. Consider the data set has four variables which are Y, X1, X2 and X3. Construct a multiple regression model using Y as response variable and other X variables as explanatory variables. (a) Write mathematics formulas (including the assumptions) and give R commands to obtain linear regression models for Y Xi, i =1, 2 and 3. (b) Write several lines of R commands to obtain correlations between Xi and Xj , i 6= j and i, j = 1, 2,...
An analyst is running a regression model using the following data: Y x1 x2 x3 x4...
An analyst is running a regression model using the following data: Y x1 x2 x3 x4 x5 x6 4 1 5 0 -95 17 12 10 5 8 1 -27 7 10 32 1 7 0 -82 0 9 2 2 7 0 17 5 10 9 3 9 1 -46 5 11 Excel performs the regression analysis, but the output looks all messed up: For example the F statistic cannot be computed, standard errors are all zero, etc etc....
y   x1   x2   x3   x4 64   74   22   24   17 43   63   29   15   30 51  ...
y   x1   x2   x3   x4 64   74   22   24   17 43   63   29   15   30 51   78   20   9   25 49   52   17   38   29 39   45   12   19   37 Consider the set of dependent and independent variables given below. Perform a best subsets regression and choose the most appropriate model for these data. Find the most appropriate model for the data. Note that the coefficient is 0 for any variable that is not included in the model. y= _____+...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable. Determine the coefficient of...
Consider the following data for a dependent variable y and two independent variables, x1and x2. x1...
Consider the following data for a dependent variable y and two independent variables, x1and x2. x1 x2 y 30 12 96 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 211 The estimated regression equation for these data is ŷ = −17.33 + 2.00x1 + 4.73x2. Here, SST = 15,002.1, SSR = 13,887.5, sb1 = 0.2454,and sb2 = 0.9417. (a)Test for a significant...