Describe and construct a matrix in excel

Assignment Help Mathematics
Reference no: EM131554357

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

Questions Cloud

Appropriate primary keys-foreign keys : Problem 1. Please create the following tables with appropriate primary keys & foreign keys.
Determine the approximate number of american adults : 31% of American adults surveyed stated that giving up their phone for a day would be more difficult than giving up their significant other.
The clients developmental stage factor : Are there considerations that cannot be processed at this time because of lack of information in the written scenario?
Describe the traits you would need to be successful : Finally, if you were in the role of superintendent, describe the traits you would need to be successful. Explain what you would do differently.
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.
Develop three experiential interventions : Develop three experiential interventions that you would use with the Vargas family.
Describe the process for network address translation : Describe the process for Network Address translation. Why was this concept created and what are the main uses?
Roles of core technologies in an effective it system : A short paper describing the roles and significance of each of the five core technologies in the overall system. Discuss their relationships and interdependence
Write a mid-treatment letter to the identified family member : Create a "transcript" of the session where the therapist uses solution-oriented language to identify a solution to the problem.

Reviews

Write a Review

Mathematics Questions & Answers

  Questions on ferris wheel

Prepare a Flexible Budget Gator Divers is a company that provides diving services such as underwater ship repairs to clients in the Tampa Bay area.

  Logistic map

This assignment has two question related to maths. Questions are related to bifurcation cascade and logistic map.

  Finding the probability of cards

This assignment has questions related to probabiltiy.

  Systems of ode

Find all the xed points, and study their stability and Draw the phase portrait of the system, as well as the graphs of the solutions in all relevant cases.

  Derive the boolean expression

Derive the Boolean Expression and construct the switching circuit for the truth table stated

  System of equations

Evaluate which equations are under-identified, just-identified, and over-identified.

  Linear programming problem

Linear programming problem consisting of only two constraints with one objective function.

  Find the natural domain

Find the natural domain of the given functions.

  Introduction to numerical methods

Compute the coecients of the polynomials using the term recurrence relation.

  Chart of the topological manifold

De?nition of smoothness of functions on a smooth manifold is chart independent and hence geometric.

  Mathematics in computing

Questions related on mathematics in computing.

  Complex problems

Complex problems

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