Question

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.

Answer #1

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) 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 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 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 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 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 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 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 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...

Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
74.1
53.3
81.3
65.5
64.4
79
102.4
35.8
73
59.4
45.4
110.1
66.4
84.9
73.8
70
52
97.5
70.2
86.9
91.1
43.3
Predict what value (on average) for the response variable will
be obtained from a value of 62.2 as the explanatory variable. Use a
significance level of α=0.05α=0.05 to assess the strength of the
linear correlation.
What is the predicted...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 8 minutes ago

asked 9 minutes ago

asked 24 minutes ago

asked 26 minutes ago

asked 32 minutes ago

asked 32 minutes ago

asked 39 minutes ago

asked 40 minutes ago

asked 46 minutes ago

asked 56 minutes ago

asked 57 minutes ago

asked 1 hour ago