The file S02_03.xlsx contains data from a survey of 399 people regarding an environmental policy. Use filters for each of the following.
a. Identify all respondents who are female, middle-aged, and have two children. What is the average salary of these respondents?
b. Identify all respondents who are elderly and strongly disagree with the environmental policy.
What is the average salary of these respondents?
c. Identify all respondents who strongly agree with the environmental policy. What proportion of these individuals are young?
d. Identify all respondents who are either
(1) Middle-aged men with at least one child and an annual salary of at least $50,000, or
(2) Middle-aged women with two or fewer children and an annual salary of at least $30,000. What are the mean and median salaries of the respondents who meet these conditions? What proportions of the respondents who satisfy these conditions agree or strongly agree with the environmental policy?