Your assignment is to analyze the pine tree data for both species.

1) Determine the population means (average) for age and diameter (DBH) of both species

2) Use a t-test to determine if age and diameter are significantly different between the two species. List will require two separate t-test.

3) Preform a regression analysis for the following (fit a line and calculate r squared)

A. White pine age vs height

B. White pine age vs diameter

C. Scotch pine age vs height

D. Scotch pine age vs diameter

3) Determent which, if any parameter (height or diameter) best correlates with tree age for each tree species

You must perform all these analyses in MS Excel

\f\f