Question

In: Statistics and Probability

Given the following regression analysis output.

Given the following regression analysis output.

ANOVA Table Source df MS F p-value Regression 227.0928 4 56.7732 9.27 0.000 Residual 153.0739 25 6.1230 Total 380.1667 29 Regresslon Output t (df = 25) p-value Varlables Coefficlents Standard Error Intercept 68.3366 8.9752 7.614 0.000 X, 0.8595 0.3087 2.784 0.010 -0.3380 0.8381 -0.403 0.690 -0.8179 0.2749 -2.975 0.006 -0.5824

 

a. What is the sample size?
b. How many independent variables are in the study?
c. Determine the coefficient of determination.
d. Conduct a global test of hypothesis. Can you conclude at least one of the independent variables does not equal zero? Use the .01 significance level.
e. Conduct an individual test of hypothesis on each of the independent variables. Would you consider dropping any of the independent variables? If so, which variable or variables would you drop? Use the .01 significance level.

Solutions

Expert Solution

The available output is as shown in below,

ANOVA table
Source
SS
Df
MS
F
Regression 227.0928 4 56.7732 14.50
Residual 153.0739 24 6.1230  
Total 380.1667 29    

 

Regression output
Variables
Coefficients
Std. error
t(df – 28)
Intercept 68.3366 8.9752 7.614
X1 0.8595 0.3087 2.784
X2 -0.3380 0.8381 -0.403
X3 -0.8179 0.2749 -2.975
X4 -0.5824 0.2541 -2.292

 

a)

Calculate the sample size.

dfTotal    = N – 1

29 = N – 1

⇒ N = 29 + 1

⇒ N = 30

 

Hence, the required sample size is, 30.

 

b)

Find the independent variables in the study.

There are four independent variables are there in given study, that is, X1, X2, X3 and X4.

 

c)

Calculate the coefficient of determination.

R2 = SSRegression/SSTotal

      = 227.0928/380.1667

     = 0.5974

 

Hence, the required answer is, 0.5974.

 

d)

Null hypothesis, H0: β1 = β2 = β3 = β4

Alternative hypothesis, H1 not all βi is 0 (for all ii = 1, 2, 3, 4)

Level of significance, α = 0.01

 

Decision rule: Reject H0| When Fstatistic > 4.18 (From F – tabulated values)

 

Since, the F – test statistic(14.50) is greater than the F – critical(4.18), so we reject the null hypothesis and conclude that the not all βi are 0 at the 0.01 level of significance.

 

e)

Decision rule: Reject H0| when t > 2787 or t < -2.787 (From t-tabulated values)

 

By using 1% level of significance, drop variable 2 initially and then rerun. Perhaps you will delete variable 1 and variable 4, since both test statistic values are less than the critical values.


a) Hence, the required sample size is, 30.

b) There are four independent variables are there in given study, that is, X1, X2, X3 and X4.

Related Solutions

