GB 513 Unit 6 Assignment Final Project Colonial Broadcasting Case
12 . 12 3,949.0 13 . 13 4,137.0 Question 3 The “ Economic Report to the President of the United States ” included data on the amounts of manufacturers ’ new and unfilled orders in millions of dollars . Shown here are the figures for new orders over a 21-year period . Use Excel to develop a regression model to fit the trend effects for these data . Use a linear model and then try a quadratic model . How well does either model fit the data ? Year Total Number of New Orders 1 . 1 55,022 2 . 2 55,921 3 . 3 64,1 82 4 . 4 76,003 5 . 5 87,327 6 . 6 85,139 7 . 8 115,109 9 . 9 131,629 10 . 10 147,604 11 . 11 156,359 12 . 12 168,025 13 . 13 162,140 14 . 14 175,451 15 . 15 192,879 16 . 16 195,706 17 . 17 195,204 18 . 18 209,389 19 . 19 227,025 20 . 20 240,758 21 . 21 243,643
===================================================================================
GB 513 Unit 6 Assignment Final Project Colonial Broadcasting Case
FOR MORE CLASSES VISIT www . gb513rank . com