Question

47. Recall that HyTex Company is a direct marketer of technical products and that the file Catalog Marketing.xlsx contains recent data on 1000 HyTex customers.

a) Identify all customers in the data set 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.
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 data set? If so, how many?
c) Identify all customers in the sample who are more than 30 years of age, 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.
d) Do any of the customers who satisfy the conditions stated in part c have salaries that fall in the top 10% of all 1000 combined salaries in the data set? If so, how many?

Figure 2.35 HyTex Customer Data 1 PersonAge Gender Own Home Married Close Salary Children History Catalogs RegionState 1$16,400 0 $108,100 1$97,300 1$26,800 1$11,200 1$42,800 1$34,700 0 $80,000 1$60,300 0 $62,300 First Purchase Amount Spent 12 South Florida Orlando 10/23/2011 $218 $2,632 18 Midwest Illinois 5/25/2009 1 NA 12 South Florida Orlando 8/18/2015 $3,048 $435 Ohio Cleveland 12/26/2012 12 East 0NA 6 Midwest Ilinois 8/4/2015 $106 0 $759 $1,615 Phoenix 3/4/2013 02 12 West Arizona 18 Midwest Kansas Kansas City 6/11/2015 0 DI NA 6 West California 8/17/2009 $1,985 0 3 San Francisco 0NA 5/29/2015 10 24 Midwest llinois $2,091 Orlando 6/9/2011 $2,644 1110 24 South Florida

Answer 1

Ovon Wune (61400 51, 3oo 1手55,900 41 n trn bitb

nc for AVERAGfCo3:04) Qmon На

6300 30400 and ava 495 30406 od .ro

1000 om