A company that sells through a catalog and online through the Web has collected data on 10,000 potential customers. The data are in the file P17_09.xlsx. They include RFM (Recency, frequency, and monetary) variables, which are popular in marketing research, as well as yes/no data on whether the person has received various advertising, and yes/no data on whether the person has made a catalog purchase or an online purchase in the latest time period.

a. Use pivot tables to explore how or whether the Catalog Purchase variable in column I is influenced by the variables in columns B–H.

b. Repeat part a for the Online Purchase variable in column J.c