Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with the following: Perform a linear regression. Find the equation of the linear equation that best fits your data and calculate the correlation
Please help with the following:
Perform a linear regression. Find the equation of the linear equation that best fits your data and calculate the correlation coefficient (R).
Discuss the results and whether or not the results show a strong correlation or not. Discuss the value of R and what it means? What is ideal? Is this a good fit? Also, give examples in the real world where linear regression would make sense? When is a linear model the ideal model? In these cases what would you expect the value of R to be?
Excel formula: 0.98615415 =SQRT (0.9725) 0.98615415 = (0.9725)^0.5