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

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
Points)
2. Is the
regression relationship significant? Use the p-value approach and
alpha = 0.05 to answer this...

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

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 44 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago