One can determine how old a tree is by counting its rings, but that Requires cutting the tree down. A forester wanted to investigate whether or not the age of a tree can be estimated simply from its diameter so they measured 27 trees of the same species that had been cut down, and counted the rings to determine the ages of the trees. The following Excel file contains sample data for each student in the class. You need to use the data that is assigned specifically to you for this assignment:

Diameter (inches): 3.6, 3.8, 6.1, 5.1, 5.7, 7.2, 5.9, 6.7, 6.9, 7.7, 7.2, 8.1, 9.4, 9.0, 9.5, 10.2, 9.5, 10.5, 10.8, 10.6, 11.6, 11.6, 11.3, 11.3, 11.8, 12.4, 14.7

Age (years): 2, 6, 6, 8, 9, 8, 8, 11, 14, 16, 16, 18, 20, 23, 21, 26, 29, 29, 30, 32, 33, 33, 35, 38, 36, 42, 44

Create a scatterplot Age is the response variable (y-axis) Diameter is the explanatory variable ( x-axis). Please make sure your graph is labeled appropriately. Create a Best Fit linear model that predicts age from the diameter This needs to be the linear equation Graph this Best Fit linear model on the same graph as the scatterplot. Explain what the slope of the regression line means in context of this problem. Find the linear correlation coefficient, r, between the diameter and age. Find the coefficient of determination, R2 , and explain what it means in the context of this problem. You need to address the percent variation in the response variable due to the explanatory variable.