Describe and construct a matrix in excel

Reference no: EM131057103

Zappos Shoes has decided to launch a reactivation campaign to customers who have lapsed and not purchased in 12 months or longer. They are testing various components of the test including:

Channel of communication: U.S Postal delivery vs email delivery
Offer: 20% discount off the entire order vs. Buy one pair, get a pair free
Reactivation segments: Lifetime purchase level prior to lapse > $250 vs Lifetime purchase level prior to lapse
Messaging: Strong We Want you back message vs. See what is happening at Zappos Now!

The sample size for the test will be 300,000.

Please complete the following steps:

a. Describe and construct a matrix in Excel of what the test would look like if Zappos conducted a Full Factorial Test design. How many names would be in each cell? Paste the matrix below

b. Assume the only two elements which interact are offer and messaging. From your already constructed matrix above, eliminate cells that are not required, leaving the "bare minimum" cells to measure the Channel of communication and the reactivation segments and the offer and messaging. Construct the modified matrix in Excel and paste it below with the new number of names in each cell.

c. Assuming a 5% reactivation rate, calculate a confidence interval under the full factorial, as well as the reduced factorial design (your matrix A and Matrix B above) and discuss the difference in precision or the width of the confidence interval.

Reference no: EM131057103

Questions Cloud

Find the price of call option on stock-use daily compounding : The current price of a stock is $15. In 6 months, the price will be either $19 or $11. The annual risk-free rate is 3%. Find the price of a call option on the stock that has an strike price of $12 and that expires in 6 months. (Hint: Use daily compou..

The difference is statistically significant : LaPorta, Lakonishok, Shleifer, and Vishny (“Good News for Value Stocks,” Journal of Finance, June 1997) study the returns on stocks on the few days surrounding their quarterly earnings announcements (relative to various expected return benchmarks). T..

What the business produces or sells : You may provide information about the business as suggested below plus any other information peculiar to the business you choose. Name (Fonterra Shareholders' fund) and location of the business, the type of business (e.g. retail, manufacturing); Wha..

Determine the blade speedjet speed ratio : Sulzer Hydro Ltd. of Zurich at one time manufactured a six-jet vertical-shaft Pelton wheel turbine with a power rating of 174.4 MW, with a runner diameter of 4.1 m, and an operating speed of 300 rpm with an effective head of 587 m.

Describe and construct a matrix in excel : Zappos Shoes has decided to launch a reactivation campaign to customers who have lapsed and not purchased in 12 months or longer. They are testing various components of the test including:

Management fads come and go-initiatives change : To quote from the Tregoe and Spitzer article, "Management fads come and go, initiatives change, market and economic pressures rise and fall, but cost management must be a way of life". Of the suggestions offered by the author(s), which concepts give ..

Pressure at constant temperature : Derive a relation for ( hint: Maxwell's relations will be helpful) to determine how entropy will change with pressure at constant temperature (δS/δp)t for a gas that behaves according to the following equation of state PV = nRT/a + P/b, where a ..

What is the future value of the annuity : You have $50,000 in your bank account. You plan to save $5,000 at the end of each year for the next 10 years. The interest rate is 8% per annum, compounded monthly. What is the future value of the annuity (ordinary)?

Particular temperature for a solution : The absorbance value at 690 nm at a particular temperature for a solution containing CoCl4 ^2- is 0.744. the concentration of the sln containing CoCl4 ^2- is 0.0105M.

User Account

All Pages