Task 1. Preparing the data for analysis Task 1.1 First of all, in order to focus on the children of schooling age, remove from the provided data set anyone who is either younger than 6 years old or older than 1?. in this assessment, let us concentrate only on the children of the household head because they are the majority of the children in the data set and the number of children of the other household members in the data set are too small to be representative. Therefore, also remove anyone who is not a child of the household head. Hint: You are free to take any approach to do this task, but one relatively straightforward procedure is the foIIOwing: First, create a dummy variable by using the AND function inside the IF function. Then, delete all rows with 0 in the dummy variable by using Custom Sort. [Visit the Microsoft Excel Support website where you can find example of using the AND function inside the IF function, if you are unsure of how to do that} The use of Filter is not recommended, as it does not remove unwanted observations from the data set but only hides them. Note that your reduced data set should contain 1, 238 children. Task 1.2 Second, remove 6 years old children who had not yet started schooling because of their birthday and the timing of the beginning of an academic year. Otherwise, we will overestimate the number of eligible children who did not go to school. Hint: Use the variable "Why not attending school?" where their parents stated that they were "Too young\" to go to school. Again, the use of the AND function inside the IF function will be useful. Note that your further reduced data set should now contain 1,266 children. Task 2. Inspecting the distribution of children The team decides to begin with an inspection of the distribution of children. The team is specifically interested in knowing whether there is any relationship between being out of school and age, and also between being o ut of school a nd sex. Task 2.1 Construct a relative frequency table to observe the distribution ofthe schooling-age children by age, sex and the incidence ofcurrently schooling. Present each relative frequency only up to 3 digits after the decimal point. Hint: First of all, carefully examine the 3 variables "Age\