Describe and construct a matrix in excel

Assignment Help Finance Basics
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.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Ow do you think stock prices will change on dividend payment

In an efficient market, ignoring taxes and transaction costs, how do you think stock prices will change on dividend payment dates?

  Set up the accompanying proclamations

Gauge the outer trusts prerequisite for the year 20x8.Set up the accompanying proclamations, accepting that the outer trusts necessity would be raised altogether from transient bank borrowings :(i) anticipated monetary record and (ii) anticipated ben..

  Explain the logic behind the establishment of gold standard

Why would a multinational be willing to issue a bond in a foreign country and what would be the motivation?  How can they attempt to minimize their risk is they do issue these bonds?

  Computation the expected amount of disposable income

Computation the expected amount of disposable income of project and what is the expected amount of disposable income the landlord will have facing this risky situation? Is this a fair gamble.

  Describe the public nature of the issue

Statement of the Problem: Describe the public nature of the issue or problem addressed by your request. Justify your case through measures of need or demand for services provided through the program, illustrated delivery gaps among for profit, non..

  What is the cost of equity based on the dcf approach

Assume that you are a consultant to Morton Inc., and you have been provided with the following data: D1 = $1.00; P0 = $25.00; and g = 6% (constant). What is the cost of equity based on the DCF approach?

  Compute value of the store

You are trying to assess the value of a small retail store that is up for sale. The store generated cash flow to it owner of $100,000 in the most profitable year of operation and is expected to have growth of about 5 percent a year in perpetuity.

  Determining best evaluation of company-s cost of equity

If stock sells for $39 per share, Determine your best evaluate of company’s cost of equity? Answer in a %.

  We want simple ladder diagram for asphalt plants and

we want simple ladder diagram for asphalt plants and concrete mixers for full automatic operation it is always used

  Evaluate your organizationrsquos financial performance

evaluate your organizationrsquos financial performance during the past 2 years using financial ratios. calculate the

  Basic premise of decision rule

What is net present value (NPV), how is it calculated, and what is the basic premise of its decision rule? What is the internal rate of return (IRR), how is it calculated, and what is the basic premise of its decision rule?

  Brushy mountain mining companys coal reserves are being

brushy mountain mining companys coal reserves are being depleted so its sales are falling. also environmental costs

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd