I used scatter plot graph in the insert graph function of excel and added a trend line that shows the equation of the line of best fit and the r.
The line that can be applied in this function is linear with an equation of y = 3800.6x - 5223.6 and the regression is r² = 0.8925. The y intercept represents when the starting point of a line starts. It is a strong correlation since the value of r² that is equal to 0.8925 is close to 1. We can solve the value of the investment after 6 years using the equation above.
y = 3800.6x - 5223.6 y = 3800.6(6) - 5223.6 y = 17,580
