Question

In: Statistics and Probability

Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F...

  1. Shown below is a partial Excel output from a regression analysis.

ANOVA

df

SS

MS

F

Regression

  60

Residual

Total

19

140

Coefficients

Standard Error

Intercept

10.00

2.00

x1

-2.00

1.50

x2

6.00

2.00

x3

-4.00

1.00

a.

Use the above results and write the regression equation. [4 Marks]

b.

Compute the coefficient of determination and fully interpret its meaning. [4 Marks]

c.

Is the regression model significant? Perform the test at let α = 0.05. [4 Marks]

d.

At  = 0.05, test to see if there is a relation between x1 and y. [4 Marks]

e.

At  = 0.05, test to see if there is a relation between x3 and y. [4 Marks]

Solutions

Expert Solution

using Given output

a) Use the above results and write the regression equation

y = 10.00-2.00x1+6.00x2-4.00x3

b)

we define the coefficient of determination by

so here we need to complete the Anova table

df SS MS F
Regression 60   
Residual
Total 19 140

here we use following information to fill above table

df for Regression = k-1 where k number of is independent variable

df for Regression = 3-1 = 2

df for Residual = df for Total - df for Regression

df for Residual =19-2=17

Now SS for Residual = SS for Total - SS for Regression

SS for Residual = 140 - 60 = 80

MS Regression = SS Regression/df for Regression

MS Regression = 60/2 = 30

MS Residual = SS Residual/df for Regression

MS Residual = 80/17 =4.7059

F = (SS Regression/df for Regression) /( SS for Residual/df for Residual)

F =30/4.7059

F =6.3750

So Completed anova table is

df SS MS F
Regression 2 60 30 6.3750
Residual 17 80 4.7059
Total 19 140

we define the coefficient of determination by

R2= 30/ 140

R2=0.2143

It can be interpreted as 21.43% variation explained by independent variable to the dependent variable.

Is the regression model significant? Perform the test at let α = 0.05.

F-Critical value = 4.619.(using statistical table)

Since F-statistic=6.3750 > F-Critical value =4.619 so we reject the null hypothesis and conclude that the regression model significant.

d)

test to see if there is a relation between x1 and y

t-cal =

t-cal = 10/2 =5

degree of freedom = n-k-1

degree of freedom = 20-3-1= 16

t-critical at = 0.025 and 16 degree of freedom = 2.12

so t-cal =5 > t-critical= 2.12 so reject the null hypothesis and conclude that there is significant relationship between x1 and y.


Related Solutions

Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F Regression   60 Residual Total 19 140 Coefficients Standard Error Intercept 10.00 2.00 x1 -2.00 1.50 x2 6.00 2.00 x3 -4.00 1.00 a. Use the above results and write the regression equation. [4 Marks] b. Compute the coefficient of determination and fully interpret its meaning. [4 Marks] c. Is the regression model significant? Perform the test at let α = 0.05. [4 Marks] d. At...
Below is the ANOVA table for a linear regression analysis: Source SS df MS Lin Regression...
Below is the ANOVA table for a linear regression analysis: Source SS df MS Lin Regression 75 1 75 Residual 1500 60 25 Total 1575 61 (a) How many people were tested? N = ________ (b) What are the tabled (α = .05) and calculated F-values? Ftabled = ___________ Fcalc = ___________ (c) What are the two possible values for the product moment correlation (r)? r = _______ or _______ (d) Without calculating the interval, will the 95% confidence interval...
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...
A portion of an ANOVA summary table is shown below. Source DF SS MS Between 2...
A portion of an ANOVA summary table is shown below. Source DF SS MS Between 2   84.11 42.06 Within (error) 15 88.83 5.92 Total 17 172.94 Test at the 5% level of significance to determine whether differences exist among the population means.
b) Fill in the missing entries in the ANOVA table below. Source df SS MS F...
b) Fill in the missing entries in the ANOVA table below. Source df SS MS F Regression 8 3.365 Error 6 10.825 Total 14 c) Is there evidence to support that the model is significant? Test using ?=0.05α=0.05. 1. ?0:?1=...=?8H0:β1=...=β8 vs ??:Ha: At least one ?β differs from 0. 2. Test statistic: F = 3. Critical value: ??Fα = 4. Conclusion:  ?0H0. (Type either Reject or Fail to reject) There  evidence that the part of the model which concerns the departments is...
C -- Given the following ANOVA table: Source DF SS MS F Regression 1 1,200.0 1,200.00...
C -- Given the following ANOVA table: Source DF SS MS F Regression 1 1,200.0 1,200.00 24.00 Error 12 600.0 50.00 Total 13 1,800.0 Determine the coefficient of determination. (Round your answer to 3 decimal places.) Assuming a direct relationship between the variables, what is the correlation coefficient? (Round your answer to 2 decimal places.) Determine the standard error of estimate. (Round your answer to 2 decimal places.) D -- A consumer buying cooperative tested the effective heating area of...
The following ANOVA table was obtained when estimating a multiple regression model. ANOVA df SS MS...
The following ANOVA table was obtained when estimating a multiple regression model. ANOVA df SS MS F Significance F    Regression   2 188,246.80    94,123.40    35.2     9.04E-07          Residual 17   45,457.32    2,673.96       Total 19   233,704.10    a. Calculate the standard error of the estimate. (Round your answer to 2 decimal places.)   se    b-1. Calculate the coefficient of determination. (Round your answer to 4 decimal places.)   Coefficient of determination    b-2. Interpret the coefficient of determination.    The...
Find the missing values in the following ANOVA Table Source of Variation Df SS MS F...
Find the missing values in the following ANOVA Table Source of Variation Df SS MS F Between 3 b 1.56 5.73 Within a 4.36 c Total 19 a. What is the total sample size? How many groups are there? b. If α = 0.025 will you reject Ho? Show your reasoning.
  ANOVA   Source of Variation SS df MS F p-value   Factor A 33,443.41 3         11,147.80   Factor...
  ANOVA   Source of Variation SS df MS F p-value   Factor A 33,443.41 3         11,147.80   Factor B 24,232.44 2         12,116.22   Interaction 168,937.71 6         28,156.29   Error 135,865.32 36         3,774.04   Total 362,478.88 47         (a) What kind of ANOVA is this? One-factor ANOVA Two-factor ANOVA with replication Two-factor ANOVA without replication (b) Calculate each F test statistic and the p-value for each F test using Excel's function =F.DIST.RT(F,DF1,DF2). (Round your Fcalc values to 3 decimal places and p-values to...
Source df SS MS F Significance of F Regression 207 (Given) Residual 16.59 (Given) Total Suppose...
Source df SS MS F Significance of F Regression 207 (Given) Residual 16.59 (Given) Total Suppose that a multiple regression model was developed with a sample of data of size 190 and 13 independent variables. One of the 13 independent variables is a qualtiative variable with 6 levels for which necessary dummy variables were defined. a) The following is a partially complete ANOVA table for the Multiple Regression analysis. Round Answer to 4 Decimal Places
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT