Solve using scatter plots in excel How do I find ln(wage) ?

D1 v iXVf martial A B C wage educ feduc martial 769 12 8 married 825 14 14 married 650 12 12 married 562 11 11 married 600 10 8 notmarrie 1154 15 5 married 1 Group Project 1000 12 11 married 930 18 14 married ECO 4000 1318 16 10 married 1792 16 12 married November 23, 2023 358 10 8 married 13 1360 15 10 married 850 11 8 married Maximum points: 30 15 1615 16 12 married You will use wagedafalse for this project. The excel file includes data and variable description. You are 16 873 12 10 married 2 responsible to submit answers in a hard copy on December 11, 2023 in class. You should 17 2137 16 12 married submit only one copy per group. In the submission, you must include excel outputs and graphs, too. All the answers must be written clearly in an editor of your liking. 18 1053 16 11 married 19 1602 16 16 married Q-1) Create the following plots (5 points) 20 1188 13 8 married 1. wage vs educ (1 point) 21 800 18 8 married 2, In( wage) vs educ. Compare this plot with plot in part 1. Which plot do you think is better for further 1417 17 12 married analyses? Why? (2 points) 23 635 18 16 notmarrie 3. In(wage) vs marital (1 point) 24 1424 14 12 married 25 2668 13 12 married d. In(wage) vs fedue (1 point)