User Generated

znunz1

Mathematics

### Description

A company wishes to improve its e-mail marketing process, as measured by an increase in the response rate to e-mail advertisements. The company has decided to study the process by evaluating all combinations of two (2) options of the three (3) key factors: E-Mail Heading (Detailed, Generic); Email Open (No, Yes); and E-Mail Body (Text, HTML). Each of the combinations in the design was repeated on two (2) different occasions. The factors studied and the measured response rates are summarized in the following table.

Write a two to three (2-3) page paper in which you:

1. Use the data shown in the table to conduct a design of experiment (DOE) in order to test cause-and-effect relationships in business processes for the company.
2. Determine the graphical display tool (e.g., Interaction Effects Chart, Scatter Chart, etc.) that you would use to present the results of the DOE that you conducted in Question 1. Provide a rationale for your response.
3. Recommend the main actions that the company could take in order to increase the response rate of its e-mail advertising. Provide a rationale for your response.
4. Propose one (1) overall strategy for developing a process model for this company that will increase the response rate of its e-mail advertising and obtain effective business process. Provide a rationale for your response.

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

• Build regression models for improving business processes.
• Design experiments to test cause-and-effect relationships in business processes.
• Use technology and information resources to research issues in business process improvement.
• Write clearly and concisely about business process improvement using proper writing mechanics.
case2_doe_calculation11_0 (1).xlsx

### Unformatted Attachment Preview

Run 1 2 3 4 5 6 7 8 sum+ sumave + aveeffect Heading (x1) Email Open(x2) Generic(-) No(-) Detailed(+) No(-) Generic(-) Yes(+) Detailed(+) Yes(+) Generic (-) No(-) Detailed(+) No(-) Generic(-) Yes(+) Detailed(+) Yes(+) 163 147,5 40,75 36,875 3,875 179,5 131 44,875 32,75 12,125 Regression Coefficients b0 = 77,625 b1= 1,9375 b2= 6,0625 b3= -13,5625 b4= 3,1875 b5 = -0,6875 b6= -7,3125 b7= -2,4375 1 1 1 1 1 1 1 1 Body(x3) Text(-) Text(-) Text(-) Text(-) HTML(+) HTML(+) HTML(+) HTML(+) x1 x2 + + + + x1x3 + + + + x2x3 + + + + x1x2x3 + + + + 101 209,5 25,25 52,375 -27,125 168 142,5 42 35,625 6,375 152,5 158 38,125 39,5 -1,375 126 184,5 31,5 46,125 -14,625 145,5 165 36,375 41,25 -4,875 Run 1 2 3 4 5 6 7 8 Regression 80,8 74,8 96,3 112,8 64,8 65,8 60,8 64,8 77,625 1,9375 6,0625 -13,5625 3,1875 -0,6875 -7,3125 -2,4375 64,8125 Regression Model y = 77.625 + 1.9375 x1 + 6.0625 X2 -13.5625 x3 + 3.1875 x1 x2 -0.6875 x1 x3 -7.3125 x2 x3 - 2.4375 x1 x2 x3 Interaction Effect Chart Example 42 36 57,5 74 Format of email heading has small effect Using detailed Email heading attracts much higher response rate when email is open 80 70 60 response rate Generic(-) Detailed(+) 50 40 30 20 10 0 Generic(-) Repeat Rate 1 Repeat Rate 2 46 38 34 38 56 59 68 80 25 27 22 32 21 23 19 33 Average RR 42 36 57,5 74 26 27 22 26 SD RR 5,656854 2,828427 2,12132 8,485281 1,414214 7,071068 1,414214 9,899495 375 x1 x2 x3 Heading & Email open Email open (Yes) Email open (No) Generic(-) Detailed(+)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.