Question
In: Statistics and Probability
Q1: A sample with two variables (x and y) is given in the table. According to...
|
Q1: A sample with two variables (x and y) is given in the table. According to the sample, please develop an excel spreadsheet to calculate the missing values given in the table of “summary output” attached below. The excel spreadsheet needs to be submitted together with your assignment. Note: use “data analysis toolpak” to check your answers, but calculations, equations and steps should be done for each "?" value |
|
x |
y |
|
1.0 |
5.2 |
|
1.5 |
7.2 |
|
2.0 |
5.5 |
|
2.5 |
4.9 |
|
3.0 |
7.3 |
|
3.5 |
9.5 |
|
4.0 |
11.3 |
|
4.5 |
10.9 |
|
5.0 |
11.8 |
|
5.5 |
12.3 |
|
6.0 |
11.7 |
|
6.5 |
12.1 |
|
SUMMARY OUTPUT |
||||||
|
Regression Statistics |
||||||
|
Multiple R |
? |
|||||
|
R Square |
? |
|||||
|
Adjusted R Square |
? |
|||||
|
Standard Error |
? |
|||||
|
Observations |
? |
|||||
|
ANOVA |
||||||
|
df |
SS |
MS |
F |
Significance F |
||
|
Regression |
? |
? |
? |
? |
? |
|
|
Residual |
? |
? |
? |
|||
|
Total |
? |
|||||
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
|
Intercept |
3.602 |
? |
? |
? |
? |
? |
|
Slope |
1.476 |
? |
? |
? |
? |
? |
Solutions
orchestra answered 1 year agoRelated Solutions
for the quantitative variables x and y are given in the table below. These data are...
for the quantitative variables
x
and
y
are given in the table below. These data are plotted in the
scatter plot shown next to the table.
In the scatter plot, sketch an approximation of the
least-squares regression line for the data.
x
y
7.4
6.6
4.0
5.0
2.0
3.9
3.1
5.0
9.4
8.4
4.7
5.9
6.6
6.2
8.5
6.9
7.9
7.3
1.6
3.7
4.4
4.6
2.8
3.9
2.7
3.1
5.7
6.3
5.9
7.3
9.7
8.3
6.9
6.3
8.8
8.4
x...
A random sample of two variables, x and y, produced the following observations: x y 19...
A random sample of two variables, x and y, produced the
following observations:
x
y
19
7
13
9
17
8
9
11
12
9
25
6
20
7
17
8
Compute the correlation coefficient for these sample data.
Group of answer choices
a. -0.9707
b. -0.2141
c. 0.5133
d. 0.8612
Given contingency table for simultaneous occurance of two categorical random variables X (levels A,B,C) and Y...
Given contingency table for simultaneous occurance of two
categorical random variables X (levels A,B,C) and Y (levels
L1,L2,L3)
L1
L2
L3
A
10
20
30
B
15
20
30
C
25
22
32
Determine the marginal probability P ( X = B )
= (round to the sthird decimal place)
Determine the conditional probability P ( Y = L 2 | X = B )
= (round to the second decimal place)
Use R to conduct a chi-square test of independence and...
Given two random variables x and y State of Nature Probability variable x variable y I...
Given two random variables x and y
State of Nature Probability variable x
variable y
I 0.2 18 0
II 0. 2 5 -3
III 0.2 12 15
IV 0.2 4 12
V 0.2 6 1
(i) Calculate the mean and variance of each of these variables
and the covariance between them
(ii) Suppose x and y represent the returns from two assets.
Calculate the mean and variance for the following part folios.
% in x 125 100 75 50...
The joint probability density function for two random variables X and Y is given as, fx,y...
The joint probability density function for two random variables
X and Y is given as, fx,y (x, y) = (2/3)(1 + 2xy3 ), 0
< x < 1, 0 < y < 1
(a) Find the marginal probability density functions for X and Y
.
(b) Are X and Y independent? Justify your answer.
(c) Show that E[X] = 4/9 and E[Y ] = 7/15 .
(d) Calculate Cov(X, Y )
Below are the values for two variables x and y obtained from a sample of size...
Below are the values for two variables x and y obtained from a
sample of size 5. We want to build a regression equation based the
sample data.
ŷ = b₀ + b₁x
y
x
16
5
21
10
8
6
28
12
53
14
11
On average the observed y deviate from the predicted y by,
a
10.73
b
10.04
c
9.53
d
8.76
12
Sum of squares total (SST) is,
a
1096.3
b
1178.8
c
1296.7
d
1361.5...
Below are the values for two variables x and y obtained from a sample of size...
Below are the values for two variables x and y obtained from a
sample of size 5. We want to build a regression equation based the
sample data.
ŷ = b₀ + b₁x
y
x
16
5
21
10
8
6
28
12
53
14
1
The sum product of x and y is,
a
1416
b
1451
c
1466
d
1481
2
The value in the numerator of the formula to compute the slope of
the regression equation is,...
Given are five observations for two variables, x and y. The estimated regression equation for these...
Given are five observations for two variables, x and y. The
estimated regression equation for these data is y = 1 + 2.4x
(A) Compute SSE, SST, and SSR
(B) Compute the coefficient of determination, R^2.
(C) Compute the sample correlation coefficient.
x
y
1
3
2
8
3
5
4
12
5
13
Fourth Question: The table below represents a relationship between two variables X and Y x 7,8,4,3,9,5,7,1,2...
Fourth Question: The table below represents a
relationship between two variables X and Y
x 7,8,4,3,9,5,7,1,2
y 8,10,5,2,12,3,9,1,1
a) Calculate the Pearson correlation coefficient
between the X and Y variables.
B) Find the y regression equation for X for the cooked data
c) Calculate the estimated value (prediction) of the variable Y
when the value of the variable X is equal to 5. What is the error
value of the estimate?
Given below is a bivariate distribution for the random variables x and y. f(x, y) x...
Given below is a bivariate distribution for the random variables
x and y.
f(x,
y)
x
y
0.3
50
80
0.2
30
50
0.5
40
60
(a)
Compute the expected value and the variance for x and
y.
E(x)
=
E(y)
=
Var(x)
=
Var(y)
=
(b)
Develop a probability distribution for
x + y.
x + y
f(x +
y)
130
80
100
(c)
Using the result of part (b), compute
E(x +
y)
and
Var(x +
y).
E(x...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Can you explain to me the differnces in how we paid for the health care (access...
- Discuss proactive and defensive marketing in context to the company position in the hypothetical market structure...
- Write a java code that could be used to show the simulation of a tornado. use...
- A Canadian company issues an 8-year term bond with face value of $1,000 and 6% coupon...
- 1. Consider the following nuclides: &
- In general, teams can be described three ways. Name and define each.
- JAVASCRIPT: Please create an array of student names and another array of student grades. - Create...
ADVERTISEMENT