Steps:
Download the starting file from the Assignment Dropbox and save it on your computer. Then open it to work on it.
Switch to the GDP Data worksheet. Use formulas with cell references to complete these steps.
(newest minus oldest)/newest
Note: Your data on this worksheet should now match the data shown in Figure 1 below.
[in Billions of dollars]
INDUSTRY SEGMENT | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | % Change | Trends |
Agriculture, forestry, fishing, and hunting | 374.7 | 340.4 | 368.8 | 432.5 | 452.6 | 488.5 | 500.9 | 455.7 | 428.2 | 435.8 | ||
Mining | 614 | 404 | 499.3 | 601.2 | 613 | 662.9 | 743.8 | 492.9 | 382 | 487.9 | ||
Utilities | 524.9 | 436.5 | 494.5 | 484.9 | 461.5 | 491.7 | 537.7 | 514.2 | 477.3 | 489.6 | ||
Construction | 1275.8 | 1099 | 1016.7 | 1020.5 | 1074.6 | 1155.7 | 1261.1 | 1376.4 | 1478 | 1534.7 | ||
Manufacturing | 5493.7 | 4511.1 | 5019.1 | 5592.9 | 5771.3 | 5939.3 | 6039.6 | 5714.7 | 5573 | 5889.5 | ||
Durable goods | 2687.1 | 2152.1 | 2382.5 | 2599.1 | 2699.7 | 2789.6 | 2905.9 | 2900.3 | 2836.3 | 3004.5 | ||
Nondurable goods | 2806.7 | 2359 | 2636.6 | 2993.7 | 3071.6 | 3149.8 | 3133.6 | 2814.3 | 2736.7 | 2885 | ||
Wholesale trade | 1327.1 | 1154.8 | 1359.2 | 1530.8 | 1655 | 1734.8 | 1814.4 | 1829.6 | 1817.7 | 1928.1 | ||
Retail trade | 1277.2 | 1207.7 | 1299.7 | 1335.9 | 1403.5 | 1480 | 1550.7 | 1648.6 | 1720.5 | 1792.5 | ||
Transportation and warehousing | 906.8 | 782 | 856.3 | 954.2 | 1002 | 1036.8 | 1105 | 1111.7 | 1104.1 | 1155.5 | ||
Information | 1254.9 | 1219.7 | 1268.9 | 1324.8 | 1382.5 | 1437.3 | 1510.1 | 1570 | 1659.3 | 1738.4 | ||
Finance, insurance, real estate | 4653.3 | 4472.7 | 4587.5 | 4736.4 | 5036.8 | 5305.3 | 5635.5 | 5911.7 | 6200.9 | 6556.3 | ||
Real estate and rental and leasing | 2660.6 | 2602.2 | 2679.3 | 2767.5 | 2896.2 | 3034.6 | 3208.1 | 3379.2 | 3573.2 | 3752.9 | ||
Professional and business services | 2739.2 | 2593.6 | 2712.2 | 2868.6 | 3009 | 3095.1 | 3280.6 | 3421.2 | 3593.2 | 3796.6 | ||
Management of companies and enterprises | 432.6 | 400.2 | 422.2 | 446.5 | 478.8 | 499 | 514 | 525.4 | 535.5 | 548.9 | ||
Educational services | 257.3 | 273.5 | 292.9 | 306.4 | 309.4 | 319.8 | 330.8 | 341.3 | 349 | 357.3 | ||
Health care and social assistance | 1641.3 | 1724.1 | 1798 | 1867.2 | 1956 | 1993.9 | 2070 | 2189.2 | 2307.1 | 2424.1 | ||
Arts, entertainment, and recreation | 247.5 | 244.1 | 245.9 | 252.1 | 264.5 | 274.1 | 288.4 | 305.3 | 320.2 | 340.4 | ||
Accommodation and food services | 730.9 | 711.1 | 733.3 | 777.9 | 828.9 | 865.3 | 924.8 | 991.8 | 1043.4 | 1071.5 | ||
Other services, except government | 550.5 | 521.6 | 535 | 548.9 | 576.3 | 584.5 | 620.8 | 641.8 | 674.4 | 697 | ||
TOTALS | ||||||||||||
AVERAGES | ||||||||||||
Source: Bureau of Economic Analysis |