The file S02 03 xlsx contains data from a survey of 399
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?

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help