Reference no: EM131025087
Homework #1
Homework will be graded for both content and neatness. This homework requires the use of Microsoft Excel.
1) The following table is taken from the Bureau of Economic Analysis data release on quarterly GDP from 1/30/2008.
| Figures in Billions of Dollars |
2007-I |
2007-II |
2007-III |
2007-IV |
| Gross domestic product |
|
|
|
|
| Personal consumption expenditures |
|
9674 |
9785.7 |
9928 |
| Durable goods |
1074 |
1074.7 |
1081.6 |
|
| Nondurable goods |
2759.4 |
2822.7 |
|
2903.7 |
| Services |
5707.1 |
|
5857.8 |
5936.3 |
| Gross private domestic investment |
|
2139.1 |
2162.9 |
2109.8 |
| Fixed investment |
2118.9 |
2133.9 |
2127.5 |
2118.3 |
| Nonresidential |
1431.4 |
1469.1 |
|
1532.1 |
| Residential |
687.5 |
|
627.3 |
586.2 |
| Change in private inventories |
-1.6 |
5.1 |
35.4 |
|
| Net exports of goods and services |
|
-714.2 |
-694.7 |
|
| Exports |
1549.9 |
|
1685.7 |
1727.1 |
| Imports |
2264 |
2312.9 |
|
2454.6 |
| Government expenditures |
|
2670 |
2716.5 |
|
| Federal |
946.6 |
|
990.3 |
997.1 |
| State and local |
1661.7 |
1700.5 |
|
1773.6 |
a) Fill in all the blanks in the table. (While this can be done by hand, you will find it easier to use Excel). Don't forget to calculate GDP.
b) In their release, the BEA points out that their GDP data is "seasonally adjusted at annual rates". Why is it important to seasonally adjust quarterly data? What patterns might emerge in US quarterly GDP data if it is not seasonally adjusted?
2) Consider the following table of data for an economy.
| Year |
1960 |
1970 |
1980 |
1990 |
2000 |
| GDP |
220 |
228 |
236.595 |
245.8179 |
255.7045 |
| C |
125 |
131.25 |
137.8125 |
144.7031 |
151.9383 |
| I |
20 |
22 |
24.2 |
26.62 |
29.282 |
| G |
50 |
51 |
52.02 |
53.0604 |
54.12161 |
| NX |
25 |
23.75 |
22.5625 |
21.43438 |
20.36266 |
a) Using Excel, calculate the growth rates of GDP, C, I, G, and NX and present them in a table such as the one below. Put the growth rates in percentage terms.
b) Now that we have the growth rates for all variables, approximate the growth rates for the share of each variable in GDP (C/Y, I/Y, G/Y, and NX/Y) using the technique discussed in class and in Mankiw. Present your answers in a table as below.
c) To check the accuracy of these approximations, compute the actual share of each variable in GDP and find the actual growth rates. Present your answers in a table as below. Put the growth rates in percentage terms.
|
1960 |
1970 |
1980 |
1990 |
2000 |
| GDP growth |
------------- |
|
|
|
|
| C growth |
------------- |
|
|
|
|
| I growth |
------------- |
|
|
|
|
| G growth |
------------- |
|
|
|
|
| NX growth |
------------- |
|
|
|
|
d) How do the approximations compare to the actual growth rates? Are the approximations consistently higher or lower than the actual rates? Does this depend on the variable in question? Why might this be?
3) An economy has a Cobb-Douglas production function given by Y = AK0.6L0.4, where A is the technology level, K is the capital stock, L is the size of the labor force, and Y is GDP. Use this equation to answer the questions below.
A K L GDP (A=4, K=10)
4 10 1
4 10 2
a) Assume that A is fixed at 4 and K is fixed at 10. Make a table where L ranges from 1 to 10 and compute GDP for each of these values of L. Your table should have each variable as a column, as illustrated below:
b) Using Excel, make a line graph with GDP on the vertical axis and L on the horizontal. Use the data in the table from a).
c) Now assume that the technology level increases, so A = 6, but K remains fixed at 10. Recalculate GDP as labor ranges from 1 to 10, and report your results in a table similar to the one above. You should change your GDP variable name to "GDP (A=6, K=10)".
d) Now keep A=4, but assume that the capital stock increases, so K = 15. Recalculate GDP as labor ranges from 1 to 10, and report your results in a table similar to the one above. You should change your GDP variable name to "GDP (A=4, K=15)".
e) Graph all three GDP calculations [(A=4, K=10), (A=6, K=10), and (A=4, K=15)] on the same graph with GDP on the vertical axis and labor on the horizontal. Make sure your graph has labels so that it is clear which line corresponds to each measure of GDP.
f) When we changed the value of A and K, we increased each by 50%. However, as our tables and graphs show, GDP increased more when we increased A by 50% than when we increased K by 50%. Looking at the Cobb-Douglas production function, why is this true? You may give either an intuitive or mathematical answer.