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
For the given data using Regression in Excel we get output as
Here x and z are independent
y is dependent
from the above output
Coefficient of determination ( r2 ) = 0.5578 = 55.78%
Therefore
Answer : 55.78% of the variation in y that is explained by x and z
Get Answers For Free
Most questions answered within 1 hours.