Q. 6 From the Bureau of Economic Analysis Web page (www.bea.gov ), compare real GDP for1970, 1980, 1990, 2000, and 2010.

Calculate the percentages of GDP spent on consumption (C), investment (I), government (G), exports (X), and imports (M).Do the percentagesdiffer significantly among those years? Are there changes in the balance of trade over the period? Explain.Include the appropriate table of values used to arrive at your answer.

Please share the actual table constructed in Excel.