Question

In: Statistics and Probability

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

  1. Determine the coefficient of determination. (Round your answer to 3 decimal places.)
  1. Assuming a direct relationship between the variables, what is the correlation coefficient? (Round your answer to 2 decimal places.)
  1. Determine the standard error of estimate. (Round your answer to 2 decimal places.)

D -- A consumer buying cooperative tested the effective heating area of 20 different electric space heaters with different wattages. Here are the results.

Heater

Wattage

Area

1

1,000

290

2

750

292

3

1,500

148

4

1,250

246

5

1,250

203

6

750

85

7

1,250

237

8

1,000

139

9

1,500

64

10

1,000

171

11

1,750

163

12

1,250

175

13

750

264

14

1,500

50

15

1,750

163

16

1,500

177

17

1,250

118

18

1,750

122

19

1,000

144

20

1,500

103

  1. Compute the correlation between the wattage and heating area. Is there a direct or an indirect relationship? (Round your answer to 4 decimal places.)
  1. Conduct a test of hypothesis to determine if it is reasonable that the coefficient is greater than zero. Use the 0.025 significance level. (Round intermediate calculations and final answer to 3 decimal places.)

H0: ρ ≤ 0; H1: ρ > 0 Reject H0 if t > 2.101

  1. Develop the regression equation for effective heating based on wattage. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places.)
  1. Which heater looks like the “best buy” based on the size of the residual? (Round residual value to 3 decimal places.)

Solutions

Expert Solution

C.

a) the coefficient of determination R2 = SSRegression/SStotal = 1200/1800 = 0.667

b) correlation coefficient = sqrt( R2) = 0.82 ( given it is a direct relationship)

c) standard error of estimate = Sqrt(SSE/N-2) = Sqrt(600/12) = 7.071

D) Excel results

a) Correlation coefficient = -0.4294, there is an indirect relationship .

b) H0: ρ ≤ 0; H1: ρ > 0 Reject H0 if t > 2.101

test statistic t = = -2.015

Fail to reject null hypothesis and conclude that there is no significant evidence that correlation coefficient is greater than zero.

c)

Regression Statistics
Multiple R 0.42935
R Square 0.184341
Adjusted R Square 0.139027
Standard Error 65.27225
Observations 20
ANOVA
df SS MS F Significance F
Regression 1 17331.79 17331.79 4.068049 0.058869
Residual 18 76688.41 4260.467
Total 19 94020.2
Coefficients Standard Error t Stat P-value
Intercept 283.5205 59.24965 4.785184 0.000148
Wattage -0.09174 0.045484 -2.01694 0.058869

equation is

Heating Area = 283.521 - 0.092* Wattage

d) RESIDUAL OUTPUT

Observation Predicted Area Residuals
1 191.7815 98.21851
2 214.7162 77.28376
3 145.912 2.088012
4 168.8467 77.15326
5 168.8467 34.15326
6 214.7162 -129.716
7 168.8467 68.15326
8 191.7815 -52.7815
9 145.912 -81.912
10 191.7815 -20.7815
11 122.9772 40.02276
12 168.8467 6.153263
13 214.7162 49.28376
14 145.912 -95.912
15 122.9772 40.02276
16 145.912 31.08801
17 168.8467 -50.8467
18 122.9772 -0.97724
19 191.7815 -47.7815
20 145.912 -42.912

based on the residuals the best buy is heater 18 with 1750 watts because its residual is close to zero.


Related Solutions

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...
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.
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...
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...
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
To answer this question, refer to the following two-way ANOVA summary table: SOURCE SS df MS...
To answer this question, refer to the following two-way ANOVA summary table: SOURCE SS df MS Rows 450.5     2 Columns 116.4 1 Interaction 2.3 2 1.15 Within-cells 260.4 24 Total 829.6 29 What is the value for MS rows? What is the value for MS columns? What is the value for MS within-cells? What is Fobt for rows? What is Fobt for column? What is Fobt for interaction?
Refer to the ANOVA table for this regression.   Source SS d.f. MS   Regression 1,035,678    15...
Refer to the ANOVA table for this regression.   Source SS d.f. MS   Regression 1,035,678    15     69,045   Residual 1,415,013    35     40,429      Total 2,450,691    50     (a) State the degrees of freedom for the F test for overall significance.   The degrees of freedom for regression are ________ and for error ______ . (b) Use Appendix F to look up the critical value of F for α = .05. (Round your answer to 2 decimal places.)   F.05 (c-1)...
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.
Consider the following table: Source SS DF MS Test Statistic Regression ? 7    1.38 Error...
Consider the following table: Source SS DF MS Test Statistic Regression ? 7    1.38 Error 4834.32       Total 8718.2 19 Copy Data Calculate the Sum of Squared Regression. Round your answer to two decimal places, if necessary. Calculate the Degrees of Freedom among Regression. Calculate the Mean Squared Regression. Round your answer to two decimal places, if necessary. Calculate the value of the test statistic. Round your answer to two decimal places, if necessary. How much of the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT