Hourly earnings and unemployment rate

Order Instructions

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?

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.