a) SSE =SST - SSR = 1805 - 1764 = 41
MSR = SSR/p
= 1764/4 = 441
MSE = SSE/(n-p-1) = 41/25 = 1.64
F = MSR/MSE = 441/1.64 = 268.9
We find that for (4,25) degrees of freedom the area in the upper tail of the F distribution corresponding to the test statistic F = 268.9 must be less 0.01
Excel shows the p value = 0.000
Because the p-value is less than 0.05,we ewject the null hypothesis that the relationship among the variables y and x1,x2,x3,x4 is not significant
So we conclude that the relationship among y and x1,x2,x3 and x4 is significant
b)
c)
We find that for (2,25) degrees of freedom the area in the upper tail of the F distribution corresponding to the test statistic F = 17.98 must be less 0.01
Excel shows the p value = 0.000
Because the p-value is less than 0.05,we ewject the null hypothesis that x1 and x4 are not statistically significant
So we conclude that adding x1 and x4 are significant
eBook Video In a regression analysis involving 30 observations, the following estimated regression equation was obtained....
In a regression analysis involving 30 observations, the following estimated regression equation was obtained. = 17.6 +3.821 -2.3x2 + 7.603 + 2.724 For this estimated regression equation SST = 1805 and SSR = 1,756. a. At a = 0.05, test the significance of the relashionship among the variables. SSE (to 1 decimal, if necessary) MSR (to 1 decimal, if necessary) MSE (to 2 decimals, if necessary) What is the value of the F test statistic (to 1 decimal)? Use Table...
In a regression analysis involving 30 observations, the following estimated regression equation was obtained. y=17.6+3.8x1-2.3x2+7.6x3+2.7x4 For this estimated regression equation SST= 1805 and SSR=1756. a. At a= 0.05 , test the significance of the relationship among the variables. SSE=_________________ (to 1 decimal, if necessary) MSR=________________ (to 1 decimal, if necessary) MSE=+_______________ (to 2 decimals, if necessary) What is the value of the F test statistic (to 1 decimal)? _______________ What is the p-value? - Select your answer -less than .01,between...
a. In a regression analysis involving 30 observations, the following estimated regression equation was obtained: y=17.6+3.8x1-2.3x2+7.6x3+2.7x4 For this estimated regression equation SST=1805, and SSR=1760. At α=0.05, test the significance of the relationship among the variables.
A shoe store developed the following estimated regression equation relating sales to inventory investment and advertising expenditures where 1inventory investment ($1000s) = advertising expenditures ($1000s) y sales ($1000s) The data used to develop the model came from a survey of 10 stores; for those data, SST 16,000 and SSR a. Compute SSE, MSE, and MSR (to 2 decimals, if necessary) 12,000 SSE MSE MSR b. Use an F test and α .05 level of significance to determine whether there is...
In a multiple regression model involving 44 observations, the following estimated regression equation was obtained. ŷ= 29 + 18x1 + 43x2 + 87x3 For this model, SSR = 600 and SSE = 400. The F statistic for the above model is 10 60 400 600
In a regression model involving 30 observations, the following estimated regression equation was obtained: 17+ 4x4 - 3x2 + 8x3+8X For this model SSR = 700 and SSE - 100. The computed Fstatistic for testing the significance of the above model is 43.75 7.00 50.19 0.875
Exhibit 1 In a regression model involving 30 observations, the following estimated regression equation was obtained: Y=17+4X, - 3X,+8X,+8X For this model SSR = 700 and SSE = 100. 12. Refer to Exhibit 1. The conclusion is that the 2. model is not significant b. model is significant c. slope of X, is significant d. slope of X, is significant
6. In a regression model involving 46 observations, the following estimated regression equation was obtained. û = 17+4X1 - 3X2 + 8X3 +5X4 + 8Xs For this model, SST = 3410 and SSE = 510. a. Compute the coefficient of determination. b. Perform an F test and determine whether or not the regression model is significant
The estimated regression equation for a model involving two independent variables and 10 observations follows. v=27.085 + 0.3331 + 0.604222 a. Interpret by and b2 in this estimated regression equation. bi Select your answer 02 Select your answer b. Estimate y when Z1 =180 and 22 = 310 (to 3 decimals). The exercise involving data in this and subsequent sections were designed to be solved using Excel. The following estimated regression equation is based on 30 observations. y = 17.2...
Check My Work (2 remaining) eBook Video Given are five observations for two variables, and y 4 7813 15 The estimated regression equation for these data is-1+2.8z. a. Compute SSE, SST, and SSR using the following equations (to 1 decimal). (y,-y? SST SSE SST SSR b. Compute the coefficient of determination 2 (to 3 decimals) Does this least squares line provide a good fit? Select your answer C. Compute the sample correlation coefficient (to 4 decimals) Check My Work (2...