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
For the given data using Regression in Excel we get output as
So from the above output
Answer : 0.5578 proportion of variation in y that is explained by x and z
Get Answers For Free
Most questions answered within 1 hours.