**Only answer G-J, I already did A-F**
2. Measuring the height of a California redwood tree is verydifficult because these trees grow to heights over 300 feet. Peoplefamiliar with these threes understand that the height of aCalifornia redwood tree is related to other characteristics of thetree, including the diameter of the tree at the breast height of aperson (in inches), the thickness of the bark of the tree (ininches), the distance from the closest neighboring tree (in yards),and the number of the other trees neighboring within 10 yards fromthe tree. Using the data set (Redwood.xlsx), conduct a regressionanalysis by answering the following questions.
| Height | | 122.0 | | 193.5 | | 166.5 | | 82.0 | | 133.5 | | 156.0 | | 172.5 | | 81.0 | | 148.0 | | 113.0 | | 84.0 | | 164.0 | | 203.3 | | 174.0 | | 159.0 | | 205.0 | | 223.5 | | 195.0 | | 232.5 | | 190.5 | | 100.0 |
| | Diameter at breast height | | 20 | | 36 | | 18 | | 10 | | 21 | | 29 | | 51 | | 11 | | 26 | | 12 | | 13 | | 40 | | 52 | | 30 | | 22 | | 42 | | 45 | | 54 | | 39 | | 36 | | 8 |
| | Bark thickness | | 1.1 | | 2.8 | | 2.0 | | 1.2 | | 2.0 | | 1.4 | | 1.8 | | 1.1 | | 2.5 | | 1.5 | | 1.4 | | 2.3 | | 2.0 | | 2.5 | | 3.0 | | 2.6 | | 4.3 | | 4.0 | | 2.2 | | 3.5 | | 1.4 |
| | Distance from the closest | | 8.5 | | 8.9 | | 6.1 | | 7.6 | | 0.3 | | 3.3 | | 4.8 | | 3.1 | | 3.6 | | 4.1 | | 9.7 | | 3.5 | | 7.2 | | 5.6 | | 7.4 | | 4.4 | | 0.6 | | 6.5 | | 3.1 | | 0.5 | | 5.1 |
| | Trees within 10 yard | | 3 | | 2 | | 5 | | 1 | | 7 | | 4 | | 2 | | 2 | | 1 | | 2 | | 0 | | 5 | | 3 | | 4 | | 2 | | 1 | | 5 | | 2 | | 1 | | 1 | | 0 |
|
(g) Determine the coefficient of determination, ? 2 , andinterpret its meaning (f) At the level ? = 0.10, is there asignificant relationship between the thickness and the pressure?Answer based on the t test in the p-value approach
(h) Determine the adjusted coefficient of determination,adjusted ? 2 , and interpret its meaning
(i) Evaluate the linearity assumption using the residual plotabout the independent variable for diameter
(j) Evaluate the normality assumption using the normalprobability plot
