Econometrics problem: Hourly Earnings and Unemployment Rate

The excel document is the data needed for the question and the other 3 uploads are the references to the question in the problem:

Hourly Earnings and Unemployment Rate

Complete Problem 5.29 of Chapter 5.

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.

a. 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?
b. Now create a scattergram as above, but use 1/X as the independent variable. Does this seem better than the graph in part (a)?
c. Fit Eq. (5.29)(which is in the pages of text I have sent you on page 152) to the new data. Does this model seem to fit well? Also create a regular linear (LIV) model as in Eq. (5.30)( which is in the pages of text I have sent you on page 153). Which model is better? Why?

ED-3 Canseco Company has the following data for the weekly payroll ending January 31.
Employee, M. Hindi, E. Benson, K.Estes
Employees are paid 1 1/2 times the regular hourlyrate for all hours worked in excess of 40 hours per week. FICA taxes are 8% on the first $87,900 of gross earnings. Canseco Company is subject to 5.

What is the purpose of using regression analysis? How may it be used to formulate strategies? Provide examples related to strategy formulation and implemenation.
How is regression analysis used in forecasting? Provide examples.

I am employed by HN Construction.
Hourlyrate of $32 with overtime of 1.5 times regular pay rate for all hours more than 40 per week.
Total hours worked:52
Federal Income tax withheld $275
Cumulative earnings prior to the current week: $45,800
Payroll taxes:
FICA Taxes-owed by both Employee and Employer:
Social Security 6

Please help answer the following discussion questions:
What are the three types of unemployment? Unemployment is seen by some as undesirable. Are all three types of unemployment undesirable? Could the advent of the Internet completely eliminate frictional unemployment?

The following information is for the employee Mary Ryan for the week ended March 15.
Total year-to-date earnings as of March 8: $6,400
Total hours worked: 46
Rate: $20 pr hour with double time for all hours in excess of 40
Federal income tax withheld: $180
United fund deduction: $25
Tax rates:
FICA: 7.5%

It has been argued that the exchange rate can be used as a policy tool. Assume that the U.S. government would like to reduce unemployment. Which of the following is an appropriate action given this scenario?
weaken the dollar.
strengthen the dollar.
buy dollars with foreign currency in the foreign exchange marke