Unemployment Rate

Complete Problem 5.29 of Chapter 5 and submit to your instructor. Complete your assignment in Excel and submit your completed Excel workbook to your Instructor for grading. 5.29. Refer to Example 5.6 in the chapter. It was shown that the percentage change in the index of hourly earnings and the unemployment rate from 1958-1969 followed the traditional Phillips curve model. An updated version of the data, from 1965-2007, can be found in Table 5-19 on the textbook’s Web site. Create a scattergram using the percentage change in hourly earnings as the Y variable and the unemployment rate as the X variable. Does the graph appear linear?  Now create a scattergram as above, but use 1/X as the independent variable. Does this seem better than the graph in part (a)? Fit Eq. (5.29) to the new data. Does this model seem to fit well? Also, create a regular linear (LIV) model as in Eq. (5.30). Which model is better? Why? For more information on Unemployment Rate read this: https://en.wikipedia.org/wiki/Unemployment

Don't use plagiarized sources. Get Your Custom Essay on
Unemployment Rate
Just from \$13/Page
275 words
Total price: \$0.00

Top-quality papers guaranteed

100% original papers

We sell only unique pieces of writing completed according to your demands.

Confidential service

We use security encryption to keep your personal data protected.

Money-back guarantee

We can give your money back if something goes wrong with your order.

Get free features with our reliable essay writing service

1. Title page

We offer you a free title page tailored according to the specifics of your particular style.

2. Custom formatting

Include your preferred formatting style when you order from us to accompany your paper.

3. Bibliography page

Get a list of references to go with your ordered paper.

Type of paper