[Excel Problem] Download quarterly, seasonal adjusted data on US real GDP, personal consumption…

[Excel Problem] Download quarterly, seasonal adjusted data on US real GDP, personal consumption expenditures, and gross private domestic investment for the period 1960Q1-2016Q2. You can find these data in the BEA NIPA Table 1.1.6, “Real Gross Domestic Product, Chained Dollars”. (a) Take the natural logarithm of each series (“=ln(series)”) and plot each against time. Which series appears to move around the most? Which series appears to move the least? (b) The growth rate of a random variable x, between dates t _ 1 and t is defined as Calculate the growth rate of each of the
» [Excel Problem] Download quarterly, seasonal adjusted data on US real GDP, personal consumption expenditures, and gross private domestic investment for the period 1960Q1-2016Q2. You can find these data in the BEA NIPA Table 1.1.6, “Real Gross Domestic Product, Chained Dollars”. (a) Take the natural logarithm of each series (“=ln(series)”) and plot each against time. Which series appears to move around the most? Which series appears to move the least? (b) The growth rate of a random variable x, between dates t _ 1 and t is defined as Calculate the growth rate of each of the three series (using the raw series, not the logged series) and write down the average growth rate of each series over the entire sample period. Are the average growth rates of each series approximately the same? (c) In Appendix A we show that that the first difference of the log is approximately equal to the growth rate: Compute the approximate growth rate of each series this way. Comment on the quality of the approximation. (d) The standard deviation of a series of random variables is a measure of how much the variable jumps around about its mean (“=stdev(series)”). Take the time series standard deviations of the growth rates of the three series mentioned above and rank them in terms of magnitude. (e) The National Bureau of Economic Research (NBER) declares business cycle peaks and troughs (i.e. recessions and expansions) through a subjective assessment of overall economic conditions. A popular definition of a recession (not the one used by the NBER) is a period of time in which real GDP declines for at least two consecutive quarters. Use this consecutive quarter decline definition to come up with your own recession dates for the entire post-war period. Compare the dates to those given by the NBER. (f) The most recent recession is dated by the NBER to have begun in the fourth quarter of 2007, and officially ended after the second quarter of 2009, though the recovery in the last three years has been weak. Compute the average growth rate of real GDP for the period 2003Q1–2007Q3. Compute a counterfactual time path of the level of real GDP if it had grown at that rate over the period 2007Q4-2010Q2. Visually compare that counterfactual time path of GDP, and comment (intelligently) on the cost of the recent recession.

»

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more