The file S02_03.xlsx contains data from a survey of 399 people regarding an environmental policy. Use filters
Question:
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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted: