Share
Explore BrainMass

Least Squares Trend in Annual Glass Production

The following table lists the annual amounts of glass cullet produced by Kimble Glass Works, Inc.

Year Code Scrap (tons)
1999 1 2.0
2000 2 4.0
2001 3 3.0
2002 4 5.0
2003 5 6.0

Determine the least squares trend equation. Estimate the amount of scrap for the year 2005.

Solution Summary

Solution attaches an Excel spreadsheet and Word document carrying the explained least squares trends of some given glass production data.

$2.19