Usual Hours Worked Education (yrs) Yearly Earnings Race 40 13 44000 White 35 12 12000 White 70 11 54000 White 40 16 48200 White 38 12 24000 White 60

Use the data from Wages in Southern States to answer:

1. Is there a relationship between Salary and Years Education for the entire data set?

2. Is there a relationship between Salary and Years Education for each state in the data set? (Hint:  Pivot table)

3. Which gender earns higher wages?

4.  Your company is looking to build a high tech plant in one of these states.  One of the attributes that your company is looking at is higher education  - Based on this data set, which state would you recommend to your company?  Why?  How did you come to that conclusion?

Explain your answers and the tools that you used to organize and analyze the data. You will need to include charts (regression) and tables in your response.