Consider the given survey data collected from 1000 randomly selected Internet users. The data are in the file P4_5.XLS. Use Excel’s auto filter tool to answer the following questions:

a. What proportion of those surveyed are females who are married, employed, and have achieved more than a high school education?

b. What proportion of those surveyed are males who are single, unemployed, and have achieved a high school education or less?

c. Find the average annual income of the females who are married, employed, and have achieved more than a high school education.

d. Find the average annual income of the males who are married, employed, and have achieved more than a high school education. How does this result compare to the average found in part ¢?