LP (Louisiana Pacific) makes OSB (Oriented Strand Board) in Sagola, MI. OSB is made by gluing wood chips together to form panels. Several panels are then bonded together to form a board. One of the factors influencing the strength of the final board is the amount of glue used in the production process. LP Sagola conducted a test to determine the breaking point of a board based on the amount of glue used in the production process. In each test, a board was manufactured using the given amount of glue. Weight was then applied to determine the point at which the board would fail (or break). This test was performed 27 times using various amounts of glue. The data obtained from the testing can be found in the LP Sagola OSB.xlsx file.
1. Prepare a scatter plot of this data.
2. Using the Analysis ToolPak, generate the Regression Results.
3. Determine the linear regression model and include it on your scatter plot.
4. Interpret the value of the R2 statistic (include your interpretation in a text box).
5. Suppose LP Sagola wants to manufacture OSB that will withstand up to 110 lbs. of pressure per square inch. How much glue should be used? Use Excel to calculate.
Excel File:
Glue Breaking Point
3.0 72.7
3.0 73.8
3.0 76.8
3.5 73.5
3.5 76.5
3.5 78.1
4.0 78.7
4.0 82.1
4.0 81.9
4.5 85.5
4.5 89.8
4.5 87.3
5.0 95.1
5.0 98.6
5.0 101.9
5.5 108.5
5.5 105.7
5.5 109.4
6.0 110
6.0 112.3
6.0 114.1
6.5 113.8
6.5 116.9
6.5 114.2
7.0 118.7
7.0 117.2
7.0 115.7