This part of the assignment is meant to bring the concepts that you have learned to the real world of data. It will also allow you to work on excel which for some government positions is still a required skill.
- Open hh.xls, which consists of household-level variables. Answer the following questions in the excel file.
Note: I need to see the formula you used and not only a number.
i: How many variables are there? __
ii: How many observations (households) are there? __
- There are four regions. Household characteristics may vary by region. Create and fill the following table in the excel file (Hint: you need to use an excel command with an if condition).
Note: I need to see the formula in excel and not only the result. Note that in the data Chittagong is written chittagon and Rajshahi ragfhahi.
- Which of these four regions in your opinion has the largest deprivation in terms of sanitation (toilets)? Explain?