Question: 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

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

Step by Step Solution

★★★★★

3.26 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Customer Recency Frequency Monetary Receive Catalog Receive Postcard Receive EMail Campaign 1 Receive EMail Campaign 2 Catalog Purchase Online Purchase 1 0003 Mo 8x 100 199 Y Y Y Y Y Y 2 0003 Mo 57x 0... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1209_60bca5b64c6ff_564932.pdf

180 KBs PDF File

1209-M-S-D-A(8961).xlsx

300 KBs Excel File

1209_60bca5b64c6ff_564932.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

A sociologist surveys a sample of college students to determine whether there are differences in the attitudes and behaviors of male and female students. The survey contains 20 questions. For one...

A company that sells sunscreen products wants to know whether there is a relationship between people's hair colour and their tendency to apply sunscreen before going outside. For example, it may be...

A company that sells its products through mail-order catalogs wants information about the success of its most recent catalog. The company decides to estimate the mean dollar amount of items ordered...

A company that sells products through mail-order catalogs wants to evaluate whether the mean sales for their most recent catalog were different from the mean of $15 from past catalogs. For a random...

A large online retailer has set up a private web space to sell to its customers that are businesses. These transactions are generally conducted through negotiated contracts. How does the company use...

MKT500 Discussion Board 9 "Trending Now" The lectures that correspond to the topic is attached for your information. Thank You MKT500 Discussion Board 9 \"Trending Now\" Marketing Research Response...

Joumal3.pdt - Adobe Acrobat Reader DC (64-bit) File Edit View Sign Window Help Home Tools Journal3.pdf Q 17C Mostly sunny 1 / 7 O + 75% F Impact of digital marketing development on entrepreneurship...

Could the Clubcard concept be expanded to better use the rich mine of information Tesco has about where, when and what customers buy? Keeping ethical concerns in mind, how could the Clubcard program...

I would like to get detail answers to the questions using Staples Inc. 10-K report for the fiscal year ending January 30,2015 and filed with the security exchange commission on March 4, 2016. please...

Financial Statement Analysis Obtain a copy of the 2009 annual report for a publicly held firm. Try to obtain an annual report for a retail or manufacturing firm. Be sure that the financial statement...

Does the DR Congo-China venture make economic integration sense? Explain.

Determine a scalar equation for the plane through the points M(1, 2, 3) and N(3,2, -1) that is perpendicular to the plane with equation 3x + 2y + 6z + 1 = 0. [4]

Mills Corporation acquired as an investment $ 2 4 0 million of 6 % bonds, dated July 1 , on July 1 , 2 0 2 7 . Company management is holding the bonds in its trading portfolio. The market interest...

Holzhauer corporation, a merchandising company, reported the following results for march. Cost of goods sold is a variable cost in this company. The contribution margin for march is? Number of units...

Gaseous butane (CH,(CH) CH, reacts with gaseous oxygen gas (o, to produce gaseous carbon dioxide (CO,) and gaseous water (H,O), what is the theoretical yield of carbon dioxide formed from the...

Consider the following regression estimates (FN2) Linear regression wage C. 5 O d. 3 Robust Coef. Std. Err. belavg -1.063254 .3047845 abvavg .0693348 .3150202 female -2.751963 .2820787 married...

Classifying samples Emmanuel (a) A consultant wants to ask workers at a factory about the workers' job satisfaction. Which of the following best describes a random sample of workers? O The consultant...

Ron is the project manager of a pharmaceutical company that develops multiple products to help fight diseases affecting children. There are currently two new drugs that the company is planning to...

The file P02_05.xlsx contains monthly values of the Dow Jones Industrial Average from 1950 until recently. It also contains the percentage changes from month to month. (This file is used in an...

The file P02_04.xlsx contains salary data on all Major League Baseball players for each year from 2012 to 2018. For any three selected years, create a table of counts of the various positions,...

The file P02_02.xlsx contains information on 256 movies that grossed at least $1 million in 2017. Rank Movie Release Date Distributor Recoded Distributor Genre Recoded Genre MPAA 2017 Gross Tickets...

Answer each independent question, (a) through (e) below a. Project A costs $5,000 and will generate annual after-tax net cash inflows of $2,000 for 5 years. What is the payback period for this...

question 18-1 Which one of the following statements regarding time-series methods is FALSE? Select one: a. In an exponential smoothing model a larger value for alpha results in greater emphasis being...

650-Q2 You are trying to take a sample from a large population, and need to determine the appropriate sample size. You are estimating sales at a large chain of department stores. A previous survey...