The "Economic Report to the President of the United States" included data on the amounts of manufacturers' new and unlled orders in millions of dollars. Shown here are the gures for new orders over a 21-year period.

Use the charting tool in Excel to develop a regression model to t the trend effects for the data. Use a linear model and then try a polynomial (order 2) model. Make sure the charts show the line formula and the r-squared value. Include both charts in your report. Then, answer the following question:

How well does either model t the data? Which model should be used for forecasting?Explain using the relevant metrics.