UMW Create a Pairs Plot that Shows All Two Way Relationships Excel Task
Question Description
Initial Setup: Please read in the attached file “wage-data.csv”
Problems 1-4 will be accounted for in the first graph:
- 1) Create a pairs plot that shows all two-way relationships
- 2) Add trend lines to your plot
- 3) Color the points based on gender (males are one color, females another)
- 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:
- 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.
- 7) Add a nice-looking title and x/y-axis labels
Problems 8-9 will be accounted for in the fourth and final graph:
- 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.
- 9) Add a nice-looking title and x/y-axis labels
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."