assignment

Part 2 The videa How to create a Regression Line with Excel 2 will help with this part of the project. One can determine how old a free is by counting its rings, but that Recaires cuding the tree down. A forester wanted to investigate whether or not the age of a tree car be estimated simply from its diameter so they measured 27 trees of the same species that had acer car down, and counted the rings to notarming the ages of the treas The following are the data collected. Dialeder Any ir Diameter |Age in Diamotor Age 19 in inches Clameter ARE In in Inches in inches in inches Years 12 29 11.5 134 3.E 5 4.9 25 11.7 35 7.6 14 9.8 28 11.7 5.0 H 7.6 16 10.6 117 6.1 35 12 5 10 910 10.1 42 6.1 10 11.5 1. Create a scelleplat Age is the require veriable ly-axial . Diameter is the explanatory variable : x-exist . Please make sure you proph s khaled appropriately. 2. Create a Best Fit Inear mace) that predicts age from the clarater . This needs to be lwe linear ecustion 3. Graph thi Rest Fit linear made on the erie graph as the scatterpinl 4. Fine the linear correlation coeflu ient. r, between the daniele ard age 5. Find the Doctors off determination, R", and as lain wiat it means in the context of this pasalam, You rived to adamss the percent variation in thee response variable due to the explanatory verisple