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 sample who are 55 years of age or younger, female, single, and who have had at least some dealings with HyTex before this year. Find the average number of catalogs sent to these customers and the average amount spent by these customers this year. How strongly correlated are the numbers of catalogs sent and the amounts spent on HyTex purchases for these customers?

b. Do any of the customers who satisfy the conditions stated in part a have salaries that fall in the bottom 10% of all 1000 combined salaries in the sample? If so, how many?

¢. Identify all customers in the sample who are more than 30 years of age or younger, male, homeowners, married, and who have had little if any dealings with HyTex before this year. Find the average combined household salary and the average amount spent by these customers this year. How strongly correlated are the combined household salaries and the amounts spent on HyTex purchases for these customers? 

d. Do any of the customers who satisfy the conditions stated in part a have salaries that fall in the top 10% of all 1000 combined salaries in the sample? If so, how many?