spreadsheet moduling

OPRE 6332: Homework 1 Consider the data set we use to analyze the Chilean college admissions case. I added one more sheet that contains demographics for each student, including: DOB: date of birth Family size: number of people that live with the student . How many in your family work: number of people that work within the family Income level: categorical variable representing monthly income, as detailed in the next table: Category From To 350 2 350 1045 3 1045 1750 14 1750 2450 5 2450 3125 6 3125 more Level education father/mother: categorical variable representing the maximum level of education attained by the parents, as detailed in the next table: Category Highest Level of Education 0 No data No education 2 Elementary incomplete 3 Elementary complete 4 Hish-school incomplete 5 High-school complete 6 Technical school incomplete 7 Technical school complete 8 University incomplete 9 University complete 10 Other Descriptive/ Diagnostic Analysis 1. Separate the Demographics data in columns. 2. Create a Table for Demographics. 3. Filter observations in Demographics for which the information is incomplete or wrong (describe what filters you apply and why you think it is correct)