Write- up # 12

for

Jenni McIntire and Teresa Davis

Problem 3 in assignment 12

This problem looks at the data from the lumber industry on the approximate number of board feet of lumber per tree in a forest given the age of the tree.

Tree Data

Age of Tree

100s of Board Feet

20

1

40

6

60

80

33

100

56

120

88

140

160

182

180

200

320

Using Excel, we plot the data on a chart to see the type of curve represented.

Looking at this chart, the data seems to be quadratic in nature. Using the table below, we were able to arrive at the equation .

Age of Tree

100s of Board Feet

Calculated Data

20

1

0.04

40

6

3.24

60

14.44

80

33

33.64

100

56

60.84

120

88

96.04

140

139.24

160

182

190.44

180

249.64

200

320

316.84

We can plot the original data with the prediction curve.

Now using the prediction curve, we can estimate how many 100s of board feet we should expect with any age of tree.

Age of Tree Estimated Board Feet
220 392.04
250 519.84
300 772.84

Return