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.
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

Solution Preview

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


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.