Excel File: https://docs.google.com/spreadsheets/d/1-Gp0kcPhwR6159V2m-ZWR24ry49PazFy/edit?usp=sharing&ouid=111846680843393654433&rtpof=true&sd=true

(%) [EE | Suppose you are trying to explain variations in salaries for technicians in a particular field of work. The file P11_66.xIsx contains annual salaries for 200 technicians. It also shows how many years of experience each technician has, as well as his or her education level. There are four education levels, as explained in the comment in cell D1. Three suggestions are put forth for the relationship between Salary and these two explanatory variables: e You should regress Salary linearly versus the two given variables, Experience and Education. e All that really matters in terms of education is whether the person got a college degree or not. Therefore, you should regress Salary linearly versus Experience and a dummy variable indicating whether he or she got a college degree. e Each level of education might result in different jumps in salary. Therefore, you should regress Salary linearly versus Experience and dummy variables for the different education levels. a. Run the indicated regressions for each of these three suggestions. If required, round your answers to one decimal place. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Equation 1: Salary = 19341.37 \\'.') + 1978.8 \\'9 Experience + 9045.7 \\'.') Education Equation 2: Salary = 30659.164 0 + 1633.055 0 Experience + 13969.622 0 College Equation 3: Salary = 28885.903 \\:') + 2013.64 \\'.0 Experience + -5682.81 0 Education2 + 12463.9 0 Education3 + 20439.5 0 Education4