Question
Run a regression analysis in Excel using the following data. The dependent variable is Y: X...
Run a regression analysis in Excel using the following data.
The dependent variable is Y:
X 2 4 6 8 10
Y 19 43 55 73 110
What is the value for the regression sum of squares? Round
your answer to 1 decimal place.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Run a regression analysis in Excel using the following data. The dependent variable is Y: X...
Run a regression analysis in Excel using the following data. The
dependent variable is Y:
X
Y
2
19
4
43
6
55
8
73
10
110
What is the value for the regression sum of squares? Round your
answer to 1 decimal place.
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression
analysis relating Y (dependent variable) and X (independent
variable).
ANOVA
df
SS
Regression
1
39947.80
Residual (Error)
10
8280.81
Total
11
48228.61
Coefficients
Standard Error
t Stat
P-value
Intercept
69.190
26.934
2.569
0.02795
X
2.441
0.351
6.946
0.00004
1. What is the estimated regression equation
that relates Y to X?
2. Is the regression relationship significant?
Use the p-value approach and alpha = 0.05 to answer this
question.
3. What is the...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel
output for regression analysis relating Y (dependent variable) and
X (independent variable).
ANOVA
df
SS
Regression
1
3348.312
Residual
8
9529.811
Total
9
12878.123
Coefficients
Standard Error
t Stat
P-value
Intercept
247.56
83.280
1.689
0.030
X
148.62
38.312
1.283
0.075
1. What is the estimated regression equation that relates y to x?
(2 Points)
2. Is the regression relationship significant? Use a p-value and
alpha = 0.05. (2 Points)
3. What is...
Use these data for Questions 5 and 6. Conduct a regression analysis in Excel using the...
Use these data for Questions 5 and 6.
Conduct a regression analysis in Excel using the following
data:
X
Y
12
40
23
50
40
59
33
58
18
45
What is the value of b0? Include 1 decimal place in
your answer.
What is the value of b1? Include 2 decimal places in your
answer.
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
28.8
90.1
30.6
139.6
12.6
42.2
18.1
94.8
13.9
28.5
31.9
102.4
-3.9
-13.4
16.7
57.1
11
55.8
16.8
76.3
31.7
80.1
43.5
123.8
Find the correlation coefficient and report it accurate to three
decimal places.
r =
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a
percentage...
A regression and correlation analysis resulted in the following information regarding a dependent variable (y) and...
A regression and correlation analysis resulted in the following
information regarding a dependent variable (y) and an
independent variable (x).
Σx = 90
Σ(y - )(x - ) = 466
Σy = 170
Σ(x - )2 = 234
n = 10
Σ(y - )2 = 1434
SSE = 505.98
The least squares estimate of the intercept or
b0 equals
Question 18 options:
a)
-1.991.
b)
.923.
c)
-.923.
d)
1.991.
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
48
41.8
39.2
67.4
34.7
68.4
42.9
50.2
49
50.6
45.6
57
58.7
29.7
40.5
68.4
47.4
34.7
45.7
50.9
38.9
47.7
40.9
53.6
Find the correlation coefficient and report it accurate to three
decimal places.
r =
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a
percentage...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
81.1
86
77.5
60.4
92.7
126.5
104
132.5
85
53.1
64.3
95.5
64.6
31.7
39.7
5.7
82.3
121.3
82.4
98.2
29.2
-50.2
34.2
-1
Find the correlation coefficient and report it accurate to three
decimal places.
r =
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a
percentage...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
51.3
17.4
60.8
88.6
37.4
32.9
44.6
53.4
53.7
53.6
52.2
41.5
32.7
28.6
62.4
84.7
47.4
35.7
39.8
33.7
62.1
123
62
83.7
Find the correlation coefficient and report it accurate to three
decimal places.
r = _______
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
16.1
47.3
10.6
42.8
22.4
50.6
33.3
67.6
47.8
61.1
41.4
62.1
30.2
57.9
30.6
53.6
33
57.4
9.7
41.2
19.3
49.6
Verify that the correlation is significant at an α=0.05. If the
correlation is indeed significant, predict what value (on average)
for the explanatory variable will give you a value of 54 on the
response variable.
What is the predicted...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 4 minutes ago
asked 7 minutes ago
asked 11 minutes ago
asked 11 minutes ago
asked 12 minutes ago
asked 12 minutes ago
asked 53 minutes ago
asked 58 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago