Share
Explore BrainMass

Time Series and Forecasting for Kimble Glass

The following table lists the annual amounts of glass cullet produced by Kimble Glass
Works, Inc.
Scrap
Year Code (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 Preview

Let X be the code and let Y be the amount of scrap. We use Excel to get the following regression table.

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9
R Square 0.81
Adjusted R Square 0.746666667
Standard ...

Solution Summary

The solution does forecasting for Kimble Glass.

$2.19