2. There are three variables: Wage (hourly), Education (number of years completed in school), Experience (number of years in a full-time job). Wage is the dependent variable in all these regressions. 3. Now run the following regressions: Regression 1A: Education is the only independent variable. Intercept = 0. Regression 1B: Experience is the only independent variable. Intercept = 0. Regression 1C: Education is the only independent variable. Intercept is not 0. Regression 1D: Experience is the only independent variable. Intercept is not 0. Regression 2A: Both education and experience are the independent variables. Intercept = 0. Regression 2B: Both education and experience are the independent variables. Intercept is not 0. 4. Now assume that the first 125 data points (row 2 to row 126) correspond to sample from rural areas, and the last 125 data points are from the urban areas. Now run the following regressions: Rerun the regressions 2A and 2B separately for rural and urban areas. (total 4 regressions in this part) 5. Now create one dummy variable; the value of the dummy variable should be 1 for the urban rows and 0 for the rural rows. Regression 3: Three independent variables (education, experience, and the dummy variable for rural/urban). Intercept = 0. Regression 4: Three independent variables (education, experience, and dummy variable for rural/urban). Intercept is not 0. Note: Read the instructions thoroughly. Follow the instructions. Complete all the steps, all the regressions. Run these regressions using only MS Excel. Keep the regression outputs (results) on the Excel as it is. Only MS Excel file is accepted. There are total 12 regressions in this exercise. Your score depends on the correctness and completeness of this assignment. \f\f\f\f\f\f\f