Question

Id | x | z | y |

A | 6 | 7 | 3 |

B | 4 | 4 | 7 |

C | 10 | 10 | 8 |

D | 3 | 1 | 4 |

E | 2 | 3 | 2 |

given

Ryx= 0.6719

Ryz=0.5190

ssy=26.8

1. what is the variation in y that is redundantly explained by x
and z

2. What is the proportion of variation in y that is redundantly
explained by x and z

Answer #1

using excel>data>data analysis>Regression

we have

SUMMARY OUTPUT | ||||||

Regression Statistics | ||||||

Multiple R | 0.951247 | |||||

R Square | 0.904871 | |||||

Adjusted R Square | 0.809741 | |||||

Standard Error | 1.542152 | |||||

Observations | 5 | |||||

ANOVA | ||||||

df | SS | MS | F | ignificance F | ||

Regression | 2 | 45.24354 | 22.62177 | 9.512014 | 0.095129 | |

Residual | 2 | 4.756463 | 2.378231 | |||

Total | 4 | 50 | ||||

Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |

Intercept | 0.321769 | 1.625405 | 0.197962 | 0.861371 | -6.67178 | 7.31532 |

z | -0.27891 | 0.402224 | -0.69342 | 0.55975 | -2.00954 | 1.45172 |

x | 1.203401 | 0.329235 | 3.655146 | 0.067373 | -0.21318 | 2.619985 |

1. 90.48% variation in y that is redundantly explained by x and
z

2. 0.9048 proportion of variation in y that is redundantly
explained by x and z

Id
x
z
y
A
6
7
3
B
4
4
7
C
10
10
8
D
3
1
4
E
2
3
2
given
Ryx= 0.6719
Ryz=0.5190
ssy=26.8
what is the proportion of variation in y that is explained by x
and z

Id
x
z
y
A
6
7
3
B
4
4
7
C
10
10
8
D
3
1
4
E
2
3
2
given
Ryx= 0.6719
Ryz=0.5190
ssy=26.8
what is the variation in y that is explained by x and z

Given
ID
X
Y
A
10
15
B
4
5
C
13
16
D
7
9
E
13
4
F
1
5
What is the variation in Y that can be explained by X? please
explain
A) 50.7
B) 22.7
C) 36.3
D) 105.7
E) 91.3

x
y
2
8
4
7
6
11
8
10
10
14
12
14
FIND THE FOLLOWING IN EXCEL: (all part of 1 question)
Total SSx
Total SSy
Residual SS
Regression SS
Mean Residual SS
Mean Regression SS

x
f
10
3
9
6
8
4
7
5
6
2
Find the Z score when X = 9, for the for the following Data

a= 1, b =6 , c= 4
T(x,y,z) =(x^2 )y +(y^2 )z
Find the directional derivative of T at the point (a − 1, a, a +
1) along
the direction of the vector < a, b, c >.

X F
10 3
9 6
8 4
7 5
6 2
Find the Z score when X = 9, for the for the following Data
I like to have my calculations include up to the 3rd place after
the decimal.

for 10-12 you will solve the following system of equations:
2x+y+z=-2 2x-y+3z=6 3x-5y+4z=7 10) what is the solution for x? a)2
b)-3 c)infinitely many solutions d)no solution 11) what is the
solution for y? a)2 b)0 c)inifinitely many solution d)no solution
12) what is the solution for z? a)4 b)-8 c)infinitely many
solutions d)no solutions

Match each equation with its name. (calculus 3)
(x/7)^2-(y/9)^2=z/4
(x/7)^2-y/9+(z/4)^2=0
−x/7+(y/9)^2+(z/4)^2=0
(x/7)^2+(y/9)^2=(z/4)^2
(x/7)^2+(y/7)^2+(z/7)^2=1
Hyperbolic paraboloid
Elliptic paraboloid on x axis
Cone on z axis
Elliptic paraboloid on y axis
Sphere

DATA 1
ID
X1
Y
A
0
9
B
1
10
C
0
5
D
1
1
E
0
0
The zero order model is Ŷ = 8 − 2.5X1
1. What is the residual error in using the zero order model to
predict Y for ID C? (Correct answer is -3, please show me how to
find it)
2. What is the error in using the mean of Y to predict Y for ID
C? (correct answer is -2,...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 25 minutes ago

asked 1 hour 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 2 hours ago