Reference no: EM131025331

Homework #1

1.
a. Using Excel, replicate the following table, then calculate the missing values using an Excel formula (this is obviously easy to do by hand, the point is to start with an easy assignment in order to build your skills for use on harder tasks later). The following data comes from the Bureau of Economic Analysis. All numbers are reported in billions of U.S. dollars.

Year	Nominal GDP	Consumption	Gross Investment	Government Purchases of Goods and Services	Net Exports
1929		77.5	16.5	9.4	0.4
1933	56.4	45.9		8.7	0.1
1941	126.7		18.1	26.6	1
1945	223		10.8	93.2	-0.9
1947		162.3	35	36.4	10.8
1973	1385.5	852.5	244.5		0.6
2000	9872.9	6728.4	1767.5	1741

b. Using the same spreadsheet, calculate for each year the following statistics (while doing this, you should write the Excel formula for one year, then copy and paste the formula into the corresponding cells for each subsequent years). Your output should follow the format suggested in the table below where C/Y is consumption as a percentage of nominal GDP, I/Y is Gross Investment as a percentage of nominal GDP, B/Y is Government Purchases as a percentage of nominal GDP, and NE/Y is Net Exports as a percentage of nominal GDP.

Year	C/Y in % terms	I/Y in % terms	G/Y in % terms	NE/Y in % terms
1929
...

2. Using the data below (also computed by the Bureau of Economic Analysis) and the information from question 1, use a same spreadsheet to calculate the following items.

a. Fill in the table below: (Note: CAGR is explained and guidelines for this calculation are given in part (b) of this question.)

Year	GDP Deflator	Real GDP (in billions)	CAGR over period
1947	15.5
1973	31.3
2000	100

b. Over the periods 1947-1973 and 1973-2000, calculate the "Cumulative Annual Growth Rate" of the economy. Hint: use the following formula:
CAGR = (ending value/beginning value)^(1/# of yrs) -1.
(A carrot, "^", means exponent in Excel).

c. Why might we want to calculate the economy's growth rate in this way?

d. Some economists argue that the growth rate of the U.S. economy slowed down after the "Oil Shock" of 1973? Do you see evidence of this? Explain.

3.
A common source for data on labor statistics (such as unemployment as well as much more detailed statistics) is the Bureau of Labor Statistics. Go to their website, www.bls.gov, and follow these instructions to retrieve the necessary data to answer the questions below. Instructions: 1. Click on the link "Get Detailed Statistics" from the main page. 2. Click on the blue box under "Most Requested Statistics" and to the right of "Labor Force Statistics from the Current Population Survey". Finally, check the boxes of interest to retrieve the corresponding data.

a. From the data you find at the above address, fill in the following table using Excel to calculate the average unemployment rate for the year.

Overall Unemployment Rate (%)

2000	2001	20002	2003	2004	2005	2006

b. Now, using Excel plot the data you found in part (a) to get a graph displaying the U.S. unemployment rate from 200 through 2006 with the unemployment rate in percentage terms on the y-axis and time on the x-axis.

c. For December 2006, which group experienced a higher unemployment rate, men over 20 years old or women over 20 years old?

d. What was the average annual unemployment rate in 2006 for college educated people, 25 years and older?

e. What was the average annual unemployment rate in 2006 for individuals 25 and older with less than a high school education? Compare to part d.