A researcher would like to predict the dependent variable Y from
the two independent variables X1 and X2 for a sample of N=10
subjects. Use multiple linear regression to calculate the
coefficient of multiple determination and test statistics to assess
the significance of the regression model and partial slopes. Use a
significance level α=0.02.
X1 | X2 | Y |
---|---|---|
40.5 | 62.9 | 21.8 |
16.4 | 51.3 | 31.8 |
62.5 | 44.4 | 29.6 |
60.4 | 53.6 | 40.6 |
50.2 | 54 | 33.7 |
39.2 | 51.5 | 37 |
80.9 | 16.9 | 58.1 |
41.6 | 52.6 | 34.6 |
48.5 | 50 | 34.7 |
35.6 | 57.2 | 33.8 |
R2=0.747
F=10.33
P-value for overall model = 0.0082
b1=0.04, t1=0.29, P-value = 0.7802
b2=−0.61, t2=−3.05, P-value = 0.0186
What is your conclusion for the overall regression model (also
called the omnibus test)?
Which of the regression coefficients are statistically different from zero?
A researcher would like to predict the dependent variable Y from the two independent variables X1...
A researcher would like to predict the dependent variable YY from the two independent variables X1X1 and X2X2 for a sample of N=12N=12 subjects. Use multiple linear regression to calculate the coefficient of multiple determination and test statistics to assess the significance of the regression model and partial slopes. Use a significance level α=0.01α=0.01. X1X1 X2X2 YY 51.1 40.5 48 53.5 41 51.5 53.2 62.8 42.8 52.3 52.7 51.3 64.1 60 48.8 56.8 62.1 50 61.6 88.1 39.2 60.4 62.5...
Please explain how to do this in excel A researcher would like to predict the dependent variable Y from the two independent variables X and X2 for a sample of N 10 subjects. Use multiple linear regression to calculate the coefficient of multiple determination and test statistics to assess the significance ofthe regression model and partial slopes. Use a significance level a 0.02. Y 39.6 38.2 72.2 43.8 63.6 10.2 39.6 59.1 28.8 78.9 35.5 63.2 43.1 73.4 66.1 48.2...
A researcher would like to predict the dependent variable YY from the two independent variables X1X1 and X2X2 for a sample of N=20N=20 subjects. Use multiple linear regression to calculate the coefficient of multiple determination and test the significance of the overall regression model. Use a significance level α=0.01α=0.01. X1X1 X2X2 YY 23.5 33.6 50.2 8.7 31.6 53.7 24.3 43 43 16.7 24.6 83.6 34.2 39.1 45 52.2 30 55.4 32.7 41.8 34.2 24.8 20.6 71.7 31.8 44.1 51.3 46.7...
Consider a multiple regression model of the dependent variable y on independent variables x1, X2, X3, and x4: Using data with n 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: y0.35 0.58x1 + 0.45x2-0.25x3 - 0.10x4 He would like to conduct significance tests for a multiple regression relationship. He uses the F test to determine whether a significant relationship exists between the dependent variable and He uses the t...
4. Testing for significance Aa Aa Consider a multiple regression model of the dependent variable y on independent variables x1, x2, X3, and x4: Using data with n = 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: 0.04 + 0.28X1 + 0.84X2-0.06x3 + 0.14x4 y She would like to conduct significance tests for a multiple regression relationship. She uses the F test to determine whether a significant relationship exists...
5. Summary of regression between a dependent variable y and two independent variables X, and x2 is as follows. Please complete the table: SUMMARY OUTPUT Regression Statistics Multiple R 0.9620 R Square R2E? Adjusted R Square 0.9043 Standard Error 12.7096 Observations 10 ANOVA F Significance F F=? Overall p-value=? Regression Residual Total 2 df of SSE MS MSR=? MSE? 14052.1550 1130.7450 SSTE? MSE? 9 Coefficients -18.3683 Standard Error 17.9715 t Stat -1.0221 Intercept ty=? 2.0102 4.7378 0.2471 0.9484 P-value 0.3408...
Suppose we have the following values for a dependent variable, Y, and three independent variables, X1, X2, and X3. The variable X3 is a dummy variable where 1 = male and 2 = female: X1 X2 X3 Y 0 40 1 30 0 50 0 10 2 20 0 40 2 50 1 50 4 90 0 60 4 60 0 70 4 70 1 80 4 40 1 90 6 40 0 70 6 50 1 90 8 80 ...
Consider a binary response variable y and two explanatory variables x1 and x2. The following table contains the parameter estimates of the linear probability model (LPM) and the logit model, with the associated p-values shown in parentheses. Variable LPM Logit Constant −0.60 −2.50 0.02 (0.03 ) x1 0.28 0.99 (0.06 ) (0.06 ) x2 −0.06 −0.30 (0.03 ) (0.06 ) a. At the 5% significance level, comment on the significance of the variables for both models. Variable LPM Logit x1...
Consider the following data for a dependent variable y and two independent variables, x1 and 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. Find the...
A regression analysis is performed using data for 36 single-family homes to predict appraised value (in thousands of dollars) based on land area of the property (in acres), X1i, and age (in years), X2i, in month i. Use the results below to complete parts (a) and (b) below. Variable Coefficient Standard Error t Statistic p-value Intercept 392.60372 51.68272 7.60 0.0000 Area, X1 451.43475 100.48497 4.49 0.0001 Age,X2 −2.17162 0.79077 −2.75 0.0097 a. Construct a 95% confidence interval estimate...