# Question: 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?

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?

**View Solution:**## Answer to relevant Questions

The file S02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. Use filters for each of the following.a. Identify all employees who are male and have exactly 4 years of post-secondary ...The file S02_39.xlsx contains SAT test scores (two verbal components, a mathematical component, and the sum of these three) for each state and Washington DC in 2009. It also lists the percentage of high school graduates ...Recall that the file Baseball Salaries 2009.xlsx contains data on 818 MLB players as of May 2009. Using this data set, answer the following questions:a. Find the mean and median of the salaries of all shortstops. Are any of ...A mean, as defined in this chapter, is a pretty simple concept—it is the average of a set of numbers. But even this simple concept can cause confusion if you aren’t careful. The data in Table are typical of data ...The file S02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. Use StatTools to find the mean, median, and standard deviation of Annual Salary, broken down by each of the following ...Post your question