UMW Create a Pairs Plot that Shows All Two Way Relationships Excel Task

Initial Setup: Please read in the attached file “wage-data.csv”

Problems 1-4 will be accounted for in the first graph:

1. 1) Create a pairs plot that shows all two-way relationships
2. 2) Add trend lines to your plot
3. 3) Color the points based on gender (males are one color, females another)
4. 4) Add a meaningful title

Problem 5 (second graph):
5) Create a lower-triangular correlation plot with ellipses

For problems 6-9, please add a column called “Generation” as follows: If Age ≥ 40, the generationshould be “Older”, otherwise it should be “Younger”. You will use this column to answer the remainingquestions.

Problems 6-7 will be accounted for in the third graph:

1. 6) Create a box plot (created in exactly the same was as a scatter plot) that looks at wage bygeneration (i.e. generation on the x-axis, wage in the y-axis). Color it yellow.
2. 7) Add a nice-looking title and x/y-axis labels

Problems 8-9 will be accounted for in the fourth and final graph:

1. 8) Create a box plot (created in exactly the same was as a scatter plot) that looks at years ofeducation by generation (i.e. generation on the x-axis, wage in the y-axis). Color it blue.
2. 9) Add a nice-looking title and x/y-axis labels