Given the following regression output, Analysis of Variance Source DF       SS      MS F P Regression       2  1995489  997745 &n
Given the following regression output, Analysis of Variance Source DF       SS      MS F P Regression       2  1995489  997745  20.23  0.000 Residual Error  22  1084911   49314 Total           24  3080400 S = 222.068   R-Sq = 64.8%   R-Sq(adj) = 61.6% Predictor    Coef  SE Coef      T      P Constant   3080.1    343.9   8.96  0.000 X1         -54.19    12.28  -4.41  0.000 X2         16.289    3.784   4.30  0.000 a) Write the regression equation. b) If  is 5 and  is 15, what is the value of the dependent variable? c) How large is the sample? d) How many independent variables are there? e) How many dependent variables are there? f) Are all independent variables significant at the 5% significance level? g) Is the...
Below you are given a partial computer output from a multiple regression analysis based on a...
Below you are given a partial computer output from a multiple regression analysis based on a sample of 16 observations. Coefficients Standard Error Constant 12.924 4.425 x1 -3.682 2.630 x2 45.216 12.560 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Mean Square F Regression 4853 2426.5 Error 485.3 ​ Carry out the test of significance for the variable x1 at the 1% level. The null hypothesis should be options: be tested for β₃ instead. be rejected....
We give JMP output of regression analysis. Above output we give the regression model and the...
We give JMP output of regression analysis. Above output we give the regression model and the number of observations, n, used to perform the regression analysis under consideration. Using the model, sample size n, and output: Model: y = β0+ β1x1+ β2x2+ β3x3+ ε       Sample size: n = 30 Summary of Fit RSquare 0.956255 RSquare Adj 0.951207 Root Mean Square Error 0.240340 Mean of Response 8.382667 Observations (or Sum Wgts) 30 Analysis of Variance Source df Sum of Squares Mean Square...
We give JMP output of regression analysis. Above output we give the regression model and the...
We give JMP output of regression analysis. Above output we give the regression model and the number of observations, n, used to perform the regression analysis under consideration. Using the model, sample size n, and output: Model: y = β0 + β1x1 + β2x2 + β3x3 + ε       Sample size: n = 30 Summary of Fit RSquare 0.987331 RSquare Adj 0.985869 Root Mean Square Error 0.240749 Mean of Response 8.382667 Observations (or Sum Wgts) 30 Analysis of Variance Source df Sum...
The following output was obtained from a regression analysis of the dependent variable Rating and an...
The following output was obtained from a regression analysis of the dependent variable Rating and an independent variable Price. (10 points) ANOVA df SS MS F Regression 1 372.707 372.707 42.927 Residual 15 130.234 8.682 Total 16 502.941 Coefficients Standard Error t Stat P-value Intercept 45.623 3.630 12.569 0.000 Price 0.107 0.016 6.552 0.000 Use the critical value approach to perform an F test for the significance of the linear relationship between Rating and Price at the 0.05 level of...
You are given the following output for a multiple regression based on a sample of size...
You are given the following output for a multiple regression based on a sample of size n = 10 Predictions Coefficients Standard Error Constant -0.58762 x1 b1=1.510 0.351 x2 b2=-0.245 0.157 x3 b3=1.823 0.836 SSR=17.56; SSE=8.56 (a) Calculate a 90% confidence interval for β1. Provide a clear interpretation of the interval. (b) Which predictor variable(s) – x1, x2, x3 – should be kept in the regression model and why, if testing at a 5% level of significance? (use two-sided tests)...
The following output was obtained from a regression analysis of the dependent variable Sales volume and...
The following output was obtained from a regression analysis of the dependent variable Sales volume and an independent variable “location distance from the downtown branch.       ANOVA df SS MS F Regression 2 552.137 267.069 24.235 Residual 10 110.22 11.02 Total 12 662.357 Coefficients Standard Error t Stat P-value Intercept -38.623 3.630 12.569 0.000 Location distance 0.309 0.016 6.552 0.000 Calculate and interpret the correlation coefficient. What does it tell us? (1.5 marks) Calculate and interpret the coefficient of determination. (1.5...
PART B The following output was obtained from a regression analysis of the dependent variable Rating...
PART B The following output was obtained from a regression analysis of the dependent variable Rating and an independent variable Price. (10 points) ANOVA df                          SS                      MS               F Regression             1                      372.707              372.707      42.927 Residual                15                     130.234                8.682 Total                        16                     502.941 Coefficients       Standard Error          t Stat        P-value Intercept             45.623                   3.630                 12.569        0.000 Price                    0.107                    0.016                  6.552         0.000 Use the critical value approach to perform an F test for the significance of the linear relationship between Rating and Price at the 0.05...
1. What would the regression output (analysis) look like using this multiple regression equation and the...
1. What would the regression output (analysis) look like using this multiple regression equation and the following data? Daily Gross Revenue= total daily income+b1*daily tour income+b2*number of tourists+b3*Friday+b4*Saturday 2. What's the multiple regression equation with the numbers from the output? Years Weekend Daily Tour Income Number of Tourists Daily Gross Revenue Total Daily Income 1 Friday 3378 432 4838.95 8216.95 1 Saturday 1198 139 3487.78 4685.78 1 Sunday 3630 467 4371.3 8001.3 2 Friday 4550 546 6486.48 11036.48 2 Saturday...
In Regression Analysis, you are given the following information: Y = 21.33 + 9.67x SSE =...
In Regression Analysis, you are given the following information: Y = 21.33 + 9.67x SSE = 573 SSR = 4498 1. Predict the value of y if X = 4    . (2 decimal places) 2. Calculate the coefficient of determination  . (2 decimal places) 3. Is the following statement true or false? The coefficient of determination is the proportion of the variation in y that is not explained by the variation in x.    4. Based upon the Coefficient of Determination,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT