Continuing Problem 4.19 with the data provided in the file P4_7.XLS,‘suppose now that we want to find all of the customers in the given sample who satisfy each of the following conditions: 

a. AmountSpent is at least $1000 greater than the median of AmountSpent for all customers.

b. AmountSpent is more than two standard deviations above the mean of AmountSpent for all customers.

c. Salary is no less than the 90th percentile of salaries for all customers.

Data from in problem 4.19

Recall that the HyTex Company is a direct marketer of stereophonic equipment, personal computers, and other electronic products. The file P4_7.XLS contains recent data on 1000 HyTex customers.

a. Identify all customers in the given sample who are either (1) homeowners between the ages of 31 and 55 who live reasonably close to a shopping area that sells similar merchandise, and who have a combined salary between $40,000 and $90,000 (inclusive) and a history of being a medium- or high-spender at HyTex; or (2) homeowners greater than the age of 55 who live reasonably close to a shopping area that sells similar merchandise, and who have a combined salary between $40,000 and $90,000 (inclusive) and a history of being a medium- or high-spender at HyTex. 

b. Characterize the subset of customers who satisfy the conditions specified above. In particular, what proportion of these customers are women? What proportion of these customers are married? On average, how many children do these customers have? Finally, how many catalogs do these customers typically receive, and how much do they typically spend each year at HyTex?

c. In what ways are the customers who satisfy condition (1) in part a different from those who satisfy condition (2) in part a? Be as specific as possible.