Question: Given the following Table (Please show all your calculations - Excel solution alone will not be given X (independent) 5 7 10 9 11

Given the following Table (Please show all your calculations - Excel solution alone will not be given X (independent) 5 7 10 9 11 12 Y (Dependent) 22 17 14 13 10 7 4 15 20 3 a. Draw a scatter Diagram and speculate on the relationship between x and y b. Compute the coefficient of correlation and confirm your speculation. Please show you calculations manually. c. Compute the coefficient of determination and tell the readers what it means. Please show you calculations manually d. Compute the linear regression equation. Please show you calculations manually. e. Is the regression significant... Use alpha of 0.05... What does it mean?
Step by Step Solution
3.44 Rating (163 Votes )
There are 3 Steps involved in it
a To draw a scatter diagram we plot the values of X on the xaxis and the corresponding values of Y on the yaxis X Y 5 22 7 17 10 14 9 13 11 10 12 7 4 20 15 3 b To compute the coefficient of correlatio... View full answer
Get step-by-step solutions from verified subject matter experts